#rcp -p inithrdb1.ora <Site 3 node name 1>:$PWD

2.Setup the first RAC database instance on the recovery cluster.

In this example, run the following commands from the first RAC database instance node in Site 3.

#cd <Oracle_Home_directory>/dbs

#ln -s <cfs mount point>/oradata/hrdb/orapwhrdb orapwhrdb1

#chown -h oracle:oinstall orapwhrdb1

#chown oracle:oinstall inithrdb1.ora

3.Copy the second RAC database instance pfile from the Site 1 in the primary cluster to the recovery cluster second RAC database instance node.

#cd <Oracle_Home_directory>/dbs

#rcp -p inithrdb2.ora <Site 3 node name 2>:$PWD

The -p option retains the permissions of the file.

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.

456 Designing a Three Data Center Disaster Recovery Solution