备份归档日志报错
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';
文章评论