Building Disaster Recovery Serviceguard Solutions Using Metrocluster with 3PAR Remote Copy

1. Copy the first RAC database instance pfile from the source site to the target site first RAC
database instance node.
In this example, copy the RAC database instance pfile from the SFO_1 node to the SJC_1
node.
# cd /opt/app/oracle/product/10.2.0/db_1/dbs
# rcp -p inithrdb1.ora SJC_1:$PWD
The -p option retains the permissions of the file.
2. Set up 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's 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 content appears 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
Configuring Oracle RAC database in a SADTA 89