HP Serviceguard Toolkits for Database Replication Solutions Setting up Oracle Data Guard toolkit

Page 19

NOTE: These configurations are applicable both in single-instance and RAC environment.

High availability for data guard broker

High availability for Data Guard Broker is supported only on RAC and not on single-instance database because Oracle does not support high availability for Data Guard Broker with vendor clusterware for single-instance Oracle database.

If the value of MONITOR_DG_BROKER attribute is set to [yes] and the ODG toolkit is used in combination with the SGeRAC toolkit, the ODG toolkit starts the broker and monitors the DMON process. DMON is an Oracle background process that runs for every database instance that is managed by the broker. When you start the Data Guard broker, a DMON process is created.

HP recommends that you disable the “Fast Start Failover ” feature, while using the ODG toolkit with ODG Broker in a Continentalclusters environment.

NOTE:

•If the broker process (DMON) fails, then the ODG toolkit does not failover the package. After trying to restart it twice, a message is logged in the package log file to notify the user about the failure of the Broker process.

•If MONITOR_DG_BROKER is set to [yes], the toolkit does not monitor the mrp (or lsp) process on physical standby database (or logical standby database).

Setting up Oracle Data Guard toolkit

Perform the following tasks to set up the ODG toolkit:

1.Install the ODG toolkit

2.Configure the ODG toolkit

3.Add the package to the Serviceguard cluster In this User guide, it is considered that:

1.Oracle is installed on all the nodes of the cluster.

2.Oracle Data Guard databases (primary and standby) are configured.

3.Storage is already configured.

For information on configuring ODG, see the Oracle website http://www.oracle.com.

Installing and uninstalling Oracle Data Guard toolkit

The ODG toolkit is part of the HP Serviceguard Toolkits for Database Replication Solutions and is available on installing HP Serviceguard Toolkits for Database Replication Solutions.

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.

To install HP Serviceguard Toolkits for Database Replication Solutions:

1.Run the command:

# swinstall -s <depot path>

The “SD Install - Software Selection” user interface appears where you can select the product that you want to install.

2.On the “SD Install - Software Selection” screen, mark the product, “T2259AA”.

3.To mark the product for installation:

Setting up Oracle Data Guard toolkit 19

Page 18 Page 20
Image 19
Page 18 Page 20
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
Top Page Image Contents