NBU異機恢復oracle ORA-19511 求助

lcrash

NBU異機恢復oracle報錯如下，rman有一部分找不到文件，
但是又有一部分能找到，而且通過bplist看 找不到的文件確實找不到，關鍵是這次備份的是全備啊，為什么找不到呢，求教


ORA-19511: Error received from media manager layer, error text:
   Backup file <bk_16542_1_780728609> not found in NetBackup catalog
channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00029 to /orabackdata/cwgkvpd/datafile29.dbf
restoring datafile 00040 to /orabackdata/cwgkvpd/datafile40.dbf
restoring datafile 00071 to /orabackdata/cwgkvpd/datafile71.dbf
channel ch00: reading from backup piece bk_16543_1_780730244
ORA-19870: error reading backup piece bk_16543_1_780730244
ORA-19507: failed to retrieve sequential file, handle="bk_16543_1_780730244", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Backup file <bk_16543_1_780730244> not found in NetBackup catalog
channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00038 to /orabackdata/cwgkvpd/datafile38.dbf
channel ch00: reading from backup piece bk_16547_1_780742786
ORA-19870: error reading backup piece bk_16547_1_780742786
ORA-19507: failed to retrieve sequential file, handle="bk_16547_1_780742786", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Backup file <bk_16547_1_780742786> not found in NetBackup catalog
channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /orabackdata/cwgkvpd/datafile01.dbf
channel ch00: reading from backup piece bk_16549_1_780746607
ORA-19870: error reading backup piece bk_16549_1_780746607
ORA-19507: failed to retrieve sequential file, handle="bk_16549_1_780746607", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Backup file <bk_16549_1_780746607> not found in NetBackup catalog
channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /orabackdata/cwgkvpd/datafile02.dbf
restoring datafile 00003 to /orabackdata/cwgkvpd/datafile03.dbf
channel ch00: reading from backup piece bk_16548_1_780746462
ORA-19870: error reading backup piece bk_16548_1_780746462
ORA-19507: failed to retrieve sequential file, handle="bk_16548_1_780746462", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Backup file <bk_16548_1_780746462> not found in NetBackup catalog
channel ch00: starting datafile backupset restore
channel ch00: specifying datafile(s) to restore from backup set
restoring datafile 00061 to /orabackdata/cwgkvpd/datafile61.dbf
restoring datafile 00093 to /orabackdata/cwgkvpd/datafile93.dbf
restoring datafile 00110 to /orabackdata/cwgkvpd/datafile110.dbf
restoring datafile 00151 to /orabackdata/cwgkvpd/datafile151.dbf
restoring datafile 00152 to /orabackdata/cwgkvpd/datafile152.dbf
channel ch00: reading from backup piece bk_16899_1_781272076

無牙

是不是備份到不同磁帶，然后磁帶又被手動過期了?

lcrash

斑竹啊，謝謝
應該不是，后來看了下他要找的時間的備份集rman的全備剛好過期被刪了，只有增量，我后面試了下有全備的時間點后的不完全恢復，等待結果中啊
回復 2# 無牙