本文主要是介绍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%'
这篇关于RMAN-08137:警告:归档日志未删除,因为备用或上游捕获进程需要它的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!