multiple oracle nodes on the same machine in linux

[tsmdumber]

Hi

Can some one guide me on how to have multiple node son the same machine for linux based systems for oracle backups?

For windows its simple use 2 tdpo.opts one for daily and one for monthly and point 2 dsm.opts one for daily and monthly. this works fine for me.

When i try to use multiple tdpo.opts on the same machine for linux systems somehow the data goes only through the daily node.

My config is as below.

Monthly dsm.opt and tdpo.opt lies here

/opt/tivoli/tsm/client/oracle/bin64/monthly/

[root@li0basdb04p monthly]# cat dsm.opt
************************************************************************
* Tivoli Storage Manager *
* *
* Sample Client User Options file for UNIX (dsm.opt.smp) *
************************************************************************

* This file contains an option you can use to specify the TSM
* server to contact if more than one is defined in your client
* system options file (dsm.sys). Copy dsm.opt.smp to dsm.opt.
* If you enter a server name for the option below, remove the
* leading asterisk (*).

************************************************************************

SErvername TSM_ORA_ARCH

[root@li0basdb04p monthly]# cat tdpo.opt
***************************************************************************
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the LinuxAMD64 Data Protection for Oracle
*********************************************************************

DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin64/monthly/dsm.opt
DSMI_LOG /opt/tivoli/tsm/client/oracle/bin64/monthly/

*TDPO_FS /adsmorc
*TDPO_NODE <hostname>
*TDPO_OWNER <username>
TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin64/monthly/

*TDPO_DATE_FMT 1
*TDPO_NUM_FMT 1
*TDPO_TIME_FMT 1

*TDPO_MGMT_CLASS_2 mgmtclass2
*TDPO_MGMT_CLASS_3 mgmtclass3
*TDPO_MGMT_CLASS_4 mgmtclass4

-------------------------------------------------------------------
dsm.sys and dsm.opt of opt/tivoli/tsm/client/api/bin64 as below



[root@li0basdb04p bin64]# cat dsm.sys
************************************************************************
* Tivoli Storage Manager *
* *
* Sample Client System Options file for UNIX (dsm.sys.smp) *
************************************************************************

* This file contains the minimum options required to get started
* using TSM. Copy dsm.sys.smp to dsm.sys. In the dsm.sys file,
* enter the appropriate values for each option listed below and
* remove the leading asterisk (*) for each one.

* If your client node communicates with multiple TSM servers, be
* sure to add a stanza, beginning with the SERVERNAME option, for
* each additional server.

************************************************************************

SErvername TSM_ORA
COMMMethod TCPip
TCPPort 1700
TCPServeraddress PRD2TSM
Nodename LI0BASDB04P_ORA
Passwordaccess Prompt


SErvername TSM_ORA_ARCH
COMMMethod TCPip
TCPPort 1700
TCPServeraddress PRD2TSM
Nodename LI0BASDB04P_ORA_ARCH
Passwordaccess Prompt

[root@li0basdb04p bin64]# cat dsm.opt
************************************************************************
* Tivoli Storage Manager *
* *
* Sample Client User Options file for UNIX (dsm.opt.smp) *
************************************************************************

* This file contains an option you can use to specify the TSM
* server to contact if more than one is defined in your client
* system options file (dsm.sys). Copy dsm.opt.smp to dsm.opt.
* If you enter a server name for the option below, remove the
* leading asterisk (*).

************************************************************************
SErvername TSM_ORA
SErvername TSM_ORA_ARCH


----------------------------------------------------------------------

rman script is as below

MAN> run
2> {
3> allocate channel t1 type 'sbt_tape' parms'ENV=(tdpo_optfile=/opt/tivoli/tsm/client/oracle/bin64/monthly/tdpo_arch.opt)';
4> backup current controlfile;
5> }

allocated channel: t1
channel t1: SID=65 device type=SBT_TAPE
channel t1: Data Protection for Oracle: version 6.3.0.0

Starting backup at 06-FEB-13
channel t1: starting full datafile backup set
channel t1: specifying datafile(s) in backup set
including current control file in backup set
channel t1: starting piece 1 at 06-FEB-13
channel t1: finished piece 1 at 06-FEB-13
piece handle=q2o19s5g_1_1 tag=TAG20130206T132504 comment=API Version 2.0,MMS Version 6.3.0.0
channel t1: backup set complete, elapsed time: 00:00:03
Finished backup at 06-FEB-13

