记录日常工作关于系统运维,虚拟化云计算,数据库,网络安全等各方面问题。
Media Recovery Not Enabled Or Manual Archival Only 0x10000 解决方法  



环境  

         Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
    
    
问题描述
        lgwr的trace文件中,产生了如下错误内容   

  1. *** SERVICE NAME ) 2015-01-08 14:04:38.296
  2. *** SESSION ID 273.1) 2015-01-08 14:04:38.296
  3. Media recovery not enabled or manual archival only 0x10000
  4. Maximum redo generation record size = 156160 bytes
  5. Maximum redo generation change vector size = 150676 bytes
  6. *** 2015-01-08 22:00:27.875
  7. Media recovery not enabled or manual archival only 0x10000
  8. *** 2015-01-09 07:28:25.906
  9. Media recovery not enabled or manual archival only 0x10000
  10. *** 2015-01-09 11:23:06.734
  11. Media recovery not enabled or manual archival only 0x10000
  12. *** 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》 虚拟化云计算,系统运维,安全技术服务.

网站已经关闭评论