solaris rac 11.1.0.7 实例宕掉重启的问题

makaveli

有一套跑在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 编辑 ]

Maclean Liu(刘相兵

这些简单的信息 不足以 完全定位bug ，建议你上传 压缩后的  /oracle/app/oracle/diag/rdbms/webdb/webdb2/trace/webdb2_diag_28889.trc

makaveli

已上传日志，请ML帮忙诊断下，谢谢。