RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

备份归档日志报错

released channel: c8
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 03/26/2023 08:19:15
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file +FRA/orclnew/archivelog/2023_03_17/thread_1_seq_540512.23302.1131682869
ORA-17503: ksfdopn:2 Failed to open file +FRA/orclnew/archivelog/2023_03_17/thread_1_seq_540512.23302.1131682869
ORA-15012: ASM file '+FRA/orclnew/archivelog/2023_03_17/thread_1_seq_540512.23302.1131682869' does not exist

执行：crosscheck archivelog all;

crosscheck archivelog all;

查询归档日志文件

select sequence#,
         name,
         status,
         decode(status,'A','available','D','deleted','U','unavailable','X','expired')
from v$archived_log;

删除3天前的日志文件：

DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3';