RMAN doesn't send anything to tsm

M

msosin

Active Newcomer
Joined
Apr 16, 2010
Messages
40
Reaction score
0
Points
0
Hello gurus,

I'm facing really strange problem. TDP seems to be configured ok, backup using rman seems to be working fine except:

- tsm server can't see any session from oracle node while doing backup
- there is no data transfer to tsm server

I read through tdp for oracle redbook, and still no clue what could go wrong...

Any ideas?
 
***************************************************
gondor:/usr/tivoli/tsm/client/ba/bin # oslevel
5.1.0.0

***************************************************
gondor:/usr/tivoli/tsm/client/oracle/bin64 # tdpoconf showenv

IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 2, Level 0.0
(C) Copyright IBM Corporation 1997, 2003. All rights reserved.


DATA PROTECTION FOR ORACLE INFORMATION
Version: 5
Release: 2
Level: 0
Sublevel: 0
Platform: 64bit TDP Oracle AIX

TSM SERVER INFORMATION
Server Name: TSMSERVER2
Server Address: 192.168.X.152
Server Type: Linux/x86_64
Server Port: 1500
Communication Method: TCP/IP

SESSION INFORMATION
Owner Name:
Node Name: gondordb
Node Type: TDP Oracle AIX
DSMI_DIR: /usr/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG: /usr/tivoli/tsm/client/api/bin64/dsm.opt
TDPO_OPTFILE: /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
Password Directory: /usr/tivoli/tsm/client/oracle/bin64/
Compression: FALSE

***************************************************
Oracle 9.2.0.1

***************************************************
gondor:/usr/tivoli/tsm/client/oracle/bin64 # cat dsm.opt
servername TSMSERVER2

***************************************************
gondor:/usr/tivoli/tsm/client/oracle/bin64 # cat dsm.sys
NODENAME gondordb
servername TSMSERVER2
TCPSERVERADDRESS 192.168.64.152
MANAGEDSERVICES WEBCLIENT SCHEDULE
COMPRESSION YES
COMPRESSALWAYS YES
errorlogname /usr/tivoli/tsm/client/oracle/bin64/gondordblog.log
schedlogname /usr/tivoli/tsm/client/oracle/bin64/gondordbschedlog.log




***************************************************
gondor:/usr/tivoli/tsm/client/oracle/bin64 # cat tdpo.opt

*********************************************************************
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the Data Protection for Oracle on Win x64
*********************************************************************

*====================================================================
* TSM API configuration
*====================================================================
DSMI_ORC_CONFIG /usr/tivoli/tsm/client/api/bin64/dsm.opt
DSMI_LOG /usr/tivoli/tsm/client/oracle/bin64/
TDPO_NODE gondordb
TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64/
TDPO_FS gondordb


*====================================================================
* TSM Server - filespace name
*
* TDPO_FS default: adsmorc
*
*====================================================================
*TDPO_FS adsmorc


*=====================================================================
* NLS Configuration
*
* TDPO_DATE_FMT default: 1
* TDPO_NUM_FMT default: 1
* TDPO_TIME_FMT default: 1
* TDPO_LANGUAGE default: enu
*
*=====================================================================
TDPO_DATE_FMT 3
TDPO_TIME_FMT 3
TDPO_NUM_FMT 3
TDPO_LANGUAGE enu


*====================================================================
* Management Class binding for Rman Duplex Copy
*====================================================================
*TDPO_MGMT_CLASS_2 mgmtclass2
*TDPO_MGMT_CLASS_3 mgmtclass3
*TDPO_MGMT_CLASS_4 mgmtclass4
tdpo_trace_flags orclevel0 orclevel1 orclevel2
tdpo_trace_file /oracle2/tsm/scripts/tdpo.out


***************************************************
Trace:

2010-04-29 15.02.59.966 [037790] [1] : tdpoconf.cpp ( 547):
DSMI_DIR : /usr/tivoli/tsm/client/api/bin64
DSMI_LOG : /usr/tivoli/tsm/client/oracle/bin64/
DSMI_ORC_DIR : /usr/tivoli/tsm/client/oracle/bin64
DSMI_ORC_CONFIG : /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
TDPO_AVG_SIZE : 50
TDPO_FS : /gondordb
TDPO_NODE : gondordb
TDPO_OWNER : oracle
TDPO_PSWDPATH : /usr/tivoli/tsm/client/oracle/bin64/
TDPO_TRACE_MAX :
TDPO_TRACE_FILE : /oracle2/tsm/scripts/tdpo.out
TDPO_TRACE_FLAGS : orclevel0 orclevel1 orclevel2
TDPO_MGMT_CLASS_2 :
TDPO_MGMT_CLASS_3 :
TDPO_MGMT_CLASS_4 :
TDPO_NUM_BUFFERS : 1
TDPO_DATE_FORMAT : 3
TDPO_TIME_FORMAT : 3
TDPO_NUM_FORMAT : 3
TDPO_LANGUAGE : enu

