rman.args

#############################################################################
# #
# FILENAME: rman.args #
# #
# Purpose: Supplies the RMAN scripts with the necessary parameters. #
# #
#############################################################################
# #
# Revision History: #
# #
# REV DATE BY DESCRIPTION #
# — —— ————– ——————————————- #
# 1.0 053105 INFRASTRUCTURE Initial Release #
# 1.2 081605 Fix bug in CHK_LSNR for standby databases #
# 1.3 041107 Add an option of using Flash Recovery Area #
# for 10g / RACPlex #
# #
#############################################################################
# #
# Edit any of the following variables for your database. #
# #
# Note TARGET_DATABASE and TARGET_INSTANCE are case-sensitive! #
# #
# Use FULL PATHs for all variables, do not substitute with environment #
# variables as they will not be parsed correctly. #
# #
# In the comment part of the line, Y|N means [Y]es or [N]o #
# #
#############################################################################
#CATALOG_DATABASE=ddsrmand # Name of RMAN Catalog database
#CATALOG_USERNAME=rcvcat104 # Name of RMAN account for Catalog database
#CATALOG_PASSWORD=RMANDBA # Password for RMAN account in Catalog db

TARGET_DATABASE=DBFSXD01
TARGET_INSTANCE=DBFSXD011 # Name of TARGET instance (Case-Sensitive)
WEBDB_PASSWORD=st4nd4rd # Password for orastd id in WEBDB database #

# The following indicates where temporary command files are created #
RMAN_CMD=/oracle/admin/DBFSXD01/local/rman/cmd # Path to temp command files

# The following indicates whether to run the scripts in debug mode or not #
DEBUGMODE=N # Y|N – Run scripts in verbose mode? #

# The following variable will be used to determine whether to run #
# the backup or NOT to run the backup. This is used rather than the oratab.#
# If set to N, no error will be raised by skipping the backup. #
#
DOBACKUP=Y # Y|N – Run Backup? [Y]es, [N]o #

# The following variable will be used for alerting your on-call group #
# NO SPACES in the On-Call group name for NEWS notification/lookup #
# Examples: “Midrange-Oracle-Concord”, “MRDBA-Jacksonville”, #
# “Charlotte-UDB-Oracle-DBA”, etc. #
ONCALLGRP=”Group-Use-Dashes” # OnCallGroup (no spaces or use dashes)
PAGE=N # Y|N Tivoli/Page notification? [Y]es, [N]o #
FOGLIGHT=N # Write to Foglight alert log? [Y]es, [N]o #

EMAIL=Y # Y|N Email notification? [Y]es, [N]o #
# The following variable will qualify which “type” of condition to send an #
# email for. The default, if not specified, is to email on Failures only. #
# That setting would be: EMAILTYPE=F. However, if you wanted to be emailed #
# on successful backups, then use EMAILTYPE=A and you will get email #
# regardless of whether the backup was successful or not. #
#
EMAILTYPE=F # Email on backup Failures (F) or All (A) #

# If EMAIL set to Y, then need to set EMAIL_DIST filename with list of #
# email addresses. #
# The following variable contains a list of email recipients #
# EMAIL_DIST file format: name1@mrcconsulting.com (one email per line) #
# name2@mrcconsulting.com (one email per line) #
#

EMAIL_DIST=/oracle/admin/DBFSXD01/local/rman/.email # Email recipients list

# Compression – due to space limitations, selecting this option will #
# keep two generations of backups in compressed format on disk. #
# If set to “Y”, then the value of OLDDIRNAME must also be supplied. #
#
COMPRESS=N # Y|N – Compress backups? [Y]es, [N]o #
#OLDDIRNAME=/oracle/admin/BSG1/backup/save # Previous compressed directory

# The following variable will be used to determine how many archive logs #
# to keep based on a time string. Whole numbers indicate days. #
# Hours represented as fractions, for example: 2/24 = 2 hours, which means #
# archive logs would remain online from the current time – 2 hours #
TIMETOKEEP=”0″ # Time unit to keep archive logs
#TIMETOKEEP=”2/24″ # Example: time unit of 2 hours
#TIMETOKEEP=”3″ # Example: time unit of 3 days

# The following variable is used to keep a certain number of archive logs #
# on disk. The script will determine up to which archive log has been #
# applied to the standby, and will purge the archive logs up to this #
# sequence number MINUS the value of STANDBYKEEP, to assure that a handful #
# of archive logs are kept on disk. #
STANDBYKEEP=10 # Number of archive logs to keep

# The following variable indicates the type of backup media #
BACKUP_DEVICE=D # [D]isk, [T]ape. Indicates device type #

# Webdb notification. The variable WEBDB will indicate whether to send an #
# update to the DBA Support website, for posting onto the site. #
# Set webdb to ‘Y’ to send a record of success/failure to the DBA website. #
# Set webdb to ‘N’ to skip sending a record of success/fail. to the website.#
WEBDB=Y # Y|N – Update DBA Website with bkup status?#

# The following variable indicates the number of script logs to keep in dir #
KEEP=30 # If not set, it will default. #
USE_FRA=Y # Set USE_FRA to “Y” to send backups to FRA #
# Default is “N’ #
COMPRESSED_BACKUPSET=N
#COMPRESSED_BACKUPSET=Y
#NB_ORA_CLASS=” ” #optional
#NB_ORA_SCHED=”Daily” #optional
SENDNEWS=N
#NEWSGROUP=
#NEWSPIN=
#