Post date: 22-May-2009 10:10:22
########
11gR2
########
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRDG.dg
ONLINE ONLINE rc1
ora.DATA.dg
ONLINE ONLINE rc1
ora.FRA.dg
ONLINE ONLINE rc1
ora.LISTENER.lsnr
ONLINE ONLINE rc1
ora.asm
ONLINE ONLINE rc1 Started
ora.eons
ONLINE ONLINE rc1
ora.gsd
OFFLINE OFFLINE rc1
ora.net1.network
ONLINE ONLINE rc1
ora.ons
ONLINE ONLINE rc1
ora.registry.acfs
ONLINE ONLINE rc1
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rc1
ora.oc4j
1 OFFLINE OFFLINE
ora.rc1.vip
1 ONLINE ONLINE rc1
ora.rc2.vip
1 ONLINE INTERMEDIATE rc1 FAILED OVER
ora.rdb.db
1 ONLINE ONLINE rc1 Open
2 ONLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE rc1
####
10g
####
Also available via metalink doc id : 259301.1
view cst
---------
#!/usr/bin/ksh
#
# Sample 10g CRS resource status query script
#
# Description:
# - Returns formatted version of crs_stat -t, in tabular
# format, with the complete rsc names and filtering keywords
# - The argument, $RSC_KEY, is optional and if passed to the script, will
# limit the output to HA resources whose names match $RSC_KEY.
# Requirements:
# - $ORA_CRS_HOME should be set in your environment
RSC_KEY=$1
QSTAT=-u
AWK=/usr/bin/awk # if not available use /usr/xpg4/bin/awk
# Table header:echo ""
$AWK \
'BEGIN {printf "%-45s %-10s %-18s\n", "HA Resource", "Target", "State";
printf "%-45s %-10s %-18s\n", "-----------", "------", "-----";}'
# Table body:
$ORACLE_HOME/bin/crs_stat $QSTAT | $AWK \
'BEGIN { FS="="; state = 0; }
$1~/NAME/ && $2~/'$RSC_KEY'/ {appname = $2; state=1};
state == 0 {next;}
$1~/TARGET/ && state == 1 {apptarget = $2; state=2;}
$1~/STATE/ && state == 2 {appstate = $2; state=3;}
state == 3 {printf "%-45s %-10s %-18s\n", appname, apptarget, appstate; state=0;}'
[oracle@rc1.myrac.com] # . setcrs (Load CRS environment)
[oracle@rc1.myrac.com] # cst
HA Resource Target State
----------- ------ -----
ora.rc1.ASM1.asm ONLINE ONLINE on rc1
ora.rc1.LISTENER_DB_RC1.lsnr ONLINE ONLINE on rc1
ora.rc1.LISTENER_RC1.lsnr ONLINE ONLINE on rc1
ora.rc1.gsd ONLINE ONLINE on rc1
ora.rc1.ons ONLINE ONLINE on rc1
ora.rc1.vip ONLINE ONLINE on rc1
ora.rc2.ASM2.asm ONLINE ONLINE on rc2
ora.rc2.LISTENER_DB_RC2.lsnr ONLINE ONLINE on rc2
ora.rc2.LISTENER_RC2.lsnr ONLINE ONLINE on rc2
ora.rc2.gsd ONLINE ONLINE on rc2
ora.rc2.ons ONLINE ONLINE on rc2
ora.rc2.vip ONLINE ONLINE on rc2
ora.rdb.db ONLINE ONLINE on rc1
ora.rdb.rdb1.inst ONLINE ONLINE on rc1
ora.rdb.rdb2.inst ONLINE ONLINE on rc2
ora.rdb.serv1.cs ONLINE ONLINE on rc2
ora.rdb.serv1.rdb1.srv ONLINE ONLINE on rc2