RACclone.htm
05-06-2002 Bikle
-----------------

9i RAC Database Clone

This paper describes some details associated with an effort
to copy a one instance 9i database from one host to another.
Also the paper describes how I transformed the database copy
into a two instance 9i RAC database.  The name of both the
source database and the target RAC database was "VIS".

Summary
-------

-Shutdown and backup the one-instance 9i database
-Install Sun Cluster 3.0 on target host
-Install Veritas VxVM and CVM 3.2 on target host
-Install Oracle 9.2 RAC on target host
  -Craft a file to set env variables (and then dot it)
  -Use runInstaller to create a Mickey-Mouse-throw-away database
-Copy datafile backups to target host
-Restore datafiles onto Veritas raw devices
-Use srvctl utility to configure shared configuration file
-Run a CREATE CONTROLFILE script
  -Craft an init.ora file
  -CREATE SPFILE
  -create a password file
  -set MAXINSTANCES to 2
  -CREATE CONTROLFILE
  -ALTER DATABASE OPEN RESETLOGS
  -Create redologs for THREAD 2
  -ALTER DATABASE ENABLE THREAD 2
-Run gsdctl start on both hosts
-Create listener.ora and start the listeners
-Create tnsnames.ora and test networking
-Test out use of srvctl to stop/start the database
-Debug problem with Net Services (SQL Net)

Details
-------

Shutdown and backup the one instance 9i database
Install Sun Cluster 3.0 on target host
Install Veritas VxVM and CVM 3.2 on target host
Install Oracle 9.2 RAC on target host
Copy datafile backups to target host
Restore datafiles into Veritas raw devices
Use srvctl utility to configure shared configuration file
Run a CREATE CONTROLFILE script
Run gsdctl start on both hosts
Create listener.ora and start the listeners
Create tnsnames.ora and test networking
Test out use of srvctl to stop/start the database
Debug problem with Net Services (SQL Net)