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

1. Run the cmviewcl command to view the disaster tolerant RAC database configuration in a
Metrocluster.
Following is a sample output:
cmviewcl
CLUSTER STATUS
dbcluster up
SITE_NAME san_francisco
NODE STATUS STATE
SFO_1 up running
SFO_2 up running
SITE_NAME san_jose
NODE STATUS STATE
SJC_1 up running
SJC_2 up running
MULTI_NODE_PACKAGES
PACKAGE STATUS STATE AUTO_RUN SYSTEM
SG-CFS-pkg up running enabled yes
sfo_crs_dg up running enabled no
sfo_crs_mp up running enabled no
sfo_crs up running enabled no
sjc_crs_dg up running enabled no
sjc_crs_mp up running enabled no
sjc_crs up running enabled no
sfo_hrdb_dg down halted enabled no
sfo_hrdb_mp down halted enabled no
sjc_hrdb_dg down halted enabled no
sjc_hrdb_mp down halted enabled no
sfo_flash_dg down halted enabled no
sfo_flash_mp down halted enabled no
sjc_flash_dg down halted enabled no
sjc_flash_mp down halted enabled no
sfo_hrdb down halted disabled no
sjc_hrdb down halted disabled no
UNOWNED_PACKAGES
PACKAGE STATUS STATE AUTO_RUN NODE
hrdb_sc down halted disabled unowned
2. Enable all nodes in the Metrocluster for the Site Controller Package.
cmmodpkg –e –n SFO_1 –n SFO_2 -n SJC_1 –n SJC_2 hrdb_sc
3. Start the Site Controller Package
cmmodpkg -e hrdb_sc
The Site Controller Package along with RAC stack will start up on local site (San Francisco).
4. Check the Site Controller Package log file to ensure clean startup.
Configuring Client Access for Oracle Database 10gR2 RAC
In Oracle Database 10gR2 RAC, the Oracle Clusterware configuration provides Virtual IP addresses
(VIPs) through which database clients external to the cluster connect to the database. Oracle listeners
gather information about service availability on the RAC servers and assist in making client
connections to the RAC instances. Additionally, they provide failure notifications and load advisories
to clients, thereby enabling fast failover of client connections and client-side load-balancing. These
capabilities are facilitated by an Oracle 10g feature called Fast Application Notification (FAN).
For more information on Fast Application Notification, see the following documents:
http://www.oracle.com/technology/products/database/clustering/pdf/twpracwkldmgmt.pdf
http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_ClientFailoverBestPractices.pdf
Configuring Oracle RAC Database in a Site Aware Disaster Tolerant Architecture 381