Media recovery not enabled or manual archival only 0x10000

今天巡检aix平台上的一个10.2.0.3数据库发现bdump目录下的lgwr进程生成的一个trace文件里报了好多Media recovery not enabled or manual archival only 0x10000 错误,通过查询support发现是oracle的一个bug,相关信息如下:


Trace files generated with: Media Recovery Not Enabled Or Manual Archival Only 0x10000 [ID 373445.1]
 	修改时间 07-JUL-2009     类型 PROBLEM     状态 MODERATED	 
In this Document
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.
Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3
This problem can occur on any platform.
Symptoms

Trace files are getting generated with following errors logged in trace files:

*** 2006-06-13 22:24:29.826 
*** SERVICE NAME:() 2006-06-13 22:24:29.825 
*** SESSION ID:(166.1) 2006-06-13 22:24:29.825 
Maximum redo generation record size = 132096 bytes 
Maximum redo generation change vector size = 98708 bytes 
*** 2006-06-13 22:24:57.649 
Media recovery not enabled or manual archival only 0x10000 
Media recovery not enabled or manual archival only 0x10000 
Media recovery not enabled or manual archival only 0x10000 
Media recovery not enabled or manual archival only 0x10000
Cause

Bug 4591936
Abstract: KCCSGA_UPDATE_CKPT,KCCDEBUG_LEVEL,MEDIA RECOVERY MESSAGES ARE LOGGED AT STARTUP
Fixed In Ver: 11.0


Solution

These messages were added for debugging purpose and can be ignored. 
Delete these files manually or use some job to clean up diskspace.

A one-off patch is available on top of 10.2.0.3 for following platforms 
- HP-UX Itanium
- Solaris 64 Bit

Bug is fixed in 10.2.0.4, 11.1.0.6 and higher versions.

To download:

1. Go to metalink.oracle.com
2. On top left hand side under Quick Find from the drop down list choose "Patch Number" and provide the patch number as 4591936 in the box below it. Click go.
3. In the following page, choose your  platform and download the patch. ( This will list all the plaforms for which patch is available )

Please follow the readme.txt for instruction on how to apply the patch.

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.
References

BUG:4591936 - KCCSGA_UPDATE_CKPT,KCCDEBUG_LEVEL,MEDIA RECOVERY MESSAGES ARE LOGGED AT STARTUP


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值