Media Recovery Not Enabled Or Manual Archival OnlY

Oracle 10.2.0.1 关机引发进程错误

alert:

Shutting down instance (immediate)
License high water mark = 36
Tue May  8 18:16:36 2012
Stopping Job queue slave processes
Tue May  8 18:16:36 2012
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Tue May  8 18:16:47 2012
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Tue May  8 18:16:59 2012
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump

trc:

System name:    Linux
Node name:      localhost.localdomain
Release:        2.6.9-78.ELsmp
Version:        #1 SMP Wed Jul 9 15:39:47 EDT 2008
Machine:        i686
Instance name: sacli2
Redo thread mounted by this instance: 1
Oracle process number: 6
Unix process pid: 5991, image: oracle@localhost.localdomain (LGWR)


*** SERVICE NAME:() 2012-05-08 18:20:54.642
*** SESSION ID:(551.1) 2012-05-08 18:20:54.642
Maximum redo generation record size = 156160 bytes
Maximum redo generation change vector size = 150672 bytes
*** 2012-05-08 22:57:06.017
Media recovery not enabled or manual archival only 0x10000
*** 2012-05-09 06:01:40.125
Media recovery not enabled or manual archival only 0x10000

参考文章： 

原文地址：Media Recovery Not Enabled Or Manual Archival OnlY 作者：lovegigi1999

数据库版本：10.2.0.3.0
在bdump下生成信息sid_lgwr_2036.trc
参考metalink，可以忽略的错误

Trace files generated with: Media Recovery Not Enabled Or Manual Archival Only 0x10000 [ID 373445.1]
		Modified 07-JUL-2009     Type PROBLEM     Status 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