Oracle bad magic 1,案例:Oracle alert日志kewastUnPackStats():bad magic 1 (0x0000000036407DFA, 0)

天萃荷净

Oracle数据库运行过程中alert日志文件大量报错kewastUnPackStats(): bad magic 1 (0x0000000036407DFA, 0)，通过查看官方文档为BUG导致

该错误是出现在win 2008 + 11.2.0.1的数据库中

Sun Jun 03 01:00:05 2012

kewastUnPackStats(): bad magic 1 (0x0000000036407DFA, 0)

kewastUnPackStats(): bad magic 1 (0x0000000036407DFA, 0)

kewastUnPackStats(): bad magic 1 (0x0000000036407DD8, 0)

kewastUnPackStats(): bad magic 1 (0x0000000036407DD8, 0)

kewastUnPackStats(): bad magic 1 (0x0000000036407DD8, 0)

kewastUnPackStats(): bad magic 1 (0x0000000036407DD8, 0)

kewastUnPackStats(): bad magic 1 (0x0000000036407DF0, 0)

kewastUnPackStats(): bad magic 1 (0x0000000036407DF0, 0)

kewastUnPackStats(): bad magic 1 (0x0000000036407DD8, 0)

kewastUnPackStats(): bad magic 1 (0x0000000036407DD8, 0)

Sun Jun 03 02:00:18 2012

kewastUnPackStats(): bad magic 1 (0x0000000035387DD4, 0)

kewastUnPackStats(): bad magic 1 (0x0000000035387DD4, 0)

kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)

kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)

kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)

kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)

kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)

kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)

kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)

kewastUnPackStats(): bad magic 1 (0x0000000035387DDC, 0)

Sun Jun 03 03:00:32 2012

kewastUnPackStats(): bad magic 1 (0x000000001D8F7DD4, 0)

kewastUnPackStats(): bad magic 1 (0x000000001D8F7DD4, 0)

kewastUnPackStats(): bad magic 1 (0x000000001D8F7DDC, 0)

kewastUnPackStats(): bad magic 1 (0x000000001D8F7DDC, 0)

kewastUnPackStats(): bad magic 1 (0x000000001D8F7DDC, 0)

kewastUnPackStats(): bad magic 1 (0x000000001D8F7DDC, 0)

kewastUnPackStats(): bad magic 1 (0x000000001D8F7DD4, 0)

kewastUnPackStats(): bad magic 1 (0x000000001D8F7DD4, 0)

kewastUnPackStats(): bad magic 1 (0x000000001D8F7DD4, 0)

kewastUnPackStats(): bad magic 1 (0x000000001D8F7DD4, 0)

kewastUnPackStats(): bad magic 1 (0x000000001D8F7DDC, 0)

1.分析alert中错误原因:

出现该问题是 Bug:8967729/unpublished bug 8730312

Active Session History中某些数据(the moduile, action program, etc. information)未被正确存储,然后awr程序在整点(默认配置)的时候访问V$ACTIVE_SESSION_HISTORY 视图失败,从而出现了该错误.出现该问题可能导致ash和awr使用异常或不准确

2.问题解决:

1.在Oracle12c release and the 11.2.0.2 and higher patchsets中被修复

2.打上one-off Patch:8730312(one-off补丁没有经过oracle的严格测试,在打该补丁前可能需要进行测试)

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之案例:Oracle alert日志kewastUnPackStats():bad magic 1 (0x0000000036407DFA, 0)