使crs_stat -t显示完整的resource name

来源：互联网发布：单片机波形发生器设计编辑：程序博客网时间：2024/05/20 05:07

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

0 0