Symptoms
客户报告说RMAN备份出错,错误如下:
archived log /backup/archivelog/hmes/1_115593_826386472.dbf not found or out of sync with catalog
trying alternate file for archived log of thread 1 with sequence 115593
released channel: ch1
released channel: ch2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 06/24/2014 01:00:21
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /backup/archivelog/hmes/1_115593_826386472.dbf
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Recovery Manager complete.
Cause
客户由于/backup目录空间快要满了,手动删除了归档日志,之后尝试做0级备份的时候出错。这是由于手动删除了归档日志,但是controlfile中没有记录,需要同步controlfile
Solution
运行如下命令:
RMAN > change archivelog all crosscheck;
上述命令完成后,重新运行0级备份脚本。
--转自