THANKS!! Just what I needed! W
-----Original Message----- From: Dwight Cook [mailto:coo...@cox.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@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: Monday, July 08, 2013 6:08 PM To: ADSM-L@VM.MARIST.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.prat...@icfi.com | www.icfi.com ICF International | 401 E. Pratt St, Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o)
