HP Serviceguard Toolkits for Database Replication Solutions Maintaining Oracle Data Guard toolkit

Page 30

tkit/dataguard/dataguard/START_STANDBY_AS_PRIMARY no

------------------------------------------------------------------------

#

#Define e-mail address for sending alerts

#tkit/dataguard/dataguard/ALERT_MAIL_ID

------------------------------------------------------------------------

Adding the package to the Serviceguard cluster

After the setup is complete, add the package to the Serviceguard cluster, and then start the cluster.

$ cmapplyconf -P dgpkg.conf

$ cmmodpkg -e -n <node1> —n <node2> dgpkg

$ cmmodpkg -e dgpkg

For more information on adding a package to the cluster, see the Managing HP Serviceguard manual available at: http://www.hp.com/go/hpux-serviceguard-docs

Maintaining Oracle Data Guard toolkit

Sometimes the ODG database instances are taken down for maintenance purposes, like changing configuration without migrating the instance to standby node. The toolkit maintenance option is enabled only when the configuration variable MAINTENANCE_FLAG is set to [yes] in the toolkit configuration file.

NOTE: The toolkit maintenance feature is different from the Serviceguard’s package maintenance feature.

30 Serviceguard toolkit for Oracle Data Guard

Image 30

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