Software Knowledge

  1. Home
  2. Docs
  3. Software Knowledge
  4. Backup
  5. TSM: Oracle Backup configuration example
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

TSM: Oracle Backup configuration example

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