代码改变世界

【转载】告警日志大量kewastUnPackStats(): bad magic 1 (0xffffffff7df9f1ae, 0)

2015-04-28 13:28  AlfredZhao  阅读(395)  评论(0编辑  收藏  举报

原文作者:eygle 链接:http://www.eygle.com/archives/2012/06/kewastunpackstats.html

在告警日志中,可能遇到大量如下提示信息:

kewastUnPackStats(): bad magic 1 (0x000000002BC07DD9, 0)
kewastUnPackStats(): bad magic 1 (0x000000002BC07DD9, 0)
kewastUnPackStats(): bad magic 1 (0x000000002BC07DCF, 0)
kewastUnPackStats(): bad magic 1 (0x000000002BC07DCF, 0)
kewastUnPackStats(): bad magic 1 (0x000000002BC07DDF, 0)
kewastUnPackStats(): bad magic 1 (0x000000002BC07DDF, 0)

这是一个已知BUG导致的,主要是由于升级到11g后的一些变更导致的,以下是MOS的相关文档:
Kewastunpackstats(): Bad Magic 1 (0x1108f7b87, 0) In Alert Logfile After Upgrading to 11.2.0.1 (Doc ID 1227524.1)

文档提示,这是由于ASH信息读取出错导致的:

It is caused by the variable part of the Active Session History rows (the moduile, action program, etc. information) not being stored properly, causing any read-back of this data through views like (G)V$ACTIVE_SESSION_HISTORY to fail.

该BUG不会引起严重问题,在Oracle Database 12c或者11.2.0.2之后的补丁集中被修正。