做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;
删除完成后,可重新检查一次,然后重新执行备份即可。
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/