Building Disaster Recovery Serviceguard Solutions Using Metrocluster with EMC SRDF

In this example, create a Site Controller Package titled hrdb_sc 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 must be replicated between the site disk
arrays.
1. Configure the underlying disks for replication.
2. Create SRDF device groups using SYMCLI.
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.
This example 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 on any node, to create a cluster configuration file:
# 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
104 Configuring Oracle RAC in SADTA