刪除歸檔物理檔案備份失敗!ORA-19625

chicken0915發表於2012-07-12

ORA-19625 rman備份錯誤不能備份

Recovery Manager complete.
[Major] From: "mesdb" Time: 07/13/11 13:24:54
The database reported error while performing requested operation.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 07/13/2011 13:24:53
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /mesdb10g/archive/1_263349_690903176.dbf
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3

====解決辦法

在DB上run crosscheck archivelog all;

$rman target / catalog

rman>crosscheck archivelog all;


validation failed for archived log
archive log filename=/mesdb10g/archive/1_14_756250986.dbf recid=261527 stamp=756277793
validation failed for archived log
archive log filename=/mesdb10g/archive/1_15_756250986.dbf recid=261528 stamp=756280853
validation failed for archived log
archive log filename=/mesdb10g/archive/1_16_756250986.dbf recid=261529 stamp=756283851
validation failed for archived log
archive log filename=/mesdb10g/archive/1_17_756250986.dbf recid=261530 stamp=756287481
validation failed for archived log
archive log filename=/mesdb10g/archive/1_18_756250986.dbf recid=261531 stamp=756291106
Crosschecked 3135 objects


RMAN>

再備份即ok

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7755871/viewspace-735235/,如需轉載,請註明出處,否則將追究法律責任。

相關文章