处理RMAN-08120: WARNING: archived log not deleted, not yet applied by standby

2014-11-24 18:21:36 · 作者: · 浏览: 0

一段时间后,主库闪回区报警,使用率达到85%以上。


ORA-19815: WARNING: db_recovery_file_dest_size of 32212254720 bytes is 85.14% used


使用rman删除归档日志时,报错:RMAN-08120: WARNING: archived log not deleted, not yet applied by standby


不能删除归档日志。


两种解决办法:


第一种:


RMAN> SHOW ALL;


可看到如下设置:


CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY


或 CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY


这个是11g的新特性,定义归档日志的删除策略。



RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;


RMAN>DELETE ARCHIVELOG ...;


第二种:


RMAN> DELETE FORCE ARCHIVELOG ...;