Quick configuration of TSM Data Protection for Oracle on an AIX

1. Prerequests
1. TDP for  Oracle  must  be  installed before
2. Policy,domain,backup copy,storage pools  ...etc  must be defined  on TSM server  side
3. TDP for  Oracle  node must  be  registred  before on server  side ( e.x node name   =dbgenomt e.x domain name  = DM_TEST_ORACLE  )
   
   REG NODE dbgenomt  password_1234  dom=DM_TEST_ORACLE  backdel=yes
 
2. Link the Oracle target database instance with Data Protection for Oracle by performing the following steps: (with  oracle user  )
1. Change the LIBPATH environment variable to include $ORACLE_HOME/lib before /usr/lib. If you have a LD_LIBRARY_PATH, ensure that this has the $ORACLE_HOME/lib before /usr/lib.
2. Ensure the SBT_LIBRARY parameter is not set
3. Shut down all Oracle instances that use $ORACLE_HOME
4. Link  TDP library file directly to the Oracle directory
   cd /usr/tivoli/tsm/client/oracle/bin64/
   ln -s /usr/tivoli/tsm/client/oracle/bin64/libobk64.a $ORACLE_HOME/lib/libobk.a
5. Start the Oracle instances
3. Configure  tdpo.opt   file  under  /usr/tivoli/tsm/client/oracle/bin64
1. copy  tdpo.opt.smp64  as tdpo.opt
   
    
   cd /usr/tivoli/tsm/client/oracle/bin64
   cp  tdpo.opt.smp64   tdpo.opt
    
2. change  and  open * character t for   following lines 
   
   dsmi_orc_config  /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
   dsmi_log              
   
4.   create  dsm.opt  in the same  directory  that inclused  node name  (e.x  dbgenomt )
   

   cd /usr/tivoli/tsm/client/oracle/bin64
   echo   "SErvername dbgenomt"  >dsm.opt 
5. dsm.sys file 
1. create  a  symbolic link  in order  to  have only one copy  of  dsm.sys file
   ln -s /usr/tivoli/tsm/client/ba/bin64/dsm.sys /usr/tivoli/tsm/client/api/bin64/dsm.sys
2. Edit the dsm.sys file to include another server stanza with the following options (e.x node name  dbgenomt ) and  x.x.x.x is  the  IP  adress  of  IP address of the Tivoli Storage Manager
   
   
   SErvername dbgenomt    nodename dbgenomt    QUERYSCHEDPERIOD 1
       TCPNODELAY NO
       RETRYPERIOD 10
       ERRORLOGNAME "/tmp/dbtmp/dbgenomt_dsmerror.log"    SCHEDLOGNAME "/tmp/dbtmp/dbgenomt_dsmsched.log"
       SCHEDMODE POLLING
       SCHEDLOGRETENTION 4 D
       ERRORLOGRETENTION 4 D
       PASSWORDACCESS GENERATE
       passworddir  /genomtest/genomt    COMMmethod  TCPIP
       tcpserveraddress x.x.x.x    tcpport 1500
       TXNBYTELIMIT 2097152
       managedservices webclient
6. Make sure the Oracle user has the following permissions
1.  Read (r) permission to the /usr/tivoli/tsm/client/oracle/bin64 and /usr/tivoli/tsm/client/api/bin64 directories
1. Read permission (r-) to the tdpo.opt, dsm.opt, and dsm.sys files located in the /usr/tivoli/tsm/client/oracle/bin and /usr/tivoli/tsm/client/api/bin directories
7.  Change to the /usr/tivoli/tsm/client/oracle/bin64 directory and run the tdpoconf password command (as Oracle user) to generate the password file
   
   cd /usr/tivoli/tsm/client/oracle/bin64
   tdpoconf  password 
8. Run the tdpoconf showenvironment command to confirm proper configuration
   tdpoconf showenvironment
9. You can  take  backup (e.x script )
   run
   {
      allocate channel t1 type 'sbt_tape' parms
               'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
         backup
         filesperset 5
         format 'df_%t_%s_%p'
         (database);
      }