Tivoli Data Protection for Oracle (TDPO)

From dbawiki
Revision as of 17:40, 9 January 2013 by Stuart (talk | contribs)
Jump to: navigation, search

'work in progress'

Setting up RMAN to backup directly to tape

RMAN cannot backup directly to tape due to there being many different tape backup suppliers.
The solution is the TDPO interface to which tape suppliers supply parameters. RMAN then knows what to do.

Files involved

  • dsm.sys
  • dsm.opt
  • tdpo.opt

Setting up DataPump to backup directly to tape

Files involved

  • dsm.sys

DSM.SYS entry located at /usr/tivoli/tsm/client/api/bin64/dsm.sys


servername  TSM_SINTP1_TDPO
   COMMmethod         TCPIP
   TCPPort            1516
   TCPServeraddress   10.80.0.15
   TCPBuffsize             31
   TCPWindowsize           32
   LARGECOMMBUFFERS        YES
   TXNBytelimit            10000
   PASSWORDACCESS          PROMPT
   MAXCMDRETRIES           4
   INCLEXCL                /home/ibmtools/scripts/rman/inclexcl.lst
   QUERYSCHEDPERIOD        3
   RETRYPERIOD             30
   SCHEDLOGNAME            /home/ibmtools/logs/rman/dsmsched.log
   ERRORLOGNAME            /home/ibmtools/logs/rman/dsmerror.log
   SCHEDLOGRETENTION       15 D
   SCHEDMODE               POLLING
   MAILPROG                /usr/bin/mail root
   NODENAME                SO_U_SINTP1_ORA_X_SAF
   DIRMC                   D01NOS_T1


scrbdbsbeant311:root[/home/ibmtools/scripts/rman]# cat tdpo_SINTP1.opt
DSMI_ORC_CONFIG    /home/ibmtools/scripts/rman/dsm_SINTP1.opt
DSMI_LOG           /home/ibmtools/logs/rman/tdpoerror_SINTP1
TDPO_FS            tdpo_SINTP1
TDPO_NODE          SO_U_SINTP1_ORA_X_SAF
TDPO_PSWDPATH      /home/ibmtools/scripts/rman
*tdpo_trace_flags orclevel0 orclevel1 orclevel2
*tdpo_trace_file   /home/ibmtools/logs/rman/tdpo_SINTP1.out