Designing Disaster Recovery Clusters using Metroclusters and Continentalclusters, Reprinted October 2011 (5900-1881)

1. Copy the first RAC database instance pfile and password file from the source site to the first
RAC database instance node in the target disk site.
In this example, run the following commands from the first node in site1:
cd /opt/app/oracle/product/11.1.0/db_1/dbs
rcp -p inithrdb1.ora <site2_node1>:$PWD
rcp -p orapwhrdb1 <site2_node1>:$PWD
The -p option retains the permissions of the file.
2. Setup the first RAC database instance on the target disk site.
In this example, run the following commands from the first node in site2:
cd /opt/app/oracle/product/11.1.0/db_1/dbs
chown oracle:oinstall orapwhrdb1
chown oracle:oinstall initrhrdb1.ora
3. Copy the second RAC database instance pfile and password file from the source site to the
second RAC database instance node in the target disk.
In this example, run the following commands from the second node in site1:
cd /opt/app/oracle/product/11.1.0/db_1/dbs
rcp -p inithrdb2.ora <site2_node2>:$PWD
rcp -p orapwhrdb2 <site2_node2>:$PWD
The -p option retains the permissions of the file.
4. Set up the second RAC database instance on the target disk site.
In this example, run the following commands from the second node in site2:
cd /opt/app/oracle/product/11.1.0/db_1/dbs
chown oracle:oinstall orapwhrdb2
chown oracle:oinstall inithrdb2.ora
5. Create the directory for the database (in this example “hrdb”) that is replicated at the target
disk site, in the Oracle admin directory.
cd /opt/app/oracle
rcp -r admin/hrdb <site2_node1>:$PWD
rcp -r admin/hrdb <site2_node2>:$PWD
6. Run the following command at the remote site.
chown -R oracle:oinstall /opt/app/oracle/admin/hrdb
7. Log in at any of the nodes in the remote site using the oracle user credentials.
su – oracle
8. Configure a listener for the database on this site using the Oracle Network Configuration
Assistant (NETCA).
9. Copy the tnsnames.ora file from the remote CRS sub-cluster and modify it to fit the local
environment.
In this example, the file contents would appear as follows:
rcp <site1_node1>:$ORACLE_HOME/network/admin/tnsnames.ora
<site2_node1>:$ORACLE_HOME/network/admin/tnsnames.ora
rcp <site1_node2>:$ORACLE_HOME/network/admin/tnsnames.ora
<site2_node2>:$ORACLE_HOME/network/admin/tnsnames.ora
Configuring Oracle RAC Database with ASM in a Site Aware Disaster Tolerant Architecture 389