Need RMAN Help

[GregE]

Anyone know to restore specific things that may have failed during a large restore? We're restoring a DB for a data center cutover this weekend (yea, the mad scramble is underway) and a large database is currently restoring, hundreds of backup pieces are restoring, but along the way are 3 errors......

channel t1: reading from backup piece bk_2417_1_750374126
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
ANS1235E (RC-71) An unknown system error has occurred from which TSM cannot recover.
ORA-19870: error reading backup piece bk_2417_1_750374126
ORA-19501: read error on file "bk_2417_1_750374126", blockno 2049 (blocksize=512)
ORA-27190: skgfrd: sbtread2 returned error
ORA-19511: Error received from media manager layer, error text

......

channel t1: reading from backup piece bk_2416_1_750374126
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
ANS1235E (RC-71) An unknown system error has occurred from which TSM cannot recover.
ORA-19870: error reading backup piece bk_2416_1_750374126
ORA-19501: read error on file "bk_2416_1_750374126", blockno 2049 (blocksize=512)
ORA-27190: skgfrd: sbtread2 returned error
ORA-19511: Error received from media manager layer, error text

.......

channel t2: reading from backup piece bk_2368_1_749955697
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
ANS1235E (RC-71) An unknown system error has occurred from which TSM cannot recover.
ORA-19870: error reading backup piece bk_2369_1_749955697
ORA-19501: read error on file "bk_2369_1_749955697", blockno 2049 (blocksize=512)
ORA-27190: skgfrd: sbtread2 returned error
ORA-19511: Error received from media manager layer, error text

.......

I don't want to have to start over, only to see it fail again. I'd like to be able to restore specific backup pieces (maybe its at file level and RMAN knows the piece?) once we determine how we'll get them. Does anyone know how to do that? Still researching.

 

[hogmaster]

You can write a rman restore script to restore only the backup piece (bk_xxxx),
this is "normal" DBA business, ask the DBA to involve oracle support, I have seen this happen
during TB restores with production databases.

Good luck

 

[Harry_Redl]

Hi,

is this a LanFree operation? Check the activity log for severed sessions due to timeouts - this (RC71, RC72) can happen when restoring (backing up) the backup piece takes more than 15 minutes (the default) and the (metadata) session times out. Increase COMMTIMEOUT and IDLETIMEOUT parameters (both on StorageAgent and TSM server).

Harry

P.S. if just a few backup pieces failed RMAN should be able just to check the existence of backup pieces already restored and restore the missing ones only

 

[GregE]

Thanks guys. Yes it's LANFree. The DBA is running a full restore to another server as a test. Another error shows up....

restoring datafile 00003 to +ASMDATA_TESTDB/testdb/datafile/tsp_default_0.325.680361743
restoring datafile 00072 to +ASMDATA_TESTDB/testdb/dmdata.bdbf
ORA-19870: error reading backup piece bk_2529_10_750560542
ORA-19501: read error on file "bk_2529_10_750560542", blockno 1 (blocksize=512)
ORA-27190: skgfrd: sbtread2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1314E (RC14) File data currently unavailable on server

So I used this technote due to the error mentioned....
https://www-304.ibm.com/support/docview.wss?uid=swg21249032

The backup piece that failed, is on a tape that was part of a "move data" process that was running, so I assume it timed out and moved on. Now we have to figure out how to restore only single backup pieces.

Edit: I wouldnt restore a backup piece, I'd restore a data file that is part of the backup set......

restore datafile '+ASMDATA_TESTDB/testdb/datafile/tsp_default_0.325.680361743';
restore datafile '+ASMDATA_TESTDB/testdb/dmdata.bdbf';
..or..
restore datafile 3;
restore datafile 72;

DBA will have to get into this one.