RMAN-ERROR：因為找不到過期和丟失的歸檔日誌而備份失敗

kngnng發表於2018-05-03
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，
分析找到問題：因為找不到過期的歸檔日誌而備份失敗。

解決方法：

點選(此處)摺疊或開啟

  1. RMAN target /
  2. RMAN> CROSSCHECK ARCHIVELOG ALL;
  3. MRAN> DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26252014/viewspace-2153761/，如需轉載，請註明出處，否則將追究法律責任。

相關文章