TDPO for TSM setup on AIX
1. make sure oracle id has full access to tsm installation folder and files.
2. vi /usr/tivoli/tsm/client/ba/bin64/dsm.sys:
SErvername your TSM server name, for example, TSM_ORA
COMMmethod TCPIP
TCPPort 1500
TcpServerAddress tsm server IP
NODENAME client_node registered on your TSM server(for example, client_ora)
3. vi /usr/tivoli/tsm/client/ba/bin64/dsm.opt:
SErvername your TSM server name, for example, TSM_ORA
4. su - oracle
5. ln -s /usr/lib/libobk64.a $ORACLE_HOME/lib/libobk.a
6. vi /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt:
DSMI_ORC_CONFIG (location of dsm.opt, for example, /usr/tivoli/tsm/client/oracle/bin64/dsm.opt)
DSMI_DIR (location for dsm.sys,for example, /usr/tivoli/tsm/client/oracle/bin64)
TDPO_FS (Space name for backup on TSM, for example, adsmorc)
TDPO_NODE (Nodename for client, usually the servername of client)
TDPO_OWNER (TDPO owner, for example, oracle)
TDPO_PSWDPATH (tdpoconf password file location)
DSMI_LOG (Log file location, for example, /home/oracle)
7. tdpoconf password -tdpo_optfile=<full path of tdpo.opt file>
It will create a password file TDPO.nodename
You should get the password from the TSM admin
8. ln -s /usr/tivoli/tsm/client/lang/EN_US /usr/tivoli/tsm/client/oracle/bin64/EN_US
9. make sure user oracle has full access to all files under /usr/tivoli/tsm/client/oracle/bin64
10. test: $ORACLE_HOME/bin/sbttest test
if you see:
The sbt function pointers are loaded from libobk.a(shr.o) library.
-- sbtinit succeeded
Means the tdpo for oracle are configured successfully.
Example of /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt:
***************************************************************************
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the AIX Data Protection for Oracle 64bit
*********************************************************************
DSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG /home/oracle
DSMI_DIR /usr/tivoli/tsm/client/oracle/bin64
TDPO_FS adsmorc
TDPO_NODE bidb
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
Example of /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt.bibase:
***************************************************************************
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the AIX Data Protection for Oracle 64bit
*********************************************************************
DSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG /home/oracle
DSMI_DIR /usr/tivoli/tsm/client/oracle/bin64
TDPO_FS bibase
TDPO_NODE bidb
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
Example of /usr/tivoli/tsm/client/oracle/bin64/dsm.sys:
SErvername TSM_Mavis
MANAGEDSERVICES SCHEDULE
SCHEDLOGMAX 5
ERRORLOGMAX 5
SCHEDLOGRETENTION N
SCHEDLOGNAME "/usr/tivoli/tsm/client/oracle/bin64/dsmsched.log"
QUERYSCHEDPERIOD 4
ERRORLOGRETENTION N
ERRORLOGNAME "/usr/tivoli/tsm/client/oracle/bin64/dsmerror.log"
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 10.84.60.49
PASSWORDACCESS prompt
NODENAME bidb
TXNBytelimit 2097152
dirmc directory_mc
EXCLUDE.FS "/bibase"
EXCLUDE.FS "/bidev"
EXCLUDE.FS "/bitest"
EXCLUDE.FS "/biprod"
Example of /usr/tivoli/tsm/client/oracle/bin64/dsm.opt:
SERVERNAME TSM_MAVIS
DOMAIN ALL-LOCAL
No comments:
Post a Comment