THANKS!!  Just what I needed!

W

-----Original Message-----
From: Dwight Cook [mailto:cookde AT cox DOT net] 
Sent: Tuesday, July 09, 2013 8:54 AM
To: 'ADSM: Dist Stor Manager'
Cc: Prather, Wanda
Subject: RE: [ADSM-L] TSM for SAP w/Oracle RMAN

Wanda, 
        Tell them to always run with the exact same multiplexing and restore 
sessions as they did when backing up (match multiplexing and backup
sessions)
In the init<SID>.utl file there is also a MAXBACKSESSIONS and a 
MAXRESTORESESSIONS etc... your maxsessions and sessions needs to be set at the 
max expected to run at any given time and then your maxback and maxrestore need 
to be the same.

If it is really really slow and running on windows, look for a nic that's out 
of whack... and by that I mean a duplex irregularity (full on switch and half 
on windows side) but you've probably already looked at that...  (even now a 
days some 10+ years after first running into that issue I still see it 
happening *sigh*)

Only last thing would be maxnummp of the client but that would throw an error 
that would be in their brrestore log when TSM didn't allow a tape mount.

Hope this helps,
Later, 
        Dwight



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Prather, Wanda
Sent: Monday, July 08, 2013 6:08 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] TSM for SAP w/Oracle RMAN

TSM 6.3.3 on Windows (server), TDP for SAP on Oracle 6.4, TSM client 6.4.0.0
on Linux.
The Oracle DBs are compressed.

OK, I'm just the back-end server support.
No speakum SAP.

DBA did the support to set up SAP/TDP with RMAN, I'm pretty clueless.
Backups have been running beautifully, for months.
Then he left, alas.

Now a new different DBA is trying to get restores to run and they are slow
as dirt.
One obvious problem is that on backups 2 sessions run in parallel, which
back up in 4 total sessions as viewed from the server side.
Upon the restore they are running one at a time.

I know where to find the api/bin64 directory with the appropriate dsm.sys,
and I know where to find the
/oracle/SID/112_64/dbs directory and look at the initSID.utl file.
That file has maxsessions 2 in it.

Where else should I look to see why the restore is only starting 1 session
at a time?
Is that something controlled via BRtools or RMAN?
W

Wanda Prather  |  Senior Technical Specialist  | Wanda.Prather AT icfi DOT com  
|
www.icfi.com
ICF International  | 401 E. Pratt St, Suite 2214, Baltimore, MD 21202 |
410.539.1135 (o)