############################################################################### # # # Oracle8i Data Guard, Release 3.x # # # # (c) Copyright 2001 Oracle Corporation. All rights reserved. # # # ############################################################################### # # @(#)dgd_SAMPLE.ora 3.1 3.0.2 - 01/04/02 11:28:18 # # Data Guard Configuration File # # For complete details regarding Oracle8i Data Guard parameters and how to # set them, consult the Oracle8i Data Guard documentation. # # DO NOT REMOVE OR COMMENT OUT ANY UNCOMMENTTED LINES # DO NOT USE ANY ENVIRONMENT VARIABLES OTHER THAN THE DATAGUARD VARIABLES # ############################################################################### # # Configuration File Sections # --------------------------- # This Data Guard configuration file is divided into 3 sections # # Section 1: Mandatory # Parameters that MUST be set prior to DEPLOY. These parameters are # specific to each site or Data Guard environment. # # ALL parameters in Section 1 MUST be set prior to DEPLOY. # # Section 2: Site specific # Parameters that are commonly configured with site-specific values, # however the default values allow for a working Data Guard # configuration. # # Section 3: Optional # Parameters that do not need to be modified. The default value for # each parameter is sufficient for most Data Guard environments. # ############################################################################### ############################################################################### # # SECTION 1 - Mandatory Parameters # ============================================================================= # ============================================================================= # Parameters that MUST be set prior to DEPLOY. These parameters are # specific to each site or Data Guard environment. # ============================================================================= # ============================================================================= # # NOTE: Section 1 MUST be edited before Data Guard can be DEPLOYed and used. # # HOSTn # ----- # Range of values: Any valid hostname (as returned by hostname command) # # Host name of the systems where the Production and Standby databases exist. # # Example: # Single instance for both Host sets: # HOST1=salesla # HOST2=salesny # # Oracle Parallel Server (3 node) for one Host set: # HOST1=saleslaA,saleslaB,saleslaC # HOST2=salesny # HOST1=buware HOST2=certify # # ORACLE_USER_HOSTn # ----------------- # Range of values: Any valid operating system user # # Name of the operating system oracle user. # # Example: # Single instance for both Host sets: # ORACLE_USER_HOST1=oracle # ORACLE_USER_HOST2=oracle # # Oracle Parallel Server for one Host set: # ORACLE_USER_HOST1=oracle,oracle,oracle # ORACLE_USER_HOST2=oracle # ORACLE_USER_HOST1=orarnp ORACLE_USER_HOST2=orarnp # # ORACLE_HOME_HOSTn # ----------------- # Range of values: Any valid directory # # ORACLE_HOME directories for both HOST1 and HOST2. # # Example: # Single instance for both Host sets: # ORACLE_HOME_HOST1=/u01/app/oracle/product/8.1.7 # ORACLE_HOME_HOST2=/oracle/product/8.1.7 # # Oracle Parallel Server (3 node) for one Host set: # Following the HOST1/HOST2 example above, # ORACLE_HOME for saleslaA in HOST1 is /u01/oracle/8.1.7 # ORACLE_HOME for saleslaB in HOST1 is /u02/oracle/8.1.7 # ORACLE_HOME for saleslaC in HOST1 is /u03/oracle/8.1.7 # ORACLE_HOME for salesny in HOST2 is /oracle/product/8.1.7 # # ORACLE_HOME_HOST1=/u01/oracle/8.1.7,/u02/oracle/8.1.7,/u03/oracle/8.1.7 # ORACLE_HOME_HOST2=/oracle/product/8.1.7 # ORACLE_HOME_HOST1=/oracle/RNP/817_64 ORACLE_HOME_HOST2=/oracle/RNP/817_64 # # # ORACLE_SID_HOSTn # ---------------- # Range of values: Any valid ORACLE_SID string # # ORACLE_SID for the involved instances on both HOST1 and HOST2. # # Example: # ORACLE_SID_HOST1=SALES # ORACLE_SID_HOST2=SALES # # Oracle Parallel Server for one Host set: # ORACLE_SID_HOST1=SALESA,SALESB,SALESC # ORACLE_SID_HOST2=SALES # ORACLE_SID_HOST1=RNP ORACLE_SID_HOST2=RNP # # # PROD_LOG_ARCHIVE_DEST_PRIMARY_HOSTn STANDBY_ARCHIVE_DEST_PRIMARY_HOSTn # PROD_LOG_ARCHIVE_DEST_ALTERNATE_HOSTn STANDBY_ARCHIVE_DEST_ALTERNATE_HOSTn # -------------------------------------------------------------------------- # Range of values: Any valid directory # # Primary and alternate archive log directories for both the Production and # Standby databases for each system. # # Example: (Each directory is a separate filesystem) # # Single instance for both Host sets: # PROD_LOG_ARCHIVE_DEST_PRIMARY_HOST1=/oracle/SALES/archive1 # PROD_LOG_ARCHIVE_DEST_ALTERNATE_HOST1=/oracle/SALES/archive2 # STANDBY_ARCHIVE_DEST_PRIMARY_HOST2=/oracle/SALES/stbyarchive1 # STANDBY_ARCHIVE_DEST_ALTERNATE_HOST2=/oracle/SALES/stbyarchive2 # # Oracle Parallel Server (3 node) for one Host set: # PROD_LOG_ARCHIVE_DEST_PRIMARY_HOST1=/arch1A,/arch1B,/arch1C # PROD_LOG_ARCHIVE_DEST_ALTERNATE_HOST1=/arch2A,/arch2B,/arch2C # STANDBY_ARCHIVE_DEST_PRIMARY_HOST2=/oracle/SALES/stbyarchive1 # STANDBY_ARCHIVE_DEST_ALTERNATE_HOST2=/oracle/SALES/stbyarchive2 # # This first set of parameters is used when Production is running on HOST1 and # Standby is running on HOST2. # PROD_LOG_ARCHIVE_DEST_PRIMARY_HOST1=/oracle/RNP/saparch PROD_LOG_ARCHIVE_DEST_ALTERNATE_HOST1=/oracle/RNP/saparch1 STANDBY_ARCHIVE_DEST_PRIMARY_HOST2=/oracle/RNP/stbyarch STANDBY_ARCHIVE_DEST_ALTERNATE_HOST2=/oracle/RNP/stbyarch1 # # # This second set of parameters is used when Production is running on HOST2 # and Standby is running on HOST1 (as would occur after the first Switchover). # PROD_LOG_ARCHIVE_DEST_PRIMARY_HOST2=/oracle/RNP/saparch PROD_LOG_ARCHIVE_DEST_ALTERNATE_HOST2=/oracle/RNP/saparch1 STANDBY_ARCHIVE_DEST_PRIMARY_HOST1=/oracle/RNP/stbyarch STANDBY_ARCHIVE_DEST_ALTERNATE_HOST1=/oracle/RNP/stbyarch1 # # # PROD_INITORA_FILE_HOSTn # STBY_INITORA_FILE_HOSTn # STBY_TO_PROD_INITORA_FILE_HOSTn # ------------------------------- # Range of values: Any valid init.ora file referencing Production control files # # PROD_INITORA_FILE_HOSTn points to the Production database init.ora file. # STBY_INITORA_FILE_HOSTn points to the Standby database init.ora file. # STBY_TO_PROD_INITORA_FILE_HOSTn points to the init.ora file residing on the # Standby system that will be used if the Standby database is ACTIVATEd. # # Example: # Single instance for both Host sets: # PROD_INITORA_FILE_HOST1=/u01/app/oracle/product/8.1.7/dbs/initSALES.ora # PROD_INITORA_FILE_HOST2=/oracle/product/8.1.7/dbs/initSALES.ora # STBY_INITORA_FILE_HOST1=/u01/app/oracle/product/8.1.7/dbs/initSALES_stby.ora # STBY_INITORA_FILE_HOST2=/oracle/product/8.1.7/dbs/initSALES_stby.ora # STBY_TO_PROD_INITORA_FILE_HOST1=/u01/app/oracle/product/8.1.7/dbs/initSALES_stby2prod.ora # STBY_TO_PROD_INITORA_FILE_HOST2=/oracle/product/8.1.7/dbs/initSALES_stby2prod.ora # # Oracle Parallel Server (3 node) for one Host set: # PROD_INITORA_FILE_HOST1=/u01/oracle/8.1.7/dbs/initSALESA.ora,/u02/oracle/8.1.7/dbs/initSALESB.ora,/u03/oracle/8.1.7/dbs/initSALESC.ora # PROD_INITORA_FILE_HOST2=/oracle/product/8.1.7/dbs/initSALES.ora # STBY_INITORA_FILE_HOST1=/u01/oracle/8.1.7/dbs/initSALESA_stby.ora,/u02/oracle/8.1.7/dbs/initSALESB_stby.ora,/u03/oracle/8.1.7/dbs/initSALESC_stby.ora # STBY_INITORA_FILE_HOST2=/oracle/product/8.1.7/dbs/initSALES_stby.ora # STBY_TO_PROD_INITORA_FILE_HOST1=/u01/oracle/8.1.7/dbs/initSALESA_stby2prod.ora,/u02/oracle/8.1.7/dbs/initSALESB_stby2prod.ora,/u03/oracle/8.1.7/dbs/initSALESC_stby2prod.ora # STBY_TO_PROD_INITORA_FILE_HOST2=/oracle/product/8.1.7/dbs/initSALES_stby2prod.ora # PROD_INITORA_FILE_HOST1=/oracle/RNP/817_64/dbs/initRNP.ora PROD_INITORA_FILE_HOST2=/oracle/RNP/817_64/dbs/initRNP.ora STBY_INITORA_FILE_HOST1=/oracle/RNP/817_64/dbs/initRNP_stby.ora STBY_INITORA_FILE_HOST2=/oracle/RNP/817_64/dbs/initRNP_stby.ora STBY_TO_PROD_INITORA_FILE_HOST1=/oracle/RNP/817_64/dbs/initRNP_stby2prod.ora STBY_TO_PROD_INITORA_FILE_HOST2=/oracle/RNP/817_64/dbs/initRNP_stby2prod.ora # LISTENER_NAME_HOSTn # ------------------- # Range of values: Any valid listener name # # Net8 Listener names. # # Example: # Single instance for both Host sets: # LISTENER_NAME_HOST1=SALESLSNR # LISTENER_NAME_HOST2=SALESLSNR # # Oracle Parallel Server (3 node) for one Host set: # LISTENER_NAME_HOST1=SALESLSNR,SALESLSNR,SALESLSNR # LISTENER_NAME_HOST2=SALESLSNR # LISTENER_NAME_HOST1=LISTENER LISTENER_NAME_HOST2=LISTENER # # SECTION 2 - Site Specific Parameters # ============================================================================= # ============================================================================= # Parameters that are commonly configured with site-specific values, # however the default values allow for a working Data Guard # configuration. # ============================================================================= # ============================================================================= # # CALL_HOME # --------- # Range of values: TRUE, FALSE # # Enable Call Home feature for INTERNAL errors and ALERT messages. If set to # TRUE, the user-written program # $ORACLE_HOME/dataguard/admin/callHome_${DATAGUARD_ID}.sh must exist on all # hosts. # CALL_HOME=FALSE # RECOVERY_ARCHIVE_LOG_LAG # ------------------------ # Range of values: 0-512 # # Number of archive log files the Standby database should remain behind # the Production database during normal Production/Standby mode. # RECOVERY_ARCHIVE_LOG_LAG=0 # RECOVERY_DEGREE_PARALLELISM # --------------------------- # Range of values: Empty, 0, or 1-999 # # Determines if parallel Standby media recovery is used, and if so, defines the # degree of parallelism. # #RECOVERY_DEGREE_PARALLELISM=2 # CONCURRENT_TRANSFERS # -------------------- # Range of values: 1-32 # # Maximum number of files that can be transferred simultaneously. # CONCURRENT_TRANSFERS=3 # REMOTE_MIRRORED_LOGFILES # ------------------------ # Range of values: TRUE, FALSE # # Defines if Production online logs are remotely mirrored to the Standby. If # set to TRUE, the user-written program # $ORACLE_HOME/dataguard/admin/remoteMirroredLogfiles_${DATAGUARD_ID}.sh must # exist on all hosts. # REMOTE_MIRRORED_LOGFILES=FALSE # AUTO_ADD_DATAFILE # ----------------- # Range of values: AUTO, TRUE, FALSE # # If set to AUTO or TRUE, datafiles are automatically added to the Standby # database. If set to TRUE, the user-written program # $ORACLE_HOME/dataguard/admin/autoAddDatafile_${DATAGUARD_ID}.sh must # exist on all hosts. # AUTO_ADD_DATAFILE=FALSE # SWITCHOVER_CALLOUT # ------------------ # Range of values: TRUE, FALSE # # If set to TRUE, the user-written script # $ORACLE_HOME/dataguard/admin/switchoverCallout_${DATAGUARD_ID}.sh will be # run before and after a Switchover. # SWITCHOVER_CALLOUT=FALSE # FAILOVER_CALLOUT # ---------------- # Range of values: TRUE, FALSE # # If set to TRUE, the user-written script # $ORACLE_HOME/dataguard/admin/failoverCallout_${DATAGUARD_ID}.sh will be # run before and after a Failover. # FAILOVER_CALLOUT=FALSE # SSH_ENABLE, SSH_PROGRAM, SCP_PROGRAM, SSH_ENV_FILE_HOSTn # SSH_OPTIONS, SCP_OPTIONS # -------------------------------------------------------- # SSH_ENABLE # Range of values: TRUE, FALSE # # SSH_PROGRAM, SCP_PROGRAM # Range of values: Empty, or full path to ssh/scp executable # # SSH_OPTIONS, SCP_OPTIONS # Range of values: Empty, or options to pass ssh/scp calls # # SSH_ENV_FILE_HOSTn # Range of values: Empty, or full path to SSH environment file # # If SSH_ENABLE=TRUE, then use $SSH_PROGRAM with $SSH_OPTIONS and $SCP_PROGRAM # with $SCP_OPTIONS instead of the standard OS utilities remsh and rcp, # respectively. If an encrypted key and ssh-agent are used for authentication, # then SSH_ENV_FILE_HOSTn must define SSH_AUTH_SOCK properly. # # Example if using SSH with host-based authentication or RSA authentication # with a plaintext key: # SSH_ENABLE=TRUE # SSH_PROGRAM=/usr/local/bin/ssh # SSH_OPTIONS="-q -o BatchMode=yes" # SCP_PROGRAM=/usr/local/bin/scp # SCP_OPTIONS="-q -B -S $SSH_PROGRAM" # SSH_ENV_FILE_HOST1= # SSH_ENV_FILE_HOST2= # # Example if using SSH with RSA authentication using an encrypted key: # SSH_ENABLE=TRUE # SSH_PROGRAM=/usr/local/bin/ssh # SSH_OPTIONS="-q -o BatchMode=yes" # SCP_PROGRAM=/usr/local/bin/scp # SCP_OPTIONS="-q -B -S $SSH_PROGRAM" # SSH_ENV_FILE_HOST1=/home/oracle/.ssh/dgd_ssh_env # SSH_ENV_FILE_HOST2=/home/oracle/.ssh/dgd_ssh_env # # Example contents of the Data Guard SSH environment files on both HOSTs # host1> cat /home/oracle/.ssh/dgd_ssh_env # SSH_AUTH_SOCK=/tmp/ssh-oracle/ssh-11007-agent # # host2> cat /home/oracle/.ssh/dgd_ssh_env # SSH_AUTH_SOCK=/tmp/ssh-oracle/ssh-17893-agent # #SSH_ENABLE=TRUE #SSH_PROGRAM=/usr/local/bin/ssh #SSH_OPTIONS="-q -o BatchMode=yes" #SCP_PROGRAM=/usr/local/bin/scp #SCP_OPTIONS="-q -B -S $SSH_PROGRAM" #SSH_ENV_FILE_HOST1= #SSH_ENV_FILE_HOST2= SSH_ENABLE=FALSE # DUMPDEST_HOSTn # -------------- # Range of values: Empty, or valid local directory # # Directory where Data Guard logs files are written. # DUMPDEST_HOST1=/oracle/RNP/817_64/dataguard/log DUMPDEST_HOST2=/oracle/RNP/817_64/dataguard/log # ORACLE_BASE_HOSTn # ----------------- # Range of values: Empty, or valid ORACLE_BASE directory # # ORACLE_BASE if OFA is in use. # #ORACLE_BASE_HOST1= #ORACLE_BASE_HOST2= # DB_NAME # ------- # Range of values: Empty, or valid database name # # DB_NAME if OFA is in use. If using Parallel Fail Safe, use same value as # DB_NAME from the PFS Configuration File. # #DB_NAME=RNP # ORACLE_SERVICE # -------------- # Range of values: Empty, or valid Oracle Parallel Fail Safe identifier # # If using Parallel Fail Safe, use same value as from the PFS Configuration # File. # #ORACLE_SERVICE=DGPFS # # SECTION 3 - Optional Parameters # ============================================================================= # ============================================================================= # Parameters that do not need to be modified. The default value for # each parameter is sufficient for most Data Guard environments. # ============================================================================= # ============================================================================= # # STOP_STBY_AGENT_ON_PROD_ALERTLIST_MATCH # STOP_STBY_AGENT_ON_STBY_ALERTLIST_MATCH # STOP_PROD_DATABASE_ON_PROD_ALERTLIST_MATCH # STOP_PROD_DATABASE_ON_STBY_ALERTLIST_MATCH # ------------------------------------------ # Range of values: TRUE, FALSE # # If set to TRUE, stop the Standby agent or Production database when an Alert # List match with the alert.log occurs. # STOP_STBY_AGENT_ON_PROD_ALERTLIST_MATCH=TRUE STOP_STBY_AGENT_ON_STBY_ALERTLIST_MATCH=TRUE STOP_PROD_DATABASE_ON_PROD_ALERTLIST_MATCH=FALSE STOP_PROD_DATABASE_ON_STBY_ALERTLIST_MATCH=FALSE # LOG_ARCHIVE_DEST_USED_SPACE_THRESHOLD # ------------------------------------- # Range of values: 0-100 # # Threshold percentage of used space for an archive directory. # LOG_ARCHIVE_DEST_USED_SPACE_THRESHOLD=90 # RECOVERY_ARCHIVE_LOG_LAG_THRESHOLD # ---------------------------------- # Range of values: 0-512 # # Threshold lag can reach before Warning messages are reported. # RECOVERY_ARCHIVE_LOG_LAG_THRESHOLD=0 # PROD_SHUTDOWN_TIMEOUT STBY_SHUTDOWN_TIMEOUT # PROD_SHUTDOWN_ABORT_TIMEOUT STBY_SHUTDOWN_ABORT_TIMEOUT # --------------------------------------------------------- # Range of values: 0-3600 # # Number of seconds Data Guard should wait for a database shutdown to complete. # PROD_SHUTDOWN_TIMEOUT=300 PROD_SHUTDOWN_ABORT_TIMEOUT=30 STBY_SHUTDOWN_TIMEOUT=300 STBY_SHUTDOWN_ABORT_TIMEOUT=30 # SYNCHRONIZE_PROD_INITORA SYNCHRONIZE_STBY_TO_PROD_INITORA # SYNCHRONIZE_STBY_INITORA # -------------------------------------------------------------- # Range of values: TRUE, FALSE # # If set to TRUE, init.ora files will be synchronized every day at midnight. # SYNCHRONIZE_PROD_INITORA=FALSE SYNCHRONIZE_STBY_INITORA=FALSE SYNCHRONIZE_STBY_TO_PROD_INITORA=FALSE # ENABLE_PROD_ALERTLOGPARSER, ENABLE_PROD_HEARTBEAT_MONITOR # ENABLE_PROD_INSTANCE_MONITOR, ENABLE_PROD_LISTENER_MONITOR # ----------------------------------------------------------- # Range of values: TRUE, FALSE # # Production monitors # ENABLE_PROD_ALERTLOGPARSER=TRUE ENABLE_PROD_HEARTBEAT_MONITOR=TRUE ENABLE_PROD_INSTANCE_MONITOR=TRUE ENABLE_PROD_LISTENER_MONITOR=TRUE # ENABLE_STBY_ALERTLOGPARSER, ENABLE_STBY_LISTENER_MONITOR # -------------------------------------------------------- # Range of values: TRUE, FALSE # # Standby monitors # ENABLE_STBY_ALERTLOGPARSER=TRUE ENABLE_STBY_LISTENER_MONITOR=TRUE # # END OF DATA GUARD CONFIGURATION FILE #