Tivoli Data Protection for Oracle (TDPO)
From dbawiki
'work in progress'
Contents
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