Building Disaster Recovery Serviceguard Solutions Using Metrocluster with Continuous Access for P9000 and XP A.11.00

4. Set up the second RAC database instance on the recovery cluster.
In this example, run the following commands from the second RAC database instance node
in Site 3.
# cd <Oracle_Home_directory>/dbs
# ln -s <cfs mount point>/oradata/hrdb/orapwhrdb orapwhrdb2
# chown oracle:oinstall inithrdb2.ora
# chown -h oracle:oinstall orapwhrdb2
5. Create the Oracle admin directory on the nodes in Site 3.
Run the following commands from a node in Site 1:
# cd /opt/app/oracle
# rcp -r admin <Site 3 node 1>:$PWD
# rcp -r admin <Site 3 node 2>:$PWD
Run the following command on all the nodes in the recovery cluster:
# chown -R oracle:oinstall /opt/app/oracle/admin
6. Log in at any of the nodes in the recovery cluster using the oracle user credentials.
# su – oracle
7. Configure a listener for the database on the recovery cluster using the Oracle Network
Configuration Assistant (NETCA).
8. Copy the tnsnames.ora file from the Site 1 CRS sub-cluster in the primary cluster and modify
it to suit the recovery cluster environment.
# rcp <Site 1 node 1>:<Oracle home
directory>/network/admin/tnsnames.ora
<Site 3 node 1>:<Oracle_Home_directory>/network/admin/tnsnames.ora
# rcp <Site 1 node
2>:<Oracle_Home_directory>/network/admin/tnsnames.ora
<Site 3 node 2>:<Oracle_Home_directory>/network/admin/tnsnames.ora
9. Edit the tnsnames.ora file on the nodes in the recovery cluster and modify the HOST =
keywords to specify the node names of the recovery cluster.
10. Register the database with the CRS cluster in the recovery cluster.
# srvctl add database -d hrdb -o <Oracle_Home_directory>
# srvctl add instance -d hrdb -i hrdb1 -n <site 3 node 1>
# srvctl add instance -d hrdb -i hrdb2 -n <site 3 node 2>
After registering the database with the CRS cluster in the recovery cluster, you can run the srvctl
status command to view the health of the database.
Configure the RAC MNP Stack at the recovery cluster
The RAC database must be packaged as a Serviceguard MNP package. You must configure the
RAC MNP package to have a dependency on the Clusterware MNP package in the recovery
cluster. This step creates the RAC MNP stack at the recovery cluster that will be configured to be
managed by the Site Controller Package. For more information on configuring the RAC database
in MNP packages, see the Serviceguard Extension for Oracle RAC toolkit README.
Test the RAC database in the recovery cluster
It is recommended that you test the RAC database startup in the recovery cluster after the RAC
MNP stack is configured by completing the following tasks:
1. Halt the Site Controller Package in the primary cluster
2. Start the RAC database in the recovery cluster
Deploying a Complex Workload in Three Data Center Solution using SADTA 135