Introduction This section describes the sample scripts used in this white paper.
Baseline - BR*Tools configuration file for RMAN
initPRDrman.sap
************************************************************************************************
backup_mode = full restore_mode = full
backup_type = online_cons backup_dev_type = rman_util
backup_root_dir = /oracle/PRD/sapbackup stage_root_dir = /oracle/PRD/sapbackup compress = no
archive_function = save_delete
archive_copy_dir = /oracle/PRD/sapbackup archive_stage_dir = /oracle/PRD/sapbackup saveset_members = 1
rman_channels = 4
rman_parms = "ENV=(NSR_DEBUG_LEVEL=9, NSR_SERVER=networker, NSR_CLIENT=sapprd, NSR_DATA_VOLUME_POOL=UC334PRDF,
NSR_NWPATH=/usr/sbin/)"
util_par_file = /oracle/PRD/102_64/dbs/initPRDrman.utl
************************************************************************************************
initPRDrman.utl
************************************************************************************************
NSR_NWPATH = /usr/sbin/
parallelism = 4
ss_group_by_fs = TRUE expiration = 3 Months pool = UC334PRDF server = networker
client = sapprd ssNameFormat = new
NSR_SAVESET_RETENTION = 3 Months NSR_SAVESET_BROWSE = 3 Months
************************************************************************************************
Baseline - BR*Tools configuration file for PowerSnap
initPRD.sap
************************************************************************************************
backup_mode = full restore_mode = full
backup_type = online_cons
backup_dev_type = util_file_online backup_root_dir = /oracle/PRD/sapbackup stage_root_dir = /oracle/PRD/sapbackup compress = no
archive_function = save_delete
archive_copy_dir = /oracle/PRD/sapbackup archive_stage_dir = /oracle/PRD/sapbackup
util_par_file = /oracle/PRD/102_64/dbs/initPRD.utl
************************************************************************************************
initPRD.utl
************************************************************************************************
NSR_NWPATH = /usr/sbin/
parallelism = 4
ss_group_by_fs = TRUE expiration = 3 Months pool = UC334PRDF server = networker client = sapprd
NSR_SAVESET_RETENTION = 3 Months NSR_SAVESET_BROWSE = 3 Months
ps_backup_mode = TRUE ps_archive_mode = FALSE ps_restore_mode = TRUE ps_inquire_mode = TRUE
ps_exclude_backup_bi_run_nums = 2 ps_exclude_archive_bi_run_nums = 1;2 ps_exclude_backup_paths =
/oracle/PRD/102_64/dbs/*;/oracle/PRD/sapreorg/*;/oracle/PRD/sa pbackup/*
ps_opaque_pfilename = /oracle/PRD/102_64/dbs/nsrsapps.cfg
************************************************************************************************
nsrsapps.cfg
************************************************************************************************
NSR_DATA_MOVER = sapprx SYMM_SNAP_REMOTE = FALSE SYMM_SNAP_TECH = BCV NSR_PS_DEBUG_LEVEL = 9
SYMM_ON_DELETE = RETAIN_RESOURCE NSR_SNAP_TYPE = symm-dmx
NSR_PS_SAVE_PARALLELISM = 4
************************************************************************************************
Baseline - NMSAP configuration file for RMAN
nsrsapsvrman.cfg
************************************************************************************************
BR_EXEC = brbackup -p initPRDrman.sap ORACLE_HOME = /oracle/PRD/102_64 ORACLE_SID = PRD
NLS_LANG = AMERICAN_AMERICA.US7ASCII SAPDATA_HOME = /oracle/PRD
SAP_BIN = /sapmnt/PRD/exe
LD_LIBRARY_PATH = /oracle/PRD/102_64/lib:/usr/lib/nsr:/usr/lib
OS_USR_PASSWD=xxxxxxxxxxxxxxxx
************************************************************************************************
Baseline - NMSAP configuration file for PowerSnap
nsrsapsv.cfg
************************************************************************************************
BR_EXEC = brbackup -p initPRD.sap -d util_file_online -r /oracle/PRD/102_64/dbs/initPRD.utl -t online_cons -m all_data -k no -l E
ORACLE_HOME = /oracle/PRD/102_64 ORACLE_SID = PRD
NLS_LANG = AMERICAN_AMERICA.US7ASCII SAPDATA_HOME = /oracle/PRD
SAP_BIN = /sapmnt/PRD/exe
LD_LIBRARY_PATH = /oracle/PRD/102_64/lib:/usr/lib/nsr:/usr/lib
OS_USR_PASSWD=xxxxxxxxxxxxxxxx
************************************************************************************************
Avamar - BR*Tools configuration file for RMAN
initPRDrmanavt.sap
************************************************************************************************
backup_mode = full restore_mode = full
backup_type = online_cons backup_dev_type = rman_util
stage_root_dir = /oracle/PRD/sapbackup compress = no
archive_function = save_delete
archive_copy_dir = /oracle/PRD/sapbackup archive_stage_dir = /oracle/PRD/sapbackup
saveset_members = 1 rman_channels = 4 rman_send=(
"'NSR_ENV=(NSR_DEDUP_BACKUP=TRUE, NSR_DEDUP_NODE=avamar01-u)'",
"channel sbt_1 'NSR_ENV=(NSR_DEDUP_CACHE_TAG=prdavt_1)'",
"channel sbt_2 'NSR_ENV=(NSR_DEDUP_CACHE_TAG=prdavt_2)'",
"channel sbt_3 'NSR_ENV=(NSR_DEDUP_CACHE_TAG=prdavt_3)'",
"channel sbt_4 'NSR_ENV=(NSR_DEDUP_CACHE_TAG=prdavt_4)'"
)
rman_parms = "ENV=(NSR_DEBUG_LEVEL=9, NSR_SERVER=networker, NSR_CLIENT=sapprd, NSR_DATA_VOLUME_POOL=UC334PRDFAVT,
NSR_NWPATH=/usr/sbin/)"
util_par_file = /oracle/PRD/102_64/dbs/initPRDrmanavt.utl
************************************************************************************************
initPRDrmanavt.utl
************************************************************************************************
NSR_NWPATH = /usr/sbin/
parallelism = 4
ss_group_by_fs = TRUE expiration = 3 Months pool = UC334PRDFAVT server = networker client = sapprd
ssNameFormat = new
NSR_SAVESET_RETENTION = 3 Months NSR_SAVESET_BROWSE = 3 Months
************************************************************************************************
Avamar - BR*Tools configuration file for PowerSnap
initPRD.sap
************************************************************************************************
backup_mode = full restore_mode = full
backup_type = online_cons
backup_dev_type = util_file_online backup_root_dir = /oracle/PRD/sapbackup stage_root_dir = /oracle/PRD/sapbackup compress = no
archive_function = save_delete
archive_copy_dir = /oracle/PRD/sapbackup archive_stage_dir = /oracle/PRD/sapbackup
util_par_file = /oracle/PRD/102_64/dbs/initPRD.utl
************************************************************************************************
initPRDavt.utl
************************************************************************************************
NSR_NWPATH = /usr/sbin/
parallelism = 4
ss_group_by_fs = TRUE expiration = 3 Months pool = UC334PRDFAVT server = networker client = sapprd ssNameFormat = new
NSR_SAVESET_BROWSE = 3 Months
ps_backup_mode = TRUE ps_archive_mode = FALSE ps_restore_mode = TRUE ps_inquire_mode = TRUE
ps_exclude_backup_bi_run_nums = 2 ps_exclude_archive_bi_run_nums = 1;2 ps_exclude_backup_paths =
/oracle/PRD/102_64/dbs/*;/oracle/PRD/sapreorg/*;/oracle/PRD/sa pbackup/*
ps_opaque_pfilename = /oracle/PRD/102_64/dbs/nsrsapps.cfg
************************************************************************************************
nsrsapps.cfg
************************************************************************************************
NSR_DATA_MOVER = sapprx SYMM_SNAP_REMOTE = FALSE SYMM_SNAP_TECH = BCV NSR_PS_DEBUG_LEVEL = 9
SYMM_ON_DELETE = RETAIN_RESOURCE NSR_SNAP_TYPE = symm-dmx
NSR_PS_SAVE_PARALLELISM = 4
Avamar - NMSAP configuration file for RMAN
nsrsapsvrmanavt.cfg
************************************************************************************************
BR_EXEC = brbackup -p initPRDrmanavt.sap ORACLE_HOME = /oracle/PRD/102_64
ORACLE_SID = PRD
NLS_LANG = AMERICAN_AMERICA.US7ASCII SAPDATA_HOME = /oracle/PRD
SAP_BIN = /sapmnt/PRD/exe
LD_LIBRARY_PATH = /oracle/PRD/102_64/lib:/usr/lib/nsr:/usr/lib
OS_USR_PASSWD=xxxxxxxxxxxxxxxx
************************************************************************************************
Avamar - NMSAP configuration file for PowerSnap
nsrsapsvavt.cfg
************************************************************************************************
BR_EXEC = brbackup -p initPRD.sap -d util_file_online -r /oracle/PRD/102_64/dbs/initPRDavt.utl -t online_cons -m all_data -k no -l E
ORACLE_HOME = /oracle/PRD/102_64 ORACLE_SID = PRD
NLS_LANG = AMERICAN_AMERICA.US7ASCII SAPDATA_HOME = /oracle/PRD
SAP_BIN = /sapmnt/PRD/exe
LD_LIBRARY_PATH = /oracle/PRD/102_64/lib:/usr/lib/nsr:/usr/lib
OS_USR_PASSWD=xxxxxxxxxxxxxxxx
************************************************************************************************