Starting Control File and SPFILE Autobackup at 06-FEB-13
piece handle=c-1264441810-20130206-04 comment=API Version 2.0,MMS Version 6.3.0.0
Finished Control File and SPFILE Autobackup at 06-FEB-13
released channel: t1

-------------------------------------------------------

corresponding actlog out for the same command is

ANR0406I Session 122431 started for node LI0BASDB04P_ORA (TDPO Linux86-64)
(Tcp/Ip 10.1.86.58(41244)).
ANR0406I Session 122432 started for node LI0BASDB04P_ORA (TDPO Linux86-64)
(Tcp/Ip 10.1.86.58(41245)).
ANR0403I Session 122431 ended for node LI0BASDB04P_ORA (TDPO Linux86-64).
ANR0403I Session 122432 ended for node LI0BASDB04P_ORA (TDPO Linux86-64).
ANR0406I Session 122433 started for node LI0BASDB04P_ORA (TDPO Linux86-64)
(Tcp/Ip 10.1.86.58(41247)).
ANR0403I Session 122433 ended for node LI0BASDB04P_ORA (TDPO Linux86-64).
ANR0406I Session 122434 started for node LI0BASDB04P_ORA (TDPO Linux86-64)
(Tcp/Ip 10.1.86.58(41248)).
ANR0406I Session 122435 started for node LI0BASDB04P_ORA (TDPO Linux86-64)
(Tcp/Ip 10.1.86.58(41249)).
ANR0403I Session 122434 ended for node LI0BASDB04P_ORA (TDPO Linux86-64).
ANR0403I Session 122435 ended for node LI0BASDB04P_ORA (TDPO Linux86-64).

--------------------------------------------------------------------

daily node config just in case if it is related


/opt/tivoli/tsm/client/api/bin64
[root@li0basdb04p bin64]# cd ..
[root@li0basdb04p api]# cd ..
[root@li0basdb04p client]# cd oracle/bin64/
[root@li0basdb04p bin64]# ls
agent.lic dsierror.log EN_US libobk.so monthly TDPO. tdpoconf tdpoerror.log tdpo.opt tdpo.opt.smp tdposync
[root@li0basdb04p bin64]# cat tdpo.opt
***************************************************************************
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the LinuxAMD64 Data Protection for Oracle
*********************************************************************

DSMI_ORC_CONFIG /opt/tivoli/tsm/client/api/bin64/dsm.opt
DSMI_LOG /opt/tivoli/tsm/client/oracle/bin64

*TDPO_FS /adsmorc
*TDPO_NODE <hostname>
*TDPO_OWNER <username>
TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin64

*TDPO_DATE_FMT 1
*TDPO_NUM_FMT 1
*TDPO_TIME_FMT 1

*TDPO_MGMT_CLASS_2 mgmtclass2
*TDPO_MGMT_CLASS_3 mgmtclass3
*TDPO_MGMT_CLASS_4 mgmtclass4

-------------------------------------------


thoughts?

Regards,
TSMDUMBER

 

[chad_small]

It comes down to settings used for the DSMI environmental variables. You either would need to change the DSMI_CONFIG value to point to another opt or run each backup as a different Linux user with the appropriate variable setting.

 

[tsmdumber]

hi

Chad thanks!

I tried to change the DSMI values from tdpo.opt somehow it doesn't pick that value

DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin64/monthly/dsm.opt
DSMI_LOG /opt/tivoli/tsm/client/oracle/bin64/monthly/

Can you throw some light on which environment values is hould specifically modify?

env from the server for root which runs the backup is as below. i dont see any dsmi related setting here.


[root@li0basdb04p ~]# env
HOSTNAME=li0basdb04p
TERM=xterm
SHELL=/bin/bash
HISTSIZE=1000
KDE_NO_IPV6=1
SSH_CLIENT=10.20.254.196 3717 22
QTDIR=/usr/lib64/qt-3.3
QTINC=/usr/lib64/qt-3.3/include
SSH_TTY=/dev/pts/2
USER=root
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36i=40;33:so=00;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
KDEDIR=/usr
MAIL=/var/spool/mail/root
PATH=/usr/lib64/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
INPUTRC=/etc/inputrc
PWD=/root
LANG=en_US.UTF-8
KDE_IS_PRELINKED=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SHLVL=1
HOME=/root
LOGNAME=root
QTLIB=/usr/lib64/qt-3.3/lib
CVS_RSH=ssh
SSH_CONNECTION=10.20.254.196 3717 10.1.86.58 22
LESSOPEN=|/usr/bin/lesspipe.sh %s
G_BROKEN_FILENAMES=1
_=/bin/env

Regards,
tsmdumber