Media Recovery Not Enabled Or Manual Archival Only 0x10000 解决方法 |
发表者:admin分类:数据库2015-08-28 09:14:43 阅读[2552] |
Media Recovery Not Enabled Or Manual Archival Only 0x10000 解决方法
环境
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
问题描述
lgwr的trace文件中,产生了如下错误内容
适用版本
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3 - Release: 10.1 to 10.2
Information in this document applies to any platform.
原因分析
这是由Oracle的bug引起
Bug 4591936 - KCCSGA_UPDATE_CKPT,KCCDEBUG_LEVEL,MEDIA RECOVERY MESSAGES ARE LOGGED AT STARTUP
The problem is fixed in 11.0
解决方法
这是Oracle用于测试的输出信息,这个错误可以忽略。
或者打补丁
参考文档
Trace files generated with: Media Recovery Not Enabled Or Manual Archival Only 0x1000
环境
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
问题描述
lgwr的trace文件中,产生了如下错误内容
- *** SERVICE NAME ) 2015-01-08 14:04:38.296
- *** SESSION ID 273.1) 2015-01-08 14:04:38.296
- Media recovery not enabled or manual archival only 0x10000
- Maximum redo generation record size = 156160 bytes
- Maximum redo generation change vector size = 150676 bytes
- *** 2015-01-08 22:00:27.875
- Media recovery not enabled or manual archival only 0x10000
- *** 2015-01-09 07:28:25.906
- Media recovery not enabled or manual archival only 0x10000
- *** 2015-01-09 11:23:06.734
- Media recovery not enabled or manual archival only 0x10000
- *** 2015-01-09 21:23:04.390
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3 - Release: 10.1 to 10.2
Information in this document applies to any platform.
原因分析
这是由Oracle的bug引起
Bug 4591936 - KCCSGA_UPDATE_CKPT,KCCDEBUG_LEVEL,MEDIA RECOVERY MESSAGES ARE LOGGED AT STARTUP
The problem is fixed in 11.0
解决方法
这是Oracle用于测试的输出信息,这个错误可以忽略。
或者打补丁
Delete these files manually or use some job to clean up diskspace.
To prevent the issue,
1. Apply interim Patch 4591936 on top of 10.2.0.3 according to the readme.
Please note that these one-off patches are not regression tested and hence you are advised to apply the same on a test server before applying it on a production box.
-- OR --
2. Upgrade to 10.2.0.4, 11.1.0.6 or a higher version where the bug fix is included.
参考文档
Trace files generated with: Media Recovery Not Enabled Or Manual Archival Only 0x1000
转载请标明出处【Media Recovery Not Enabled Or Manual Archival Only 0x10000 解决方法 】。
《www.micoder.cc》
虚拟化云计算,系统运维,安全技术服务.
Tags: | [阅读全文...] |
最新评论