ADSM-L

[ADSM-L] TDP Oracle issue: thousands of near simultaneous sessions per node

2013-05-29 11:52:07
Subject: [ADSM-L] TDP Oracle issue: thousands of near simultaneous sessions per node
From: Rick Adamson <RickAdamson AT WINN-DIXIE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 29 May 2013 15:49:45 +0000
Looking for some direction...

I recently inherited a TSM server along with many TDP for Oracle nodes.
The TSM server is 5.4 (upgrade on the horizon).
The Oracle clients run on mostly AIX, but some Suse Linux, the TDP client is 
ver.5.5.x and the BA clients are primarily 6.2.

All of the database and log backups are initiated by CRON and when they start a 
single Oracle node will start and stop literally thousands of sessions on the 
TSM server within a minute or two.

Oracle and RMAN are new to me and I have talked with our DBA team regarding the 
problem but to no surprise they imply it is a TSM issue.
When this occurs the obvious impact to the TSM server is devastating, 
performance is crushed and the console churn is a blur.

In reading the Oracle and TDP documentation I am suspicious of the RMAN scripts 
as the cause, but before I go testing changes or opening a support case, I 
thought I would ask the group.

The RMAN scripts do perform several "crosschecks" during the process and I 
suspect that each backup piece it queries for starts and stops a client session 
on the TSM server.

Has anyone seen this issue before? Is there any way to get the TDP client to 
perform all operations during a single, or minimal,  sessions?
I have included the RMAN script I suspect below.....

All feedback welcome,
~Rick

===================================================

rman target backup/sqbkup3 catalog rman10/sqbkup3@rcat1_catalog.world <<EOF #> 
/opt/oracle/log/rman_full_csp1.log 2>&1
run {
allocate channel tdp1 type 'sbt_tape'
parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.csp1.opt)';
setlimit channel tdp1 kbytes 1073741824 maxopenfiles 32 readrate 200;

sql 'alter system archive log current';
resync catalog;
change archivelog all validate;
backup database include current controlfile
format 'df_%t_%s_%p';
backup archivelog all delete input
format 'al_%t_%s_%p';
release channel tdp1;
}
EOF
#

rman <<EOF #> /opt/oracle/log/backup_delete_csp1.log 2>&1
connect target backup/sqbkup3
connect catalog rman10/sqbkup3@rcat1_catalog.world
allocate channel for delete type 'sbt_tape'
parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.csp1.opt)';
configure retention policy to recovery window of 14 days;
list backup of database;
list backup of database summary;
list backup of archivelog all summary;
crosscheck backup;
delete noprompt obsolete;
delete noprompt expired backup;
crosscheck backup;
release channel;
allocate channel for delete type disk;
crosscheck backup;
delete noprompt obsolete;
delete noprompt expired backup;
crosscheck backup;
list backup of database;
EOF

<Prev in Thread] Current Thread [Next in Thread>