HP Serviceguard Toolkits for Database Replication Solutions manual

Page 11

Figure 4 Data Guard replication between RAC primary package and single-instance standby package

Figure 4 (page 11), shows a Data Guard configuration where the primary database is configured as an RAC and the standby database is a single-instance database. Both primary and standby databases are configured in separate Serviceguard clusters for high availability. The RAC primary is combined with the ODG toolkit and the SGeRAC toolkit in a single package. It is configured on Node 1 and Node 2 in the SG Cluster 1. The standby database is configured as a single-instance Serviceguard failover package on Node 1 and Node 2 in the SG Cluster 2. The standby database is combined with the ODG toolkit and the ECMT Oracle toolkit in a single package. Data Guard replication takes place from RAC primary to the single-instance standby database. These two clusters are independent, and packages cannot failover across clusters.

3.Data Guard replication between RAC primary and RAC standby.

Figure 5 Data Guard replication between RAC primary and RAC standby

Figure 5 (page 11), shows a Data Guard configuration where both primary and standby databases are configured in two different RAC setups. The RAC primary is configured on nodes 1 and 2 of SG Cluster 1 and the RAC standby is configured on nodes 1 and 2 of SG Cluster 2. These two clusters are not a part of a Continentalclusters. Data Guard replication takes place between the RAC primary and the RAC standby.

NOTE: Configure these two clusters using the ODG toolkit in a Continentalclusters environment to achieve automatic role management. For more information on how to configure clusters in a Continentalclusters environment, see “Continentalclusters environment” (page 12).

Supported configuration

11

Image 11
Contents HP Part Number Published August Edition Page Contents Glossary Index Introduction Advantages OverviewSingle-instance Oracle database Supported configurationDependencies 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 GuardHigh availability for data guard broker Setting up Oracle Data Guard toolkitInstalling and uninstalling Oracle Data Guard toolkit # swinstall -s depot path# 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 toolkitLimitations TroubleshootingPkg.conf command 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 clustersCmmakepkg -m ecmt/db2/db2 -m tkit/db2hadr/db2hadr pkg.conf Creating packagesTo provide high availability only to primary database Go to the /etc/cmcluster/hadrprimary directoryInstancename Hadrip And, $ cmmodpkg -e hadrpkg Managing packagesRunning packages Maintaining packages# cmhaltpkg packagename Halting packagesHost key verification failed. Lost connection Limitations Information to collect before contacting HP How to contact HPRelated information Typographic conventions Warranty informationHP authorized resellers Documentation feedbackTIP Node2# /usr/bin/ssh-keygen -t rsa Db2 get db cfg for db2 database name grep -i hardNode3# /usr/bin/ssh-keygen -t rsa Node3# /usr/bin/ssh-keygen -t dsaPage To add a new key to/home/user/.ssh/knownhosts Page Glossary Index