Wednesday, September 11, 2013

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);
       }

No comments: