crs_stat.sh
内容如下:
awk \
'BEGIN {printf "%-30s %-10s %-10s %-10s\n","Name ","Target ","State ","Host ";
printf "%-30s %-10s %-10s %-10s\n","------------------------------","----------", "---------","-------";}'
crs_stat | awk \
'BEGIN { FS="=| ";state = 0;}
$1~/NAME/ {appname = $2; state=1};
state == 0 {next;}
$1~/TARGET/ && state == 1 {apptarget = $2; state=2;}
$1~/STATE/ && state == 2 {appstate = $2; apphost = $4; state=3;}
state == 3 {printf "%-30s %-10s %-10s %-10s\n", appname,apptarget,appstate,apphost; state=0;}'
oracle@racn1[/home/oracle/wangxi]#crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.mgcdb.db application ONLINE ONLINE racn2
ora....vsrv.cs application ONLINE ONLINE racn1
ora....db1.srv application ONLINE ONLINE racn1
ora....lsrv.cs application ONLINE ONLINE racn2
ora....db2.srv application ONLINE ONLINE racn2
ora....b1.inst application ONLINE ONLINE racn1
ora....b2.inst application ONLINE ONLINE racn2
ora....rv01.cs application ONLINE ONLINE racn1
ora....db1.srv application ONLINE ONLINE racn1
ora....tsrv.cs application ONLINE ONLINE racn2
ora....db2.srv application ONLINE ONLINE racn2
ora....N1.lsnr application ONLINE ONLINE racn1
ora.racn1.gsd application ONLINE ONLINE racn1
ora.racn1.ons application ONLINE ONLINE racn1
ora.racn1.vip application ONLINE ONLINE racn1
ora....N2.lsnr application ONLINE ONLINE racn2
ora.racn2.gsd application ONLINE ONLINE racn2
ora.racn2.ons application ONLINE ONLINE racn2
ora.racn2.vip application ONLINE ONLINE racn2
oracle@racn1[/home/oracle/wangxi]#./crs_stat.sh
Name Target State Host
------------------------------ ---------- --------- -------
ora.mgcdb.db ONLINE ONLINE racn2
ora.mgcdb.devsrv.cs ONLINE ONLINE racn1
ora.mgcdb.devsrv.mgcdb1.srv ONLINE ONLINE racn1
ora.mgcdb.htlsrv.cs ONLINE ONLINE racn2
ora.mgcdb.htlsrv.mgcdb2.srv ONLINE ONLINE racn2
ora.mgcdb.mgcdb1.inst ONLINE ONLINE racn1
ora.mgcdb.mgcdb2.inst ONLINE ONLINE racn2
ora.mgcdb.srv01.cs ONLINE ONLINE racn1
ora.mgcdb.srv01.mgcdb1.srv ONLINE ONLINE racn1
ora.mgcdb.tktsrv.cs ONLINE ONLINE racn2
ora.mgcdb.tktsrv.mgcdb2.srv ONLINE ONLINE racn2
ora.racn1.LISTENER_RACN1.lsnr ONLINE ONLINE racn1
ora.racn1.gsd ONLINE ONLINE racn1
ora.racn1.ons ONLINE ONLINE racn1
ora.racn1.vip ONLINE ONLINE racn1
ora.racn2.LISTENER_RACN2.lsnr ONLINE ONLINE racn2
ora.racn2.gsd ONLINE ONLINE racn2
ora.racn2.ons ONLINE ONLINE racn2
ora.racn2.vip ONLINE ONLINE racn2