HP Serviceguard Toolkits for Database Replication Solutions manual Single-instance environment

Page 31

Single-instance environment

NOTE: In the example the package name is considered to be dgpkg, and the package directory is

/etc/cmcluster/pkg/dgpkg, and the ORACLE_HOME is configured as /orahome.

1.To disable the failover of the package, enter following command at the prompt: $ cmmodpkg -d dgpkg

2.To pause the monitor script, create an empty file /etc/cmcluster/pkg/dgpkg/ dataguard.debugby entering the command:

$ touch /etc/cmcluster/pkg/dgpkg/dataguard.debug

NOTE: Toolkit monitor scripts (both database instance and listener monitoring scripts), which continuously monitor ODG process daemons' processes, now stops monitoring these processes. The message, “Serviceguard Toolkit for ODG pausing Data Guard monitoring and entering maintenance mode” appears in the Serviceguard Package log file.

3.If required, to stop the database instance(s), enter the following commands at prompt: $ cd /etc/cmcluster/pkg/dgpkg/

$ $PWD/hadg.sh stop

4.Perform maintenance actions

For example, Database maintenance.

5.If you manually stopped the Oracle database instance before maintenance, start it again by entering following command at the prompt:

$ cd /etc/cmcluster/pkg/dgpkg/ $ $PWD/hadg.sh start

6.To allow monitoring scripts to continue normally again enter following command at the prompt: $ rm -f /etc/cmcluster/pkg/dgpkg/dataguard.debug

The message “Starting ODG monitoring again after maintenance” appears in the Serviceguard Package Control script log.

7.Enable the package failover

$ cmmodpkg -e dgpkg

RAC environment

The ODG package in an RAC Environment can be put into maintenance mode the same way it is done in a Single Instance environment. However, if the CRS package goes into maintenance mode, SGeRAC DB toolkit module (which is dependant on the CRS package) also goes into maintenance and hence, stops monitoring the database. You must manually set the maintenance mode because the ODG toolkit does not go into the maintenance mode automatically.

NOTE: If a package failure occurs during maintenance operations, the package does not automatically failover to an adoptive node. You must manually start the package on the adoptive node. For more information on manually starting the package on an adoptive node, see the Managing HP Serviceguard guide available at http://www.hp.com/go/hpux-serviceguard-docs

Cluster verification for Oracle Data Guard toolkit

Cluster verification is a proactive mechanism for identifying cluster inconsistencies that adversely affect toolkit package failover to a node. It checks for Serviceguard, ODG toolkit and Oracle database versions on all package nodes of the cluster. If there are any inconsistencies, cluster

Cluster verification for Oracle Data Guard toolkit 31

Image 31
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 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 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 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