TSM: Oracle Backup configuration example Print
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>          }
-------------------------------------------------