朋友遇到的问题,后来解决了,简单记录下
环境
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
Windows NT Version V5.2 Service Pack 2
问题描述
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 0x10000 (文档 ID 373445.1)
环境
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
Windows NT Version V5.2 Service Pack 2
问题描述
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 0x10000 (文档 ID 373445.1)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28697282/viewspace-1442021/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28697282/viewspace-1442021/