Sunday, May 20, 2012

RAC cloning : 2 node to 2 node in the same host

Step1: Create a duplicate stand alone database from the RAC db follow the steps in
Step2: Follow the notes as described in Note ID: [ ID 747457.1 ]


  • Modify the single instance pfile for the RAC specific parameters 

*.cluster_database = TRUE

*.cluster_database_instances = 2 
*.undo_management=AUTO 
prod1.undo_tablespace=UNDOTBS1
prod1.instance_name=prod1
prod1.instance_number=1 
prod1.thread=1 
<prod1.local_listener=listener_ocvmrh2103>
<prod2.local_listener=listener_ocvmrh2190>
prod1.remote_listener=<scan listener>
prod2.remote_listener=<scan listener>
prod2.instance_name=prod2 prod2.instance_number=2  prod2.thread=2  prod2.undo_tablespace=UNDOTBS2

  • create spfile from pfile
export ORACLE_SID=PROD1
sqlplus "/ as sysdba"
create spfile='+DATA/PROD/spfilePROD.ora' from pfile='/tmp/initPROD.ora';
exit

  • Create the password file for instance1
orapwd file=orapwORCL1 password=oracle
  • start the database in mount stage
export ORACLE_SID=prod1 <this is most important one instance 1>

  • Open your database and run $ORACLE_HOME/rdbms/admin/catclust.sql to create cluster database specific views.
  • Now can start ur 2nd instance follow the same steps as earlier i.e. export ORACLE_SID=<instance 2> create a password file for 2nd instance and start the second instance.
  • Add the newly created RAC database to cluster
  • srvctl add database -d <database name> -o <ORACLE_HOME path> -p <spfile location and name>
  • srvctl add instance -d <database name> -i <instance 1 name> -n <node 1 name > srvctl add instance -d <database name> -i <instance 2 name> -n <node 2 name >






No comments:

Post a Comment