Monday, May 7, 2012

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