***************************************************
gondor:/oracle2/tsm/scripts # cat bkdb_ecixe.sh
rman cmdfile /oracle2/tsm/scripts/rman_backup_ecixe_onl msglog /oracle2/tsm/sripts/ecixe.log

gondor:/oracle2/tsm/scripts # cat rman_backup_ecixe_onl
connect target sys/xxx@ecixe;
connect catalog rman/xxx@RCAT10;

run{

resync catalog;
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

change archivelog all validate;
backup
format 'db_%d_%s_%t'
database plus archivelog;

change archivelog all validate;
backup
(archivelog all format 'al_%d_%s_%t' delete all input);

release channel t1;

}



***************************************************
gondor:/usr/tivoli/tsm/client/api/bin64 # cat dsm.opt
* SErvername A server name defined in the dsm.sys file
SE TSMSERVER2

***************************************************
gondor:/usr/tivoli/tsm/client/api/bin64 # cat dsm.sys

SErvername tsmserver2
COMMmethod TCPip
TCPPort 1500
TCPServeraddress 192.168.64.152
schedlogret 7
tcpb 128
tcpw 256
txnbyte 2097152
tcpnodelay no
managedserv schedule webcli
querysch 1
include.backup /*/.../* bazydata
 
How are you running Oracle RMAN backups - via TSM Scheduler or cron?

Regardless, you are missing the TDP stanza in dsm.sys.
 
I thought I have everything. Can you please give me an example?

node is registered properly I guess.

tdpoconf showenv shows everything, it was included in the text below.
 
SErvername TSMServer

COMMmethod tcpip
TCPPort 1500
TCPServeraddress <TSM_Server_Name>
NODEName <FS_Node_name>
TCPBuffsize 512
TCPWindowsize 0
Txnbytelimit 25600
Tcpnodelay Yes
Largecommbuffers Yes
Managedservices webclient schedule
Resourceutilization 4
Passwordaccess generate
Schedmode prompted
Schedlogname dsmsched.log
Schedlogretention 15,d
Errorlogname dsmerror.log
Errorlogretention 15,d
Changingretries 0

SErvername TDPServer

COMMmethod tcpip
TCPPort 1500
TCPServeraddress <TSM_Server_name>
TCPBuffsize 512
TCPWindowsize 0
Txnbytelimit 25600
Tcpnodelay Yes
Largecommbuffers Yes
Managedservices webclient schedule
Resourceutilization 6
Nodename <TDP_Node_name>
Passwordaccess generate
Passworddir /usr/tivoli/tsm/client/oracle/bin64
Schedmode prompted
Schedlogname dsmsched.tdp.log
Schedlogretention 30,d
Errorlogname dsmerror.tdp.log
Errorlogretention 30,d
Changingretries 0
Compression yes
 
Here is an example of what we use...

we add an _tdp to the servername. We also backup the OS and TDP to different servers...

SErvername TSM01
COMMMethod TCPip
TCPPort 1500
TCPServeraddress tsm01
TCPWindowsize 256
TCPBuffsize 32
TCPNodelay yes
LARGECOMmbuffers yes

NODEName qadora01
DOMAIN all-local
PASSWordaccess generate
TXNBytelimit 2097152

SCHEDLOGName /usr/tivoli/tsm/client/ba/logs/dsmsched.log
ERRORLOGName /usr/tivoli/tsm/client/ba/logs/dsmerror.log
SCHEDLOGRetention 30 D
ERRORLOGRetention 30 D

inclexcl /usr/tivoli/tsm/client/ba/bin/inclexcl

***************** TDP for ORACLE Stanza ***************
SErvername STTSM01_TDP
COMMmethod TCPip
TCPPort 1500
TCPServeraddress tsm02
TCPClientaddress qadora01_tdp
HTTPport 1581
WEBPorts 1582 1583
Nodename qadora01_tdp
Passwordaccess prompt

TXNBytelimit 2097152
TCPWindowsize 256
TCPBuffsize 32
TCPNodelay YES
LARGECOMmbuffers YES

SCHEDLOGName /usr/tivoli/tsm/client/ba/logs/tdp/dsmsched.log
ERRORLOGName /usr/tivoli/tsm/client/ba/logs/tdp/dsmerror.log
SCHEDLOGRetention 30 D
ERRORLOGRetention 30 D

***************** TDP for ORACLE Sched Stanza ***************
SErvername STTSM01_TDP_SCHED
COMMmethod TCPip
TCPPort 1500
TCPServeraddress tsm02
TCPClientaddress qadora01_tdp
HTTPport 1581
WEBPorts 1582 1583
Nodename qadora01_tdp
Passwordaccess generate

TXNBytelimit 2097152
TCPWindowsize 256
TCPBuffsize 32
TCPNodelay YES
LARGECOMmbuffers YES

SCHEDLOGName /usr/tivoli/tsm/client/ba/logs/tdp/dsmsched.log
ERRORLOGName /usr/tivoli/tsm/client/ba/logs/tdp/dsmerror.log
SCHEDLOGRetention 30 D
ERRORLOGRetention 30 D
 
Hi all,

Thanks for your suggestions, but still no joy.

I double checked configs and everyting looks ok.

What is weird is the fact that I tried to backup oracle on Solaris and there was no joy neither.

I think I will have to go through RMAN config since this is a new server...

Speak to you later,



EDIT:

I didn't mention the fact that there is nothing in the error and sched log. It looks like rman ignores "ENV" directive and doesn't connect to TSM at all. Hope that helps to understand better.

M
 
Last edited:
gondor:/usr/tivoli/tsm/client/oracle/bin64/scripts # cat rman_ecixe.sh
#!/bin/ksh
rman 'cmdfile rman_db_ecixe_onl.dat' ' msglog ecixe_log.txt'


and then:

gondor:/usr/tivoli/tsm/client/oracle/bin64/scripts # cat rman_db_ecixe_onl.dat
connect target sys/xxx@ecixe;
connect catalog rman/xxx@RCAT10;


run{

allocate channel t1 device type sbt_tape
parms='ENV=(TDPO_OPTFILE= /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

change archivelog all validate;
backup
format 'db_%d_%s_%t'
database plus archivelog;

change archivelog all validate;
backup
(archivelog all format 'al_%d_%s_%t' delete all input);

release channel t1;

}
 
I think that libraries are linked wrong.

In the RMAN output I see the entry:
przydzielono kana³: t1
kana³ t1: sid=202 typ urz.=SBT_TAPE
kana³ t1: NMO v4.2.0.0
The "NMO v4.2.0.0" is the EMC Legato Networker library for oracle.

However:

root@arha # find / -name libobk* -exec ls -l {} \; 2>/dev/null
lrwxrwxrwx 1 root other 45 May 5 14:23 /usr/lib/sparcv9/libobk.so -> /opt/tivoli/tsm/client/oracle/bin64/libobk.so
-rwxr-xr-x 1 root other 1035856 Jun 3 2009 /opt/tivoli/tsm/client/oracle/bin64/libobk.so
lrwxrwxrwx 1 oracle dba 16 Oct 31 2008 /oradata/zbyt/app/product/9.2.0/lib/libobk.so -> /lib/libnwora.so
lrwxrwxrwx 1 oracle dba 16 Oct 31 2008 /oradata/zbyt/app/product/9.2.0/libobk.so -> /lib/libnwora.so

Any ideas?

Regards,
 
You must log in or register to reply here.

Data Privacy Impact Assessment

Compliance Assurance in Every Byte: Discover the Impact of Our DPIA Services.

Sponsor ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

Navigation Menu

Forums
   IBM TSM
   EMC Backup and Recovery
   Symantec NetBackup  
   SAN  
   NAS
   Platforms / OS
Mailing List Archives
   ADSM-L
User Groups

NordVPN 3 Months FREE

Help Support ADSM.ORG and Get NordVPN with 64% Off and 3 Months FREE.

NordVPN with 64% off + 3 months FREE

Forum statistics

Threads
31,974
Messages
135,448
Members
21,953
Latest member
jrogers
Back
Top