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

[marco_bartolucci]

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

 

[moon-buddy]

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

Can you post the script or command that you use?

 

[marco_bartolucci]

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

 

[moon-buddy]

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

 

[marco_bartolucci]

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

 

[moon-buddy]

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)

 

[fparrilla75]

Hello,

¿Is there another way to do this in the case that dsmcad didn´t start after reboot include if I put the command in /etc/inittab?

Regards

Red Hat Linux:

Put the command in /etc/inittab

Suse:

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