RAC 完整显示 crs_stat 命令中 name 列的脚本

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@rac1 u01]$ sh crs_stat.sh

Name                           Target     State      Host     

------------------------------ ---------- ---------  -------  

ora.rac1.ASM2.asm              ONLINE     ONLINE     rac1     

ora.rac1.LISTENER_RAC1.lsnr    ONLINE     ONLINE     rac1     

ora.rac1.gsd                   ONLINE     ONLINE     rac1     

ora.rac1.ons                   ONLINE     ONLINE     rac1     

ora.rac1.vip                   ONLINE     ONLINE     rac1     

ora.rac2.ASM1.asm              ONLINE     ONLINE     rac2     

ora.rac2.LISTENER_RAC2.lsnr    ONLINE     ONLINE     rac2     

ora.rac2.gsd                   ONLINE     ONLINE     rac2     

ora.rac2.ons                   ONLINE     ONLINE     rac2     

ora.rac2.vip                   ONLINE     ONLINE     rac2