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

The -p option retains the permissions of the file.
2. Setup the first RAC database instance on the target site.
In this example, run the following commands from the SJC_1 node.
cd /opt/app/oracle/product/10.2.0/db_1/dbs
ln -s /cfs/rac/oradata/hrdb/orapwhrdb orapwhrdb1
chown -h oracle:oinstall orapwhrdb1
chown oracle:oinstall inithrdb1.ora
3. Copy the second RAC database instance pfile from the source site to the target site second
RAC database instance node.
In this example, copy the RAC database instance pfile from the SFO_2 node to the SJC_2
node.
cd /opt/app/oracle/product/10.2.0/db_1/db
rcp -p inithrdb2.ora SJC_2:$PWD
The -p option retains the permissions of the file.
4. Set up the second RAC database instance on the target site.
In this example, run the following commands from the SJC_2 node.
cd /opt/app/oracle/product/10.2.0/db_1/dbs
ln -s /cfs/rac/oradata/hrdb/orapwhrdb orapwhrdb2
chown oracle:oinstall inithrdb2.ora
chown -h oracle:oinstall orapwhrdb2
5. Create the Oracle admin directory at the target site.
cd /opt/app/oracle
rcp -r admin SJC_1:$PWD
rcp -r admin SJC_2:$PWD
Run the following command at the remote site.
chown -R oracle:oinstall /opt/app/oracle/admin
6. Log in at any of the nodes in the remote site using the oracle user credentials.
su – oracle
7. Configure a listener for the database on this site using the Oracle Network Configuration
Assistant (NETCA).
8. 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 SFO_1:$ORACLE_HOME/network/admin/tnsnames.ora
SJC_1:$ORACLE_HOME/network/admin/tnsnames.ora
rcp SFO_2:$ORACLE_HOME/network/admin/tnsnames.ora
SJC_2:$ORACLE_HOME/network/admin/tnsnames.ora
9. Edit the tnsnames.ora file on the local nodes and modify the HOST = keywords to specify
node names of this site.
In this example, you must edit the tnsnames.ora file on the local nodes, SJC_1 and SJC_2.
10. Register the database with the CRS sub-cluster on remote site.
srvctl add database -d hrdb -o /opt/app/oracle/product/10.2.0/db_1/
Configuring Oracle RAC Database in a Site Aware Disaster Tolerant Architecture 377