HP Serviceguard Toolkits for Database Replication Solutions manual Continentalclusters environment

Page 13

Figure 6 Continentalclusters environment

In Oracle single-instance environment, Figure 6 (page 13), all the three packages (Primary, Data receiver, and Recovery packages) are configured as failover packages. When the primary database fails, the Serviceguard configured on the primary cluster fails over the database to another node within the primary cluster, thus providing high availability to the primary database. Similarly, if the standby database fails, then the Serviceguard configured on the recovery cluster allows the database to failover to another node within the recovery cluster. When the primary cluster is down, the administrator must run the cmrecovercl command on the recovery cluster to bring up the recovery package. This command halts the Data Receiver package, which in turn halts the standby database. It then runs the recovery package, which brings up the database as a primary database by performing a role failover. In this case, ODG toolkit handles role management. The start up time of a recovery package is usually double than the start up time for an ordinary database package. This is because the recovery package runs role transition commands which involves shutting down the database after the role is changed and restarting the database. Hence, start_script_timeout parameter in the package configuration should be specified appropriately.

Restoring the cluster in a Continentalclusters to its original state is a manual process. The following steps must be performed to restore the clusters to their original state:

1.Halt the recovery package — stops the database and the recovery package

2.Resync primary database from the standby database.

3.Start the primary package— brings up the database on primary cluster as a primary database

4.Start the Data Receiver package— brings up the database on the recovery cluster as a standby database

RAC Environment

Supported configuration

13

Image 13
Contents HP Part Number Published August Edition Page Contents Glossary Index Introduction Advantages OverviewDependencies 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 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 toolkitPkg.conf command TroubleshootingLimitations 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