Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › 数据库通过crs_stat -查看，服务经常offline ...

0 积分	1 好友	7 主题

发消息

[SQL调优] 数据库通过crs_stat -查看，服务经常offline

1^#

发表于 2013-8-14 17:22:51 | 查看: 3117| 回复: 1

OS：AIX 7.1
DB： 11.2.0.1.0 - 64bit

今天查看数据库的时候，发现数据库的状态如下：


Name          Type          Target State    Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE db1
ora....BASE.dg ora....up.type ONLINE ONLINE db1
ora....ER.lsnr ora....er.type ONLINE OFFLINE
ora....N1.lsnr ora....er.type ONLINE OFFLINE
ora.asm       ora.asm.type ONLINE ONLINE db1
ora....SM1.asm application ONLINE ONLINE db1
ora....B1.lsnr application ONLINE OFFLINE
ora.db1.gsd application ONLINE ONLINE db1
ora.db1.ons application ONLINE OFFLINE
ora.db1.vip ora....t1.type ONLINE OFFLINE
ora....SM2.asm application ONLINE ONLINE db2
ora....B2.lsnr application ONLINE OFFLINE
ora.db2.gsd application ONLINE ONLINE db2
ora.db2.ons application ONLINE OFFLINE
ora.db2.vip ora....t1.type ONLINE OFFLINE
ora.eons    ora.eons.type  ONLINE ONLINE db1
ora.gsd       ora.gsd.type ONLINE ONLINE db1
ora....network ora....rk.type ONLINE OFFLINE
ora.oc4j    ora.oc4j.type  ONLINE ONLINE db1
ora.ons       ora.ons.type ONLINE OFFLINE
ora.orcl.db ora....se.type ONLINE ONLINE db1
ora.scan1.vip  ora....ip.type ONLINE ONLINE db1

用crs_start 启动服务后，服务全部online了，然后决定跟踪crsd.log ，看看当下次某些服务offline的时候，日志的信息。刚才在查看的时候信息如下
crs_stat -t
Name          Type          Target State    Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE db1
ora....BASE.dg ora....up.type ONLINE ONLINE db1
ora....ER.lsnr ora....er.type ONLINE ONLINE db1
ora....N1.lsnr ora....er.type ONLINE ONLINE db1
ora.asm       ora.asm.type ONLINE ONLINE db1
ora....SM1.asm application ONLINE ONLINE db1
ora....B1.lsnr application ONLINE ONLINE db1
ora.db1.gsd application ONLINE ONLINE db1
ora.db1.ons application ONLINE ONLINE db1
ora.db1.vip ora....t1.type ONLINE ONLINE db1
ora....SM2.asm application ONLINE ONLINE db2
ora....B2.lsnr application ONLINE OFFLINE
ora.db2.gsd application ONLINE ONLINE db2
ora.db2.ons application ONLINE OFFLINE
ora.db2.vip ora....t1.type ONLINE ONLINE db1
ora.eons    ora.eons.type  ONLINE ONLINE db1
ora.gsd       ora.gsd.type ONLINE ONLINE db1
ora....network ora....rk.type ONLINE ONLINE db1
ora.oc4j    ora.oc4j.type  ONLINE ONLINE db1
ora.ons       ora.ons.type ONLINE ONLINE db1
ora.orcl.db ora....se.type ONLINE ONLINE db1
ora.scan1.vip  ora....ip.type ONLINE ONLINE db1