HP Serviceguard Toolkits for Database Replication Solutions manual

Page 29

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

#

#"run_script_timeout" is the number of Seconds allowed for package to start.

#"halt_script_timeout" is the number of Seconds allowed for package to halt.

run_script_timeout600

halt_script_timeout700

Note:"halt_script_timeout" has to be more than the sum of

all the individual "service_halt_timeout"s of the "service_cmds". In SGeRAC toolkit this value is 600, by default.

Since the "service_halt_timeout"s for the service_cmds, "rac_check", and "dataguard_monitor" are each 300, a value larger than 600 has to be specified for "halt_script_timeout".

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

#"script_log_file" is the full path name for the package control script log

#file.

script_log_file/etc/cmluster/pkg/racdgpkg/pkg.log

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

#

#Define Oracle RAC instance package working directory

sgerac/erac_tk_rac/TKIT_DIR/etc/cmluster/pkg/racdgpkg

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

#Define Oracle RAC instance package script file directory

#

sgerac/erac_tk_rac/TKIT_SCRIPT_DIR/opt/cmcluster/SGeRAC/toolkit/racp

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

#

#Define Oracle Database name

sgerac/erac_tk_rac/ORACLE_DBNAMEorcl

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

#Define Oracle Home directory

#

sgerac/erac_tk_rac/ORACLE_HOME/var/orahome

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

#

#Define Oracle user

sgerac/erac_tk_rac/ORACLE_USERoracle

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

#Define Oracle start up mode

#

sgerac/erac_tk_rac/START_MODEmount

#

#The package dependency parameters are "dependency_name",

#"dependency_condition" and "dependency_location".

#

 

dependency_name

ocmnp

dependency_condition

ocmnp=up

dependency_location

SAME_NODE

(Where ocmnp is the SMNP package for Oracle CLusterware)

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

(NOTE: The following are the Service commands for the package)

service_name

racp_monitor_test

service_cmd

"$SGCONF/scripts/sgerac/erac_tk_rac.sh rac_check"

service_restart

none

service_fail_fast_enabled

no

service_halt_timeout

300

service_name

dataguard_service_test

service_cmd

"$SGCONF/scripts/tkit/dataguard/tkit_module.sh dataguard_monitor"

service_restart

none

service_fail_fast_enabled

no

service_halt_timeout

300

(NOTE: The following attributes are specific to the ODG toolkit)

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

#

#Define ACTIVE_STANDBY

tkit/dataguard/dataguard/ACTIVE_STANDBY no

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

#Define MONITOR_DG_BROKER

#

tkit/dataguard/dataguard/MONITOR_DG_BROKER no

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

#

#Define REAL_TIME_APPLY

tkit/dataguard/dataguard/REAL_TIME_APPLY no

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

#Define START_STANDBY_AS_PRIMARY

#

Setting up Oracle Data Guard toolkit 29

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