HP Serviceguard Toolkits for Database Replication Solutions manual

Problem Scenario

Possible Cause

Recommended Action

1. Run db2 takeover hadr on db sample by force command on machine where the state of the DB2 HADR is one of the following states: remote catchup pending, peer or disconnected peer.

2. After the state changes to “peer”, run the db2 takeover hadr on db sample command on standby.

Limitations

This section lists the limitations of DB2 HADR toolkit in an HP Serviceguard Cluster:

1.Start the standby package before you start the primary package. DB2 HADR toolkit does not use the by force start command for primary database.

2.DB2 HADR toolkit handles the toolkit features at the instance level and not at the database level.

Limitations 45

Image 45

HP Serviceguard Toolkits for Database Replication Solutions manual Limitations

Contents

HP Part Number Published August Edition Page Contents Glossary Index Introduction Advantages Overview Supported configuration DependenciesSingle-instance Oracle database Cmmakepkg -i pkgasciifile -m modulefilename outputfilename RAC environment RAC environment Serviceguard 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 Guard Installing 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 toolkit For example, /etc/cmcluster/pkg/dgpkg Single-instance environment Setting up Oracle Data Guard toolkit #ecmt/oracle/oracle/LISTENERRESTART Servicefailfastenabled no servicehalttimeout For example, /etc/cmluster/pkg/racdgpkg RAC environment Where ocmnp is the Smnp package for Oracle CLusterware Maintaining Oracle Data Guard toolkit Adding the package to the Serviceguard cluster Single-instance environment Cluster verification for Oracle Data Guard toolkit Troubleshooting Pkg.conf commandLimitations Startstandbyasprimary to yes Prerequisites Supported configuration Using the DB2 Hadr toolkit Event 1 Standby database or Hadr goes down When primary and standby packages are in the same cluster Event 2 Primary package fails Primary and Standby Packages in Different Clusters When primary and standby packages are in different clusters To 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.conf Instancename Hadrip Running packages Managing packagesMaintaining packages And, $ cmmodpkg -e hadrpkg # cmhaltpkg packagename Halting packages Host key verification failed. Lost connection Limitations Information to collect before contacting HP How to contact HP HP authorized resellers Warranty informationDocumentation feedback Related information Typographic conventions TIP 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