Building Disaster Recovery Serviceguard Solutions Using Metrocluster with Continuous Access EVA A.05.01

In this example, a Site Controller Package titled hrdb_sc must be created to provide automatic
site failover for the hrdb RAC database between Site A and Site B. Configure the RAC database
MNP packages using the critical_package attribute, and then configure CFS MP MNP and
CVM DG MNP database packages using the managed_package attribute. As a result, the Site
Controller Package monitors only the RAC database MNP package and initiates a site failover
when it fails. You can configure the Site Controller Package to monitor all the RAC MNP stack
packages and initiate a site failover only when all the packages in the stack fails or the site itself
is lost in a disaster. In such a scenario, all RAC MNP stack packages must be configured with the
managed_package attribute and no package must be configured with the critical_package
attribute in the Site Controller Package configuration file.
Configuring SADTA
To configure SADTA with Oracle Database 10gR2 RAC:
1. Set up Replication.
2. Configure Metrocluster.
3. Install and Configure Oracle Clusterware.
4. Install and Configure Oracle Real Application Clusters (RAC).
5. Create the RAC database.
6. Create the identical RAC database at the remote site.
7. Configure the Site Controller Package and the Site Safety Latch.
8. Configure client access for Oracle Database 10gR2 RAC.
Setting up replication
The RAC database data files and the flash recovery area should be replicated between the site
disk arrays. Configure the underlying disks for replication. Create DR Groups for these disks using
Command View.
Configuring Metrocluster with sites
To configure SADTA, create a Serviceguard cluster that comprises nodes from both sites. In this
example, a Serviceguard cluster is created using nodes SFO_1, SFO_2, SJC_1, and SJC_2 and
describes a cross-subnet Serviceguard cluster.
To configure Metrocluster:
1. Create a Serviceguard cluster with two sites.
2. Configure the Cluster File System Multi-node Package (SMNP).
Creating a Serviceguard cluster with sites configured
To create a Serviceguard cluster with sites configured:
1. Run the following command to create a cluster configuration file from any node:
# cmquerycl -v -C /etc/cmcluster/dbcluster.config -n SFO_1 -n SFO_2\
-n SJC_1 -n SJC_2 -w full -q quorum.abc.com
where quorum.abc.com is the host name of the Quorum Server.
2. Edit the /etc/cmcluster/dbcluster.config file to specify the site configuration. The
following is a sample of the configuration file:
SITE_NAME san_francisco
SITE_NAME san_jose
NODE_NAME sfo_1
SITE san_francisco
NETWORK_INTERFACE lan2 #SG HB 1
HEARTBEAT_IP 192.1.3.1
NETWORK_INTERFACE lan3 #SG HB 2
HEARTBEAT_IP 192.1.5.1
NETWORK_INTERFACE lan4 #SFO_CRS CSS HB
STATIONARY_IP 192.1.7.1
104 Configuring Oracle RAC in SADTA