*************************************************************
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> }
————————————————-