RE: Tivoli and Rman issue
- From: "Vishal Gupta" <vishal@xxxxxxxxxxxxxxx>
- To: <jack@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 12 Oct 2009 13:26:09 +0100
Jack,
We were recently having major headaches with following error message from TSM
since our TDP client and server upgrade.
ANS1309I (RC9) The requested data is offline.
On TSM server we have a disk cache enabled. And storage pool is set to 2GB,
which means all files <2GB go to TSM server disk first. And then TSM moves them
to tape in background. So we have set the MAXPIEICE size to 2GB in RMAN
configuration. This avoids the need to use tape head for every backup.
We backup database/archivelogs to local server disk using RMAN. Then using RMAN
itself transfer these backupsets from disk to TSM server via TDP. Normally TDP
modifies the rman backuppiece header and places some header inforornation to
it. But since the TDPO client upgrade to 5.2.2, tdp has started putting more
data in backuppiece header. So it breaching 2GB limit when it goes to TSM.
We had raised an case with IBM and sent TDP and TSM traces to IBM, it was down
to TSM not closing a handle on disk and opening handle on tape etc.
Ultimately solutions was either to reduce the maxsize of backuppiece. Or
increase the 2GB threshold on TSM server. So that TDP does not artificially
increase backuppiece size beyond TSM server threshold.
Regards,
Vishal Gupta
http://www.vishalgupta.com
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Jack van Zanen
Sent: Sun 11/10/2009 22:49
To: oracle-l@xxxxxxxxxxxxx
Subject: Tivoli and Rman issue
Hi All,
We are using RMAN and Tivoli to backup our databases and are having an issue
during which channels fail and the backup has to continue on less channels
error from the RMAN log
RMAN-03009: failure of backup command on c1 channel at 10/11/2009 00:11:45
ORA-19502: write error on file
"daily_PDMP_BACKUP_AL_online_20091010_231001_103241_1_1", blockno 5121
(blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1309I (RC9) The requested data is offline.
channel c1 disabled, job failed on it will be run on another channel
Our storage guys have come up with the solution to run tdposync but this does
not sound right to me, as I would expect a mismatch between the repository of
RMAN and the TSM during a backup. There is the issue described on IBM website
for controlfile autobackup which generates the same message but this is during
backup of archive logs and or datafiles (randomly).
Also I have no experience on running tdposync and have no idea about what it
could possibly stuff up.
Any insights?
--
Jack van Zanen
-------------------------
This e-mail and any attachments may contain confidential material for the sole
use of the intended recipient. If you are not the intended recipient, please be
aware that any disclosure, copying, distribution or use of this e-mail or any
attachment is prohibited. If you have received this e-mail in error, please
contact the sender and delete all copies.
Thank you for your cooperation
Other related posts:
