HP Serviceguard Toolkits for Database Replication Solutions manual

Page 18

NOTE: This configuration is supported both in single-instance and RAC environments. For better understanding, the packages in the Figure 10 (page 17) are shown for a single-instance database.

Configuring multiple instances of Oracle Data Guard

To support configuring Multiple instances of ODG single-instance/RAC databases, in one Serviceguard cluster, all the instances must be configured in such a way that they function independently. Each database must have different volume groups for storing the database and redo logs. It must use different Oracle database listeners and IP addresses or ports.

Figure 11 Multiple Data Guard instances in each Serviceguard cluster

Figure 11 (page 18), shows a supported configuration where two two-node Serviceguard clusters are configured to provide high availability to the Data Guard configurations. Two single-instance Data Guard primary databases are configured in Cluster 1 and one standby database is configured for each of the primary databases in Cluster 2. Both the clusters are independent of each other a package failover cannot occur between the two clusters. Both the primary database in Cluster 1 and the standby database in Cluster 2, and their corresponding redo logs are located on shared disks. Each database can be accessed from any nodes in their respective clusters. This enables failover of the primary and standby packages within the cluster, and provides high availability for both of them.

NOTE: This configuration is supported both in single-instance and RAC environments. For better understanding, the packages in the Figure 11 are shown for a single-instance database.

Benefits of Oracle Data Guard toolkit in various configurations

ODG toolkit configurations has the following benefits:

High availability for primary/secondary databases

Automation of start/stop of databases

Oracle Data Guard toolkit configuration in

Benefits

Extended Distance Cluster environment

It uses only one Serviceguard cluster. It stretches a Serviceguard

 

cluster across data centers up to 100 km apart and provides

 

protection against site outages.

Continentalclusters environment

It provides push button automated role takeover of the ODG

 

database.

Metrocluster environment

ODG databases can be configured for failover across two data

 

centers (which are up to 300 km apart) of the Metrocluster.

Three Data Center configuration

It provides data consistency of synchronous replication . It

 

protects against local and wide area disasters.

18 Serviceguard toolkit for Oracle Data Guard

Image 18
Contents HP Part Number Published August Edition Page Contents Glossary Index Introduction Overview AdvantagesSupported 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 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 environmentTroubleshooting Pkg.conf commandLimitations 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