Building Disaster Recovery Serviceguard Solutions Using Metrocluster with Continuous Access EVA A.05.01
Configuring the identical RAC database
Complete the following procedure to configure the replica RAC database. Consider that the
database name is hrdb and the instance hrdb1 is the first instance on first node and hrdb2 is
second instance on second node of the source disk site.
To configure the identical RAC database:
1. Copy the first RAC database instance pfile and password file from the source site to the first
RAC database instance node in the target disk site.
In this example, run the following commands from the first node in site1:
# cd /opt/app/oracle/product/11.1.0/db_1/dbs
# rcp -p inithrdb1.ora <site2_node1>:$PWD
# rcp -p orapwhrdb1 <site2_node1>:$PWD
The -p option retains the permissions of the file.
2. Setup the first RAC database instance on the target disk site.
In this example, run the following commands from the first node in site2:
# cd /opt/app/oracle/product/11.1.0/db_1/dbs
# chown oracle:oinstall orapwhrdb1
# chown oracle:oinstall initrhrdb1.ora
3. Copy the second RAC database instance pfile and password file from the source site to the
second RAC database instance node in the target disk.
In this example, run the following commands from the second node in site1:
# cd /opt/app/oracle/product/11.1.0/db_1/dbs
# rcp -p inithrdb2.ora <site2_node2>:$PWD
# rcp -p orapwhrdb2 <site2_node2>:$PWD
The -p option retains the permissions of the file.
4. Set up the second RAC database instance on the target disk site.
In this example, run the following commands from the second node in site2:
# cd /opt/app/oracle/product/11.1.0/db_1/dbs
# chown oracle:oinstall orapwhrdb2
# chown oracle:oinstall inithrdb2.ora
5. Create the directory for the database (in this example “hrdb”) that is replicated at the target
disk site, in the Oracle admin directory.
cd /opt/app/oracle
rcp -r admin/hrdb <site2_node1>:$PWD
rcp -r admin/hrdb <site2_node2>:$PWD
6. Run the following command at the remote site.
chown -R oracle:oinstall /opt/app/oracle/admin/hrdb
7. Log in at any of the nodes in the remote site using the oracle user credentials.
su – oracle
8. Configure a listener for the database on this site using the Oracle Network Configuration
Assistant (NETCA).
9. 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 appear as follows:
# rcp <site1_node1>:$ORACLE_HOME/network/admin/tnsnames.ora
<site2_node1>:$ORACLE_HOME/network/admin/tnsnames.ora # rcp
124 Configuring Oracle RAC in SADTA