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# 无牙