HP Serviceguard Toolkits for Database Replication Solutions manual RAC environment

Page 9

NOTE: The package parameter, START_MODE, must be set to mountwhen an ECMT Oracle toolkit is used in combination with an ODG toolkit.

For an Active Data Guard, the standby database is started up to the [open] state. Set the ACTIVE_STANDBY parameter to [yes], if you have purchased the optional license to enable Active Standby functionality in the Oracle Data Guard Enterprise Edition. Active Data Guard is supported in Oracle database version 11gR1 or later.

RAC environment

ODG can also be set up in an Oracle Real Application Clusters (RAC) environment. This architecture combining the scalability and availability advantages of RAC with the site protection capabilities of Data Guard is called Maximum Availability Architecture (MAA).

The standby can be an Oracle RAC or a single-instance Oracle database. SGeRAC can be used to improve the resilience of an Oracle RAC environment, providing a higher level of availability with more extensive monitoring of components that may fail.

NOTE: If the standby database is an RAC database, then only one of the standby instances can perform the recovery. For more information about configuring Oracle Data Guard in an RAC environment, see the Oracle website http://download.oracle.com/docs/cd/B19306_01/ server.102/b14239/rac_support.htm

Figure 2 RAC environment

In Figure 2 (page 9), the primary site contains the production database using Oracle RAC and the symmetric secondary site maintaining physical standby using ODG.

In an RAC environment, the ODG toolkit can be combined with the SGeRAC toolkit in a single package. In SGeRAC, we need to configure two MNPs – Oracle Clusterware MNP (OC MNP) and RAC database instance MNP (RAC MNP). The “OC MNP ” allows SGeRAC to start or stop Oracle Clusterware processes. The “RAC MNP ” allows SGeRAC to start/stop the RAC instances via Oracle Clusterware. The ODG toolkit must be implemented as an MNP with the SGeRAC’s RAC MNP. The SGeRAC’s RAC MNP provides high availability for the Oracle database processes. Similarly, the ODG toolkit manages the Data Guard processes.

The ODG toolkit supports the following use-cases in an RAC environment:

1.Data Guard replication between RAC primary package and single-instance, stand-alone standby database.

Supported configuration

9

Page 8 Page 10
Image 9
Page 8 Page 10
Contents HP Part Number Published August Edition Page Contents Glossary Index Introduction Advantages OverviewSupported configuration DependenciesSingle-instance Oracle database Cmmakepkg -i pkgasciifile -m modulefilename outputfilename RAC environment RAC environmentServiceguard toolkit for Oracle Data Guard Data Guard replication between RAC primary and RAC standby Continentalclusters environment Continentalclusters environment Metrocluster and extended distance cluster environments Supported configuration Data Guard setup in an EDC environment Three data center configuration Multiple Data Guard instances in each Serviceguard cluster Configuring multiple instances of Oracle Data GuardInstalling and uninstalling Oracle Data Guard toolkit Setting up Oracle Data Guard toolkit# swinstall -s depot path High availability for data guard broker# swlist -l product T2259AA Files for the ADF module Activestandby Package attributes Configuring Oracle Data Guard toolkitFor example, /etc/cmcluster/pkg/dgpkg Single-instance environmentSetting up Oracle Data Guard toolkit #ecmt/oracle/oracle/LISTENERRESTART Servicefailfastenabled no servicehalttimeout For example, /etc/cmluster/pkg/racdgpkg RAC environmentWhere ocmnp is the Smnp package for Oracle CLusterware Maintaining Oracle Data Guard toolkit Adding the package to the Serviceguard clusterSingle-instance environment Cluster verification for Oracle Data Guard toolkitTroubleshooting Pkg.conf commandLimitations Startstandbyasprimary to yes Prerequisites Supported configuration Using the DB2 Hadr toolkitEvent 1 Standby database or Hadr goes down When primary and standby packages are in the same clusterEvent 2 Primary package fails Primary and Standby Packages in Different Clusters When primary and standby packages are in different clustersTo provide high availability only to primary database Creating packagesGo to the /etc/cmcluster/hadrprimary directory Cmmakepkg -m ecmt/db2/db2 -m tkit/db2hadr/db2hadr pkg.confInstancename Hadrip Running packages Managing packagesMaintaining packages And, $ cmmodpkg -e hadrpkg# cmhaltpkg packagename Halting packagesHost key verification failed. Lost connection Limitations Information to collect before contacting HP How to contact HPHP authorized resellers Warranty informationDocumentation feedback Related information Typographic conventionsTIP Node3# /usr/bin/ssh-keygen -t rsa Db2 get db cfg for db2 database name grep -i hardNode3# /usr/bin/ssh-keygen -t dsa Node2# /usr/bin/ssh-keygen -t rsaPage To add a new key to/home/user/.ssh/knownhosts Page Glossary Index
Top Page Image Contents