TSM: Oracle Backup configuration example |
|
Written by Administrator
|
Wednesday, 18 May 2011 05:48 |
************************************************************* Old dsm.sys: ------------------------------------------------- SErvername TSMServer COMMMethod TCPip TCPPort 1500 TCPServeraddress TSMServer.abc.com PASSWORDAccess generate passworddir /home/oracle nodename oracledb02 -------------------------------------------------
New dsm.sys: ------------------------------------------------- SErvername TSMServer COMMMethod TCPip TCPPort 1500 TCPServeraddress TSMServer.abc.com PASSWORDAccess generate passworddir /home/oracle nodename oracledb02
SErvername TSM_weekly COMMMethod TCPip TCPPort 1500 TCPServeraddress TSMServer.abc.com PASSWORDAccess generate passworddir /home/oracle nodename oracledb02 INCLUDE /orc9_weekly/.../* weekly_mgmt_class
SErvername TSM_monthly COMMMethod TCPip TCPPort 1500 TCPServeraddress TSMServer.abc.com PASSWORDAccess generate passworddir /home/oracle nodename oracledb02 INCLUDE /orc9_monthly/.../* monthly_mgmt_class ------------------------------------------------- ************************************************************* Present dsm.opt ------------------------------------------------- * SErvername A server name defined in the dsm.sys file SErvername TSMServer -------------------------------------------------
Additional file dsm_weekly.opt ------------------------------------------------- * SErvername A server name defined in the dsm.sys file SErvername TSM_weekly ------------------------------------------------- Additional file dsm_monthly.opt ------------------------------------------------- * SErvername A server name defined in the dsm.sys file SErvername TSM_monthly -------------------------------------------------
*************************************************************
Present tdpo.opt ------------------------------------------------- DSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin64/dsm.opt DSMI_LOG /var/log/tsmlog/tdpoerror.log
TDPO_FS orc9_db *TDPO_NODE <hostname> *TDPO_OWNER oracle TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64
TDPO_DATE_FMT 1 TDPO_NUM_FMT 1 TDPO_TIME_FMT 1
TDPO_MGMT_CLASS_2 mgmtclass2 TDPO_MGMT_CLASS_3 mgmtclass3 TDPO_MGMT_CLASS_4 mgmtclass4 ------------------------------------------------- Additional file tdpo_weekly.opt ------------------------------------------------- DSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin64/dsm_weekly.opt DSMI_LOG /var/log/tsmlog/tdpoerror.log
TDPO_FS orc9_weekly *TDPO_NODE <hostname> *TDPO_OWNER oracle TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64
TDPO_DATE_FMT 1 TDPO_NUM_FMT 1 TDPO_TIME_FMT 1
TDPO_MGMT_CLASS_2 mgmtclass2 TDPO_MGMT_CLASS_3 mgmtclass3 TDPO_MGMT_CLASS_4 mgmtclass4 ------------------------------------------------- Additional file tdpo_monthly.opt ------------------------------------------------- DSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin64/dsm_monthly.opt DSMI_LOG /var/log/tsmlog/tdpoerror.log
TDPO_FS orc9_monthly *TDPO_NODE <hostname> *TDPO_OWNER oracle TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64
TDPO_DATE_FMT 1 TDPO_NUM_FMT 1 TDPO_TIME_FMT 1
TDPO_MGMT_CLASS_2 mgmtclass2 TDPO_MGMT_CLASS_3 mgmtclass3 TDPO_MGMT_CLASS_4 mgmtclass4 ------------------------------------------------- ************************************************************* Run your weekly/monthly backups using your new filespaces by giving it a new channel pointing to the new tdpoxxx.opt files. The RMAN prompts are only for illustration. New RMAN weekly backup command: ------------------------------------------------- RMAN> run { allocate channel w1 device type sbt_tape 2> parms "ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_weekly.opt)"; 3> backup database ... ... ...; 4> } ------------------------------------------------- New RMAN monthly backup command: ------------------------------------------------- RMAN> run { allocate channel w1 device type sbt_tape 2> parms "ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_monthly.opt)"; 3> backup database ... ... ...; 4> } -------------------------------------------------
|