HP Serviceguard Toolkits for Database Replication Solutions manual Supported configuration

Page 15

While Metrocluster provides storage-based data replication across metropolitan distances, organizations often like to build in additional data replicas, either locally or at other data centers. When you perform both storage and ODG replication, it helps to safeguard customer data. ODG protects against logical errors, while storage replication replicates any errors to the other replica. For example, a dropped table.

The integration of ODG with Metrocluster or EDC gives organizations the choice to use storage replication for Oracle and for all other application data.

The primary database can be configured inside a Metrocluster or an Extended Distance Cluster. The standby database can be configured outside the Metrocluster/Extended Distance Cluster as a standalone database or as part of a Serviceguard cluster.

For information about setting up Metrocluster, see the document Designing Disaster Recovery HA Clusters Using Metrocluster and Continentalclusters Manual available at http://www.hp.com/go/ hpux-serviceguard-docs.

Figure 8 Single-instance Data Guard configuration in Metrocluster with standby database residing outside Metrocluster

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

In Figure 8 (page 15), Metrocluster is configured with two data centers; Data Center 1 as the primary site, and Data Center 2 as the recovery site. The Data Guard primary database instance is configured in Data Center 1, so that the archived logs and the primary database reside on the disk that is shared locally between the nodes in that data center. The primary database instance is started on any one node in Data Center 1, while other nodes in the data center are the backup nodes for that instance. The data written to the storage array in Data Center 1 can be replicated to the storage array located in Data Center 2 using array-based replication technology. It is not necessary to configure the standby database in Data Center 2 because the data replication is done by the Metrocluster solution.

The standby database instance is configured at a third location (for example site 3), which is not configured within the Metrocluster environment. The third location is a separate Serviceguard

Supported configuration

15

Image 15
Contents HP Part Number Published August Edition Page Contents Glossary Index Introduction Advantages OverviewSupported 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 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 toolkitTroubleshooting Pkg.conf commandLimitations 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