RMAN-08137:警告:归档日志未删除,因为备用或上游捕获进程需要它
来源:互联网 发布:网络推广软件哪家好 编辑:程序博客网 时间:2024/06/05 01:05
版本: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:警告:归档日志未删除,因为备用或上游捕获进程需要它
- RMAN-08137: 警告: 因为仍需要归档日志, 所以未删除 问题解决
- rman删除归档日志
- rman删除归档日志
- rman删除归档日志
- RMAN手动删除归档日志
- ORACLE Rman删除归档日志
- 用rman 正确地删除归档日志
- RMAN删除过期的归档日志
- oracle 归档日志删除 RMAN基本入门
- RMAN 配置归档日志删除策略
- 利用RMAN进行归档日志的删除
- RMAN 配置归档日志删除策略
- RMAN删除归档日志不释放问题解决
- 使用RMAN删除归档日志和闪回日志
- 归档日志删除需要注意项
- rman清理归档日志
- rman清理归档日志
- mysql主从复制
- JavaWeb学习笔记----Servlet的ServletConfig对象和ServletContext对象的使用
- UI高级--触摸与手势
- 炫酷的canvas
- matlab调用C/C++程序,用mex
- RMAN-08137:警告:归档日志未删除,因为备用或上游捕获进程需要它
- Java-ConcurrentModificationException
- HDU2120Ice_cream's world I(并查集+环)
- CSS选择器简介
- ubuntu下安装qume遇到的问题
- 队列基本操作
- java通过Servlet生成验证码图片
- Brackets Sequence
- APP开发实战126-APP运行速度优化