HP Serviceguard Toolkits for Database Replication Solutions manual Three data center configuration

Page 17

NOTE: This configuration is supported both in single-instance and RAC environments. For better understanding, the packages in the Figure 9 (page 16) are shown for a single-instance database.

Three data center configuration

Figure 10 Single-instance Data Guard setup in a Continentalclusters environment where the primary cluster is configured as a Metrocluster

Figure 10 (page 17), describes a Continentalclusters setup with two clusters spread over three different sites. The primary cluster is configured as a Metrocluster spread over two different sites that are geographically dispersed within the confines of a metropolitan area. The recovery cluster is configured on the third site as a Serviceguard cluster.

The primary database of Data Guard setup is configured as a primary package in the primary cluster (Metrocluster instance). The primary cluster has two data centers (sites), each of which have a storage array for storing the data. Metrocluster enables data written to the primary site to be replicated to the recovery site and hence, the primary database instance can failover to any node within the primary cluster.

The standby database is configured as a Data Receiver package in the recovery cluster. It receives the archived redo logs sent by the primary database instance irrespective of the node on which the primary database is running. Cross subnet failover is allowed across the sites.

When the primary cluster fails, the user must run the cmrecovercl command to halt the Data Receiver package and start the recovery package. When you run this command, the recovery package starts and brings up the Oracle database as a primary database. Thus, the standby instance does not run, after the role of the database is changed to primary. Multiple standby configurations are not supported within a Continentalclusters setup. However, the ODG toolkit in Continentalclusters does not restrict you from configuring standby databases that are placed outside the Continentalclusters environment.

Supported configuration

17

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