Oracle数据库备份失败RMAN-06059: expected archived log not found, lost of archived log compromises recoverability情形
当运行Oracle数据库备份时,备份失败,显示如下错误: The Database script returned an error. Refer to the Database script output section in job logs for more details. 最终错误: 0xe0000340 - 数据库脚本返回一个错误。 详细信息,请参见数据库脚本输出一节。最终出错类别: 资源出错
解释
症状
在作业日志RMAN输出中看到如下信息错误:
RMAN-03002: failure of backup plus archivelog command at <Date> <Time>
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file D:/ORA90/Archive1.ARC
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
原因
上述错误表明,Oracle数据库中有一些预期序列的归档日志丢失
解决方案
在RMAN提示符下运行以下操作:
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;