Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

39

积分

0

好友

5

主题
1#
发表于 2012-8-2 15:58:53 | 查看: 8269| 回复: 2
有一套跑在solaris10上的双节点rac数据库(版本为11.1.0.7),alert里报如下错误后导致两个节点的实例自动重启。
  1. Thu Aug 02 15:37:59 2012
  2. LMON (ospid: 28911) waits for event 'control file sequential read' for 86 secs.
  3. Thu Aug 02 15:38:30 2012
  4. LMON (ospid: 28911) waits for event 'control file sequential read' for 117 secs.
  5. ERROR: LMON is not healthy and has no heartbeat.
  6. ERROR: LMD0 (ospid: 28913) is terminating the instance.
  7. LMD0 (ospid: 28913): terminating the instance due to error 482
  8. Thu Aug 02 15:38:33 2012
  9. System state dump is made for local instance
  10. System State dumped to trace file /oracle/app/oracle/diag/rdbms/webdb/webdb2/trace/webdb2_diag_28889.trc
  11. Thu Aug 02 15:38:41 2012
  12. Termination issued to instance processes. Waiting for the processes to exit
  13. Instance terminated by LMD0, pid = 28913
复制代码
通过查看mos的ORA-29770 LMHB Terminates Instance as LMON Waited for Control File IO or LIBRARY CACHE or ROW CACHE Event for too Long [ID 1197674.1]的文档,发现和里面bug描述的信息基本一致,唯一有区别的就是LMHB这个进程是11gr2才有的,在这套11.1.0.7上为LMD0.
  1. Mon Jan 10 14:23:00 2011
  2. LMON (ospid: 8594) waits for event 'control file sequential read' for 87 secs.
  3. Mon Jan 10 14:23:31 2011
  4. LMON (ospid: 8594) waits for event 'control file sequential read' for 118 secs.
  5. ERROR: LMON is not healthy and has no heartbeat.
  6. ERROR: LMHB (ospid: 8614) is terminating the instance.
复制代码
想请教下ML,在我这套系统上报的错误是否可以匹配文档中bug所描述的信息,确认应用相关补丁即可,谢谢。

[ 本帖最后由 makaveli 于 2012-8-2 16:08 编辑 ]

lmd0_trace.txt

16.26 KB, 下载次数: 1121

2#
发表于 2012-8-3 21:53:20
这些简单的信息 不足以 完全定位bug ,建议你上传 压缩后的  /oracle/app/oracle/diag/rdbms/webdb/webdb2/trace/webdb2_diag_28889.trc

回复 只看该作者 道具 举报

3#
发表于 2012-8-3 23:49:21
已上传日志,请ML帮忙诊断下,谢谢。

webdb2_diag_28889.rar

307.51 KB, 下载次数: 1120

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-26 01:08 , Processed in 0.050564 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569