HP Serviceguard Toolkits for Database Replication Solutions manual

Page 8

The Oracle database is started using the ECMT Oracle toolkit. The Data Guard processes are then started using the ODG toolkit, after which, the application is monitored.

If either the Oracle database or any of the Data Guard processes fail, the package fails over because the Oracle database and the Data Guard are integrated in a single package.

NOTE: You must create separate packages for each primary and standby database because the primary database and all the standby databases are configured in separate clusters.

Configuring an ODG toolkit involves two scenarios:

1.If a customer already has an existing ECMT Oracle toolkit package configured and wants to convert the Oracle database into a Data Guard setup:

•If the ECMT Oracle package is a legacy-style package, halt and discard the package. Create a new package using both ECMT Oracle toolkit module and ODG toolkit module. This is because the ODG toolkit does not support Legacy packaging.

cmmakepkg –m ecmt/oracle/oracle –m tkit/dataguard/dataguard <pkg_file_name>

•If the ECMT Oracle package is a modular-style package, first halt the package, and then insert Data Guard module using the following command:

cmmakepkg –i <pkg_ascii_file> -m <module_file_name> <output_file_name>

where:

◦pkg_ascii_file is the package file of the existing ECMT Oracle package. This can be generated using the command cmgetconf –p <pkg_name> <pkg_ascii_file>

◦module_file_name is the name of the module to be included in the running package. In case of Data Guard package, it's value is tkit/dataguard/ dataguard.

◦output_file_name is the template file that gets generated with the values of the ECMT Oracle database module populated in it. The user must edit this file and enter values for the Data Guard specific package attributes, and then apply the package using the cmapplyconf command.

•Re-apply the package after editing the Package Configuration file, and then run the newly applied package using cmrunpkg command.

2.If you do not have an ECMT Oracle package running and want to create a fresh Data Guard package, use the following command to create a package:

cmmakepkg –m ecmt/oracle/oracle –m tkit/dataguard/dataguard <pkg_file_name>

where:

•ecmt/oracle/oracle is the Oracle toolkit module shipped with ECMT Oracle toolkit.

•tkit/dataguard/dataguard is the Data Guard toolkit module shipped with the ODG toolkit.

•pkg_file_name is the template file that is generated. You must edit this file and enter values for the ECMT Oracle specific package attributes and the Data Guard specific package attributes. To create the package apply the file using cmapplyconf command.

8Serviceguard toolkit for Oracle Data Guard

Page 7 Page 9
Image 8
Page 7 Page 9
Contents HP Part Number Published August Edition Page Contents Glossary Index Introduction Overview AdvantagesSingle-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 Configuring multiple instances of Oracle Data Guard Multiple Data Guard instances in each Serviceguard clusterSetting up Oracle Data Guard toolkit Installing and uninstalling Oracle Data Guard toolkit# swinstall -s depot path High availability for data guard broker# swlist -l product T2259AA Files for the ADF module Activestandby Configuring Oracle Data Guard toolkit Package attributesSingle-instance environment For example, /etc/cmcluster/pkg/dgpkgSetting up Oracle Data Guard toolkit #ecmt/oracle/oracle/LISTENERRESTART Servicefailfastenabled no servicehalttimeout RAC environment For example, /etc/cmluster/pkg/racdgpkgWhere ocmnp is the Smnp package for Oracle CLusterware Adding the package to the Serviceguard cluster Maintaining Oracle Data Guard toolkitCluster verification for Oracle Data Guard toolkit Single-instance environmentLimitations TroubleshootingPkg.conf command Startstandbyasprimary to yes Prerequisites Using the DB2 Hadr toolkit Supported configurationWhen primary and standby packages are in the same cluster Event 1 Standby database or Hadr goes downEvent 2 Primary package fails When primary and standby packages are in different clusters Primary and Standby Packages in Different ClustersCreating packages To provide high availability only to primary databaseGo to the /etc/cmcluster/hadrprimary directory Cmmakepkg -m ecmt/db2/db2 -m tkit/db2hadr/db2hadr pkg.confInstancename Hadrip Managing packages Running packagesMaintaining packages And, $ cmmodpkg -e hadrpkgHalting packages # cmhaltpkg packagenameHost key verification failed. Lost connection Limitations How to contact HP Information to collect before contacting HPWarranty information HP authorized resellersDocumentation feedback Related information Typographic conventionsTIP Db2 get db cfg for db2 database name grep -i hard Node3# /usr/bin/ssh-keygen -t rsaNode3# /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
Top Page Image Contents