RMAN-06059: expected archived log not found,ORA-19625

做rman备份的时候遇到的：

Starting backup at 10-SEP-14
current log archived
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/10/2014 10:09:49
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /u01/archivelog/1_261_850498610.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

------------------------------------------------------------------------------------------------------------------------------------------------------------------
出现RMAN-06059，ORA-19625此种情况是因为归档日志并非是通过rman删除的,但rman备份的时候仍然需要,备份无法进行下去,  
 执行change archivelog all crosscheck或者crosscheck archivelog all ;检查归档日志命令 

RMAN> crosscheck archivelog all;


allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
validation failed for archived log
archived log file name=/u01/archivelog/1_261_850498610.dbf RECID=256 STAMP=857253638
validation failed for archived log
archived log file name=/u01/archivelog/1_262_850498610.dbf RECID=257 STAMP=857253685
validation failed for archived log
archived log file name=/u01/archivelog/1_263_850498610.dbf RECID=258 STAMP=857255699
validation failed for archived log
archived log file name=/u01/archivelog/1_264_850498610.dbf RECID=259 STAMP=857287005
validation failed for archived log
archived log file name=/u01/archivelog/1_265_850498610.dbf RECID=260 STAMP=857322045
validation failed for archived log
archived log file name=/u01/archivelog/1_266_850498610.dbf RECID=261 STAMP=857340068
*************
--此处省去若干--
*************
validation succeeded for archived log
archived log file name=/u01/archivelog/1_319_850498610.dbf RECID=314 STAMP=857865668
validation succeeded for archived log
archived log file name=/u01/archivelog/1_320_850498610.dbf RECID=315 STAMP=857884590
validation succeeded for archived log
archived log file name=/u01/archivelog/1_321_850498610.dbf RECID=316 STAMP=857894824
validation succeeded for archived log
archived log file name=/u01/archivelog/1_322_850498610.dbf RECID=317 STAMP=857902188
validation succeeded for archived log
archived log file name=/u01/archivelog/1_323_850498610.dbf RECID=318 STAMP=857902188
Crosschecked 63 objects
-------------------------------------------------------------------------------------------------------------------------------------

发现有很多归档时是无效failed，使用rman命令删除这些过期归档；
RMAN> delete expired archivelog all;

删除完成后，可重新检查一次，然后重新执行备份即可。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29602308/viewspace-1266807/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29602308/viewspace-1266807/