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

Page 25

#Define the instance type

ecmt/oracle/oracle/INSTANCE_TYPE database

------------------------------------------------------------------------

#Define Oracle home

#

ecmt/oracle/oracle/ORACLE_HOME /var/orahome

------------------------------------------------------------------------

#

#Define user name of Oracle database administrator

ecmt/oracle/oracle/ORACLE_ADMIN oracle

------------------------------------------------------------------------

#Define oracle session name

#

ecmt/oracle/oracle/SID_NAME ORCL

------------------------------------------------------------------------

#

#Define Oracle database startup mode

ecmt/oracle/oracle/START_MODE mount

------------------------------------------------------------------------

#Define whether the database instance is using ASM or not

#

ecmt/oracle/oracle/ASM no

------------------------------------------------------------------------

#

#Define ASM disk groups used by the database instance

#ecmt/oracle/oracle/ASM_DISKGROUP

-----------------------------------------------------------------------

#Define the volume groups used in the ASM disk groups for the

#database instance

#

#ecmt/oracle/oracle/ASM_VOLUME_GROUP

------------------------------------------------------------------------

#

#The ASM home

#ecmt/oracle/oracle/ASM_HOME

------------------------------------------------------------------------

#Define user name of Oracle ASM administrator

#

ecmt/oracle/oracle/ASM_USER oracle

----------------------------------------------------------------------

#

#The ASM session name

#ecmt/oracle/oracle/ASM_SID

------------------------------------------------------------------------------

#Define whether the configured listener has to be started with the server

#

ecmt/oracle/oracle/LISTENER yes

------------------------------------------------------------------------

#

#Define the Oracle listener name(s)

ecmt/oracle/oracle/LISTENER_NAME LISTENER_ORCL

------------------------------------------------------------------------

#Define the listener password(s)

#

#ecmt/oracle/oracle/LISTENER_PASS

------------------------------------------------------------------------

#

#ecmt/oracle/oracle/LISTENER_RESTART

Setting up Oracle Data Guard toolkit 25

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