RMAN-ERROR因找不到过期和丢失的归档日志而备份失败该怎么办，相信很多没有经验的人对此束手无策，为此本文总结了问题出现的原因和解决方法，通过这篇文章希望你能解决这个问题。
oracle RMAN ERROR
oracle采用rman备份，但是备份过程中报错如下：
|
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup plus archivelog command at 05/03/2018 15:30:02 RMAN-06059: expected archived log not found, loss of archived log compromises recoverability ORA-19625: error identifying file /oracle/archlog/cross/1_40137_869580905.dbf ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 |
备份脚本如下：
|
rman target / log=$BACKUPDIR/$DATA/$LOGFILE << EOF run{ allocate channel ch00 type disk maxpiecesize=4096M; allocate channel ch01 type disk maxpiecesize=4096M; backup as compressed backupset full database format '$BACKUPDIR/$DATA/${ORACLE_SID}_level0_%d_%T_%s_%p' plus archivelog format '$BACKUPDIR/$DATA/${ORACLE_SID}_arc_%d_%T_%s_%p' delete all input; backup current controlfile format '$BACKUPDIR/$DATA/${ORACLE_SID}_control_%d_%T_%s_%p'; backup spfile format '$BACKUPDIR/$DATA/${ORACLE_SID}_spfile_%d_%T_%s_%p'; release channel ch00; release channel ch01; } exit; EOF |
问题分析：
通过报错信息：expected archived log not found，而备份脚本采用了plus archivelog，
分析找到问题：因为找不到过期的归档日志而备份失败。
解决方法：
点击(此处)折叠或打开
-
RMAN target /
-
RMAN> CROSSCHECK ARCHIVELOG ALL;
-
MRAN> DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
看完上述内容，你们掌握RMAN-ERROR因找不到过期和丢失的归档日志而备份失败该怎么办的方法了吗？如果还想学到更多技能或想了解更多相关内容，欢迎关注亿速云行业资讯频道，感谢各位的阅读！
原创文章，作者：kepupublish，如若转载，请注明出处：https://blog.ytso.com/203752.html