Results 1 to 6 of 6
  1. #1

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

    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
    marco bartolucci

  2. #2
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Location
    Somewhere in the US
    Posts
    5,714
    Thanks
    3
    Thanked 206 Times in 201 Posts

    Default

    How do you 'call' (start) the CAD daemons?

    Can you post the script or command that you use?
    Last edited by moon-buddy; 11-14-2012 at 06:22 PM.
    Ed

  3. #3

    Default

    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:\us r\bin:\home\oracle\bin
    export TDPO_OPTFILE=\opt\tivoli\tsm\client\oracle\bin64\t dpo.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\b in64\tdpo.opt)';
    backup filesperset 5
    format 'df_%t_%s_%p' (database); }
    Last edited by marco_bartolucci; 11-15-2012 at 03:24 AM.
    marco bartolucci

  4. #4
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Location
    Somewhere in the US
    Posts
    5,714
    Thanks
    3
    Thanked 206 Times in 201 Posts

    Default

    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
    Ed

  5. #5

    Default

    Thank you.
    I have another question:
    how to start three dsmcad at boot startup of server?
    with chkconfig ?
    marco bartolucci

  6. #6
    Moderator moon-buddy's Avatar
    Join Date
    Aug 2005
    Location
    Somewhere in the US
    Posts
    5,714
    Thanks
    3
    Thanked 206 Times in 201 Posts

    Default

    Quote Originally Posted by marco_bartolucci View Post
    Thank you.
    I have another question:
    how to start three dsmcad at boot startup of server?
    with chkconfig ?
    Red Hat Linux:

    Put the command in /etc/inittab

    Suse:

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

Similar Threads

  1. Schedule backup does not start - dsmcad
    By Alexxx in forum TSM Operation
    Replies: 4
    Last Post: 09-23-2010, 08:52 PM
  2. TDP for Oracle RMAN schedule backup fails
    By adsm04 in forum Oracle
    Replies: 14
    Last Post: 09-14-2010, 03:30 PM
  3. DSMCAD TDP for Oracle Windows question
    By booman55 in forum TSM Client
    Replies: 3
    Last Post: 06-18-2009, 05:07 PM
  4. TDP oracle database backup failed with scheduler
    By open12345 in forum Backup / Archive Discussion
    Replies: 4
    Last Post: 10-10-2007, 06:55 AM
  5. Replies: 10
    Last Post: 09-07-2005, 10:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •