Disaster recovery rehearsal in Continentalclusters

7. Stop rehearsal package.

$) cmhaltpkg inv_rac10g_rhpkg

8. Restore replication environment for recovery.

First synchronize the secondary mirror copy with the primary mirror copy and then synchronize the

BC with the secondary mirror copy:

$) pairresync –g inv_rac10g_dg

$) export HORCC_MRCF=1

$) pairresync –g inv_rac10g_dg

$) unset HORCC_MRCF

9. Move the recovery group inv_rac10g_recgp out of maintenance mode.

$) cmrecovercl –e -g inv_rac10g_recgp

Note: Using the cmviewconcl command verify that the recovery group inv_rac10g_recgp is not in

maintenance mode.

10. Restore the VIP addresses that were original set up on the recovery cluster nodes.

On either HOUnode1 or HOUnode2, run the following command as root user.

$ export ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1

$ export PATH=$PATH:$ORACLE_HOME/bin

$) srvctl modify nodeapps -n HOUnode1 -A “VIP_Rec1_Addr”/<subnetmask>/lan0

$) srvctl modify nodeapps -n HOUnode2 -A “VIP_Rec2_Addr”/<subnetmask>/lan0

On either HOUnode1 or HOUnode2, run the following command as oracle user. From the the

command output, verify that on HOUnode1 the VIP address set up is VIP_Rec1_Addr, and on

HOUnode2 the VIP address set up is VIP_Rec2_Addr.

$) cluvfy comp nodecon -n all –verbose

On hosts HOUnode1 and HOUnode2, make necessary changes to /etc/hosts to associate the

host name with the original VIP address.

Rehearsing recovery of Oracle 9i RAC application

This use case describes the procedure to rehearse recovery of recovery group/s configured for Oracle

9i RAC application in Continentalclusters using EMC SRDF data replication. Unless explicitly

mentioned, the steps shown below can be executed from any node in the recovery cluster. It is

assumed that the primary packages sales_rac9i_primpkg_1 and sales_rac9i_primpkg_2 are up on

Atlanta cluster and replication is in progress.

1. Verify data replication environment.

Using the cmdrprev command, the preparation of data replication environment for an actual

recovery can be previewed.

Execute the following command on HOUnode1 for the recovery package. sales_rac9i_recpkg_1

and verify that the command returns a value 0.

#/usr/sbin/cmdrprev -e “/etc/sales_rac9i_recpkg_1_srdf.env”

Execute the following command on HOUnode2 for the recovery package. sales_rac9i_recpkg_2

and verify that the command returns a value 0.