Building Disaster Recovery Serviceguard Solutions Using Metrocluster with 3PAR Remote Copy

Table 16 Sample database configuration (continued)
Site BSite ASite Details
flashdgflashdgRAC flash area CVM Disk
Group name
HRDBHRDBRAC Database Name
hrdb1@ SJC_1
hrdb2@ SJC_2
hrdb1@ SFO_1
hrdb2@ SFO_2
RAC Instances Instance @ Node
/opt/app/oracle/product/10.2.0/db/opt/app/oracle/product/10.2.0/dbRAC Home
sjc_hrdbsfo_hrdbRAC MNP package name
/cfs/rac//cfs/rac/RAC HRDB data mount point
sjc_hrdb_mpsfo_hrdb_mpRAC HRDB data MP MNP
sjc_hrdb_dgsfo_hrdb_dgRAC HRDB data DG MNP
/cfs/flash/cfs/flashRAC flash area mount point
sjc_flash_mpsfo_flash_mpRAC flash area MP MNP
sjc_flash_dgsfo_flash_dgRAC flash area DG MNP
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. Configure the underlying disks for replication. Create Remote Copy volume groups for
these disks using HP 3PAR Management Console GUI.
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:
Configuring Oracle RAC database in a SADTA 79