GregE
ADSM.ORG Senior Member
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.
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.
Last edited: