*** 2011-04-01 08:24:37.656
error 481 detected in background process
ORA-00481: LMON process terminated with error
ksuitm: waiting up to [5] seconds before killing DIAG
2. 处理措施
- 查看RAC状态
[pedbsv02:/oracle/admin/PEDBDB/bdump] crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE pedbsv01
ora....B2.inst application ONLINE OFFLINE pedbsv02
ora.PEDBDB.db application ONLINE ONLINE pedbsv01
ora....01.lsnr application ONLINE ONLINE pedbsv01
ora....v01.gsd application ONLINE ONLINE pedbsv01
ora....v01.ons application ONLINE ONLINE pedbsv01
ora....v01.vip application ONLINE ONLINE pedbsv01
ora....02.lsnr application ONLINE ONLINE pedbsv02
ora....v02.gsd application ONLINE ONLINE pedbsv02
ora....v02.ons application ONLINE ONLINE pedbsv02
ora....v02.vip application ONLINE ONLINE pedbsv02
以上证明Oracle RAC正常,只是Instance 2 down,所以只要startup instance2 即可。
- startup Instance2
- 启动完成后确认状态
[pedbsv02:/oracle/admin/PEDBDB/bdump] crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE pedbsv01
ora....B2.inst application ONLINE ONLINE pedbsv02
ora.PEDBDB.db application ONLINE ONLINE pedbsv01
ora....01.lsnr application ONLINE ONLINE pedbsv01
ora....v01.gsd application ONLINE ONLINE pedbsv01
ora....v01.ons application ONLINE ONLINE pedbsv01
ora....v01.vip application ONLINE ONLINE pedbsv01
ora....02.lsnr application ONLINE ONLINE pedbsv02
ora. ...v02.gsd application ONLINE ONLINE pedbsv02
ora....v02.ons application ONLINE ONLINE pedbsv02
ora....v02.vip application ONLINE ONLINE pedbsv02
3. 错误原因:
等分析。。。
4. 错误影响
- instance 2 上应用自动切换到 instance 1上,造成instance 1 负荷变大,磁盘IO变高。