HP Serviceguard Toolkits for Database Replication Solutions manual

Page 38

3.If the RESTORE_ROLE package attribute is set to [yes], the original primary package performs a role switch to resume its role as the primary database. This automatically enables the original standby database to resume as the standby database.

4.If the RESTORE_ROLE package attribute is set to [no], the original primary (which is now standby), continues to run as standby.

When primary and standby packages are in different clusters

Figure 13 Primary and Standby Packages in Different Clusters

In this configuration, Figure 13 (page 38), two Serviceguard clusters, SG Cluster1 is configured for the primary package and SG Cluster2 is configured for the standby package. Node1 and Node2 shares the volume group on which the primary database is configured, primary package can run on both the nodes. Similarly, the standby database is configured on the volume group that is shared between Node3 and Node4. Standby package can run on both the nodes.

NOTE: For more information, see When Primary and Standby packages are in the same cluster for all the events listed.

38 Serviceguard toolkit for DB2 High Availability Disaster Recovery

Image 38

Contents HP Part Number Published August Edition Page Contents Glossary Index Introduction Overview AdvantagesSingle-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 Configuring multiple instances of Oracle Data Guard Multiple Data Guard instances in each Serviceguard cluster# swinstall -s depot path Setting up Oracle Data Guard toolkitInstalling and uninstalling Oracle Data Guard toolkit High availability for data guard broker# swlist -l product T2259AA Files for the ADF module Activestandby Configuring Oracle Data Guard toolkit Package attributesSingle-instance environment For example, /etc/cmcluster/pkg/dgpkgSetting up Oracle Data Guard toolkit #ecmt/oracle/oracle/LISTENERRESTART Servicefailfastenabled no servicehalttimeout RAC environment For example, /etc/cmluster/pkg/racdgpkgWhere ocmnp is the Smnp package for Oracle CLusterware Adding the package to the Serviceguard cluster Maintaining Oracle Data Guard toolkitCluster verification for Oracle Data Guard toolkit Single-instance environmentLimitations TroubleshootingPkg.conf command Startstandbyasprimary to yes Prerequisites Using the DB2 Hadr toolkit Supported configurationWhen primary and standby packages are in the same cluster Event 1 Standby database or Hadr goes downEvent 2 Primary package fails When primary and standby packages are in different clusters Primary and Standby Packages in Different ClustersGo to the /etc/cmcluster/hadrprimary directory Creating packagesTo provide high availability only to primary database Cmmakepkg -m ecmt/db2/db2 -m tkit/db2hadr/db2hadr pkg.confInstancename Hadrip Maintaining packages Managing packagesRunning packages And, $ cmmodpkg -e hadrpkgHalting packages # cmhaltpkg packagenameHost key verification failed. Lost connection Limitations How to contact HP Information to collect before contacting HPDocumentation feedback Warranty informationHP authorized resellers Related information Typographic conventionsTIP Node3# /usr/bin/ssh-keygen -t dsa Db2 get db cfg for db2 database name grep -i hardNode3# /usr/bin/ssh-keygen -t rsa Node2# /usr/bin/ssh-keygen -t rsaPage To add a new key to/home/user/.ssh/knownhosts Page Glossary Index