Designing Disaster Recovery Clusters using Metroclusters and Continentalclusters, Reprinted October 2011 (5900-1881)

the disk groups and mount points are packaged using different packages at each site CFS
sub-cluster.
Table 29 lists the packages and other resources at each site.
Table 29 Sample Database Configuration
San JoseSan FranciscoSite Details
hrdb_devgrouphrdb_devgroupRAC HRDB RAID Device group
name
hrdbdghrdbdgRAC HRDB data files Disk
Group name
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, a Site Controller Package titled hrdb_sc must be created to provide automatic
site failover for the hrdb RAC database between San Francisco and San Jose. The RAC database
MNP packages must be configured using the critical_package attribute, and the CFS MP
MNP and CVM DG MNP database packages must be configured 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. The Site Controller Package can be configured to monitor
all the RAC MNP stack packages and initiate a site failover only when all the packages in the
stack have failed 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
This section describes the procedures that need to be followed to configure SADTA with Oracle
Database 10gR2 RAC.
To configure SADTA with Oracle Database 10gR2 RAC, complete the following steps:
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.
366 Designing a Disaster Recovery Solution Using Site Aware Disaster Tolerant Architecture