oracle 11gR2 RAC crsctl 命令的增强

安装完11gR2 rac后,在11gR2版本中用crsctl status resource -t 命令可以很详细的看到各个资源组状态
[grid@p520:/grid/app/grid]$crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
ONLINE ONLINE p520
ONLINE ONLINE p650
ora.DGDATA1.dg
ONLINE ONLINE p520
ONLINE ONLINE p650
ora.DGRECOVER.dg
ONLINE ONLINE p520
ONLINE ONLINE p650
ora.DGSYSTEM.dg
ONLINE ONLINE p520
ONLINE ONLINE p650
ora.LISTENER.lsnr
ONLINE ONLINE p520
ONLINE ONLINE p650
ora.asm
ONLINE ONLINE p520 Started
ONLINE ONLINE p650 Started
ora.eons
ONLINE ONLINE p520
ONLINE ONLINE p650
ora.gsd
OFFLINE OFFLINE p520
OFFLINE OFFLINE p650
ora.net1.network
ONLINE ONLINE p520
ONLINE ONLINE p650
ora.ons
ONLINE ONLINE p520
ONLINE ONLINE p650
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE p650
ora.oc4j
1 ONLINE ONLINE p650
ora.orcl.db
1 ONLINE ONLINE p520 Open
2 ONLINE ONLINE p650 Open
ora.p520.vip
1 ONLINE ONLINE p520
ora.p650.vip
1 ONLINE ONLINE p650
ora.scan1.vip
1 ONLINE ONLINE p650
可以仔细看 STATE_DETAILS 一栏 如果数据库节点2 实例关闭的话,会显示实例关闭
ora.orcl.db
1 ONLINE ONLINE p520 Open
2 ONLINE OFFLINE Instance Shutdown
如果vip发生漂移的话,会显示failed over
ora.p650.vip
1 ONLINE INTERMEDIATE p520 FAILED OVER
从上面我们命令我们可以很详细的看到各个资源组的状态,数据库实例处于什么状态,vip是否发生漂移等