Building Disaster Recovery Serviceguard Solutions Using Metrocluster with EMC SRDF

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/
# srvctl add instance -d hrdb -i hrdb1 -n SJC_1
# srvctl add instance -d hrdb -i hrdb2 -n SJC_2
After registering the database with the CRS sub-cluster on the remote site, you can run the srvctl
status command to view the health of the database.
Configuring the RAC MNP stack at the recovery cluster
The RAC database must be packaged as Serviceguard MNP packages. You must configure the
RAC MNP package to have a dependency on the site Clusterware sub-cluster MNP package. This
step creates the RAC MNP stack at the target site that is configured to be managed by the Site
Controller Package. For more information about configuring the RAC database in MNP packages,
see the Serviceguard Extension for Oracle RAC toolkit README.
114 Configuring Oracle RAC in SADTA