Media recovery not enabled or manual archival only 0x10000

最新推荐文章于 2021-03-03 14:51:36 发布

转载最新推荐文章于 2021-03-03 14:51:36 发布 · 108 阅读

本文记录了在Windows 2003环境下使用Oracle 10g时遇到的非归档模式问题，主要表现为数据库日志中频繁出现Media Recovery Not Enabled或Manual Archival Only的警告信息。该问题经Oracle确认为已知BUG-4591936，不影响数据库正常运行，但可能占用额外磁盘空间。

10202，Media recovery not enabled or manual archival only 0x10000 。BUG-4591936

WINDOWS2003 ORACLE10202

非归档模式，BDUMP目录下出现的TRACE信息：
由LGWR进程的跟踪文件，内容类似：

*** SERVICE NAME

) 2007-02-06 19:33:39.265
*** SESSION ID

77.1) 2007-02-06 19:33:39.265
Maximum redo generation record size = 382976 bytes
Maximum redo generation change vector size = 370276 bytes
*** 2007-02-07 00:00:06.859
Media recovery not enabled or manual archival only 0x10000
...
Media recovery not enabled or manual archival only 0x10000
*** 2007-02-08 09:00:10.656
Media recovery not enabled or manual archival only 0x10000

ORACLE 的解释：

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.

At the time of writing this note , there isn't any one-off patch to fix this issue on 10.2.

You can always raise a new SR requesting for a backport fix on top of 10.2 for your platform.

一个小BUG，至多占点磁盘空间，不会危害数据库。

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/1863/viewspace-1001823/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/1863/viewspace-1001823/