the disk groups and mount points are packaged using different packages at each site CFS
Table 29 lists the packages and other resources at each site.
Table 29 Sample Database Configuration
Site Details | San Francisco | San Jose |
|
|
|
RAC HRDB RAID Device group | hrdb_devgroup | hrdb_devgroup |
name |
|
|
|
|
|
RAC HRDB data files Disk | hrdbdg | hrdbdg |
Group name |
|
|
|
|
|
RAC flash area CVM Disk | flashdg | flashdg |
Group name |
|
|
|
|
|
RAC Database Name | HRDB | HRDB |
|
|
|
RAC Instances Instance @ Node | hrdb1@ SFO_1 | hrdb1@ SJC_1 |
| hrdb2@ SFO_2 | hrdb2@ SJC_2 |
|
|
|
RAC Home | /opt/app/oracle/product/10.2.0/db | /opt/app/oracle/product/10.2.0/db |
|
|
|
RAC MNP package name | sfo_hrdb | sjc_hrdb |
|
|
|
RAC HRDB data mount point | /cfs/rac/ | /cfs/rac/ |
|
|
|
RAC HRDB data MP MNP | sfo_hrdb_mp | sjc_hrdb_mp |
|
|
|
RAC HRDB data DG MNP | sfo_hrdb_dg | sjc_hrdb_dg |
|
|
|
RAC flash area mount point | /cfs/flash | /cfs/flash |
|
|
|
RAC flash area MP MNP | sfo_flash_mp | sjc_flash_mp |
|
|
|
RAC flash area DG MNP | sfo_flash_dg | sjc_flash_dg |
|
|
|
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