HP Serviceguard Toolkits for Database Replication Solutions manual

Page 10

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

Figure 3 (page 10), shows a Data Guard configuration where the primary database is Oracle RAC and the standby is a single-instance database instance. The RAC primary is configured on nodes 1 and 2 of the SG cluster 1.

NOTE: There can be more than two nodes in a cluster.

In the above mentioned example, we have taken two nodes, for better understanding. The standby database is not a part of a Serviceguard cluster. It is present outside SG cluster 1. Data Guard replication takes place between the primary RAC and the standalone standby. Each instance of the primary database transmits its redo data to an instance of the standby database. The role of the standby package is to receive the redo logs from the RAC primary and apply them to the database. In this case, high availability is not provided for the standby. In case the standby package fails, data replication stops.

The RAC primary database is configured by combining the ODG toolkit and SGeRAc toolkit in a single package. The RAC primary package fails only when all the primary database instances fail.

2.Data Guard replication between RAC primary package and single-instance standby package.

10 Serviceguard toolkit for Oracle Data Guard

Image 10
Contents HP Part Number Published August Edition Page Contents Glossary Index Introduction Overview AdvantagesDependencies Supported configurationSingle-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 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 environmentPkg.conf command TroubleshootingLimitations 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