1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

how to manage schedule of backup database Oracle using dsmcad and TDP

Discussion in 'TSM Client' started by marco_bartolucci, Nov 14, 2012.

  1. marco_bartolucci

    marco_bartolucci New Member

    Joined:
    Apr 13, 2006
    Messages:
    5
    Likes Received:
    0
    hi,
    I have a RAC oracle on 2 node linux (virtual machine) and I need to perform backup of file system using BA client, backup and archive log of database Oracle using TDP for Oracle. I would like to run the three schedule using dsmcad demon.
    I read that it is possible configuring three different server stanza in dsm.sys and three different client option (dsm.opt), but the task don't start...
    what is wrong?

    Thank you in adavance,
    Marco
     
  2.  
  3. moon-buddy

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,206
    Likes Received:
    279
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    How do you 'call' (start) the CAD daemons?

    Can you post the script or command that you use?
     
    Last edited: Nov 14, 2012
  4. marco_bartolucci

    marco_bartolucci New Member

    Joined:
    Apr 13, 2006
    Messages:
    5
    Likes Received:
    0
    dsmcad daemon start at boot because I insert it in chkconfig list
    my dsm.sys is:
    \opt\tivoli\tsm\client\ba\bin\dsm.sys
    * server stanza per backup del nodo PRDBORA03
    SERVERNAME prbcktsm01
    SCHEDLOGRETENTION 8 D
    SCHEDLOGNAME "\home\oracle\dsmsched.log"
    PASSWORDDIR "\home\oracle"
    PASSWORDACCESS GENERATE
    MANAGEDSERVICES WEBCLIENT SCHEDULE
    ERRORLOGRETENTION 8 D
    ERRORLOGNAME "\home\oracle\dsmerror.log"
    NODENAME PRDBORA03
    TCPSERVERADDRESS PRBCKTSM01.seda.intra
    COMMmethod TCPip
    TCPPort 1500
    * server stanza per backup del nodo Oracle TDP PRORATO
    SERVERNAME TDPORATO
    PASSWORDACCESS PROMPT
    NODENAME PRORATO
    COMMmethod TCPip
    TCPPort 1500
    TCPServeraddress prbck001.seda.intra
    Schedlogname "\home\oracle\ora_dsmsched.log"
    Errorlogname "\home\oracle\ora_dsmerror.log"
    * server stanza per gestione schedulazioni TDP Oracle
    SERVERNAME TDPOSched
    PASSWORDACCESS generate
    NODENAME TDPORATOSCHED
    COMMmethod TCPip
    TCPPort 1500
    TCPServeraddress prbck001.seda.intra
    Schedlogname "\home\oracle\Odsmsched.log"
    Errorlogname "\home\oracle\Odsmerror.log"
    MANAGEDSERVICES SCHEDULE

    my three dsm.opt:
    dsm.opt ba client in \opt\tivoli\tsm\client\ba\bin with SERVERNAME PRBCKTSM01
    dsm.opt for tdp in \opt\tivoli\tsm\client\oracle\bin64 with SERVERNAME TDPORATO
    dsmsched.opt to schedule of tdp in \opt\tivoli\tsm\client\ba\bin with SERVERNAME TDPOSched

    and my script to run rman command:
    lancio_rman_full.sh
    export LD_LIBRARY_PATH=\u01\app\oracle\product\11.2.0\db_1\lib:\lib:\usr\lib
    export ORACLE_SID=prorato1
    export ORACLE_BASE=\u01\app\oracle
    export ORACLE_HOME=\u01\app\oracle\product\11.2.0\dbhome_1
    export ORACLE_UNQNAME=oratest
    export PATH=\u01\app\oracle\product\11.2.0\dbhome_1\bin:\usr\sbin:\usr\kerberos\bin:\usr\local\bin:\bin:\usr\bin:\home\oracle\bin
    export TDPO_OPTFILE=\opt\tivoli\tsm\client\oracle\bin64\tdpo.opt
    rman target \ nocatalog @\home\oracle\backup_scripts\bck_full.rman
    and bck_full.rman script:
    run { allocate channel t1 type sbt_tape parms
    'ENV=(TDPO_OPTFILE=\opt\tivoli\tsm\client\oracle\bin64\tdpo.opt)';
    backup filesperset 5
    format 'df_%t_%s_%p' (database); }
     
    Last edited: Nov 15, 2012
  5. moon-buddy

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,206
    Likes Received:
    279
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    You have configured the OPT file properly to point back to the right dsm.sys stanza.

    DSM.SYS:

    SERVERNAME prbcktsm01
    SCHEDLOGRETENTION 8 D
    SCHEDLOGNAME "\home\oracle\dsmsched.log"
    .
    .
    .
    SERVERNAME TDPORATO
    PASSWORDACCESS PROMPT
    NODENAME PRORATO
    .
    .
    .
    SERVERNAME TDPOSched
    PASSWORDACCESS generate
    NODENAME TDPORATOSCHED

    You need three OPT files:

    DSM1.opt"

    Servername prbcktsm01

    DSM2.opt

    Servername TDPORATO

    DSM3.opt

    Servername TDPOSched


    To start DSM CAD:

    /opt/tivoli/tsm/client/ba/bin/dsmcad -optfile=/opt/tivoli/tsm/client/ba/bin/dsm1.opt 2>&1
    /opt/tivoli/tsm/client/ba/bin/dsmcad -optfile=/opt/tivoli/tsm/client/ba/bin/dsm2.opt 2>&1
    /opt/tivoli/tsm/client/ba/bin/dsmcad -optfile=/opt/tivoli/tsm/client/ba/bin/dsm3.opt 2>&1
     
  6. marco_bartolucci

    marco_bartolucci New Member

    Joined:
    Apr 13, 2006
    Messages:
    5
    Likes Received:
    0
    Thank you.
    I have another question:
    how to start three dsmcad at boot startup of server?
    with chkconfig ?
     
  7. moon-buddy

    moon-buddy Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,206
    Likes Received:
    279
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    Red Hat Linux:

    Put the command in /etc/inittab

    Suse:

    Create a script to launch it in RC3 (Run Level 3)
     

Share This Page