HP Serviceguard Toolkits for Database Replication Solutions manual Introduction

Page 5

1 Introduction

The HP Serviceguard Toolkits for Database Replication Solutions User Guide includes the HP Serviceguard toolkit for Oracle Data Guard (ODG toolkit) and the HP Serviceguard toolkit for DB2 High Availability Disaster Recovery (DB2 HADR toolkit).

NOTE: The product name used for the depot is “Serviceguard Disaster Recovery Toolkits for Databases”. However, the product name was changed to “HP Serviceguard Toolkits for Database Replication Solutions” to match the functionality delivered.

The Database Replication Solutions complement existing active/standby configurations for databases in high availability clusters. In general, these database replication services require additional software to be licensed (and often purchased). For instance, Oracle Data Guard is not free with Enterprise versions of Oracle database and need to be licensed separately. DB2 HADR is also a licensed product. For more details, please look at the vendor documentation.

In case of DB2 database active/standby configurations within a High Availability (HA) cluster can take time following a failover because a database may take time to recover before becoming available. The DB2 HADR toolkit brings new advantages, allowing a replica of the database to be placed elsewhere, thus providing some disaster recovery, as well as can bring a standby online faster than it might take for an active/standby configuration to start.

The ODG toolkit facilitates easy integration of Oracle Data Guard in an HP Serviceguard cluster for improved high availability and disaster recovery for an Oracle database. This toolkit consists of scripts used to manage the Oracle Data Guard primary and standby database instances.

DB2 HADR toolkit enables you to configure the DB2 primary and standby database as two Serviceguard packages. It also provides role management features, such as role takeover and role switch for DB2 HADR.

NOTE:

The HP Serviceguard Toolkits for Database Replication Solutions User Guide was formerly known as the HP Serviceguard toolkit for Oracle Data Guard.

The ODG toolkit is available with both HP-UX 11i v2 and HP-UX 11iv3 releases. The DB2 HADR toolkit is available only with 11iv3 release.

5

Image 5
Contents HP Part Number Published August Edition Page Contents Glossary Index Introduction Advantages OverviewSingle-instance Oracle database Supported configurationDependencies 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 toolkitLimitations TroubleshootingPkg.conf command 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