RMAN-08137:警告：归档日志未删除，因为备用或上游捕获进程需要它

版本：OracleDatabase 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

 

问题描述：DG环境有问题，主库因空间不够改为noarchivelog模式，主库删除归档日志删除不了

DELETE ARCHIVELOG ALL COMPLETED BEFORE'SYSDATE-7';

RMAN-08137:警告：归档日志未删除，因为备用或上游捕获进程需要它

归档日志文件名：/oradata/archlog/ORCL/archivelog/2016_07_30/o1_mf_1_42614_.dbf

 

解决：修改_deferred_log_dest_is_valid"为FALSE，此参数修改无需重启数据库

 

SOLUTION

As long as the Archive Destination (log_archive_dest_n) is stillset, we consider the Standby Database as still existing and preserve theArchiveLogs on the Primary Database to perform Gap Resolution when the ArchiveDestination is valid again.There are Situations when this is not wanted, eg.the Standby Database was activated or removed but you still keep the ArchiveDestination

because you want to rebuild the Standby Database later again. Inthis Case you can set the hidden Parameter"_deferred_log_dest_is_valid" to FALSE (default TRUE) which willconsider deferred Archive Destinations as completely unavailable and will notpreserve ArchiveLogs for those Destinations any more. It is a dynamic Parameterand can be set this Way:

 

SQL>alter system set "_deferred_log_dest_is_valid" = FALSE scope=both;

 

NOTE: This Parameter has been introduced with Oracle Database11.2.0.x. In earlier Versions you have to unset thelog_archive_dest_n-Parameter pointing to the remote Standby Database to

make the Primary Database considering it as completelyunavailable. There also exists a Patch on Top of 11.1.0.7 for some Platforms toinclude this Parameter in 11.1.0.7, too.

This is Patch Number 8468117.

 

 

其他相关知识：

 

查看隐含参数:

Set linesize 160

col name for a30

col value for a10

col description for a80

select a.ksppinm name,b.ksppstvl value, a.ksppdesc description from x$ksppi a, x$ksppcv b

where a.indx = b.indx anda.ksppinm like '%_deferred_log%'