Script:优化crs_stat命令的输出

在10g RAC中我们常用crs_stat命令查看CRS资源的状态,但是crs_stat命令的输出并不完整。可以通过以下脚本来优化crs_stat的输出:

--------------------------- Begin Shell Script -------------------------------

#!/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/xpg4/bin/awk    # if not available use /usr/bin/awk

# Table header:echo ""
$AWK \
  'BEGIN {printf "%-45s %-10s %-18s\n", "HA Resource", "Target", "State";
          printf "%-45s %-10s %-18s\n", "-----------", "------", "-----";}'

# Table body:
$ORA_CRS_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;}'

--------------------------- End Shell Script -------------------------------

关注dbDao.com的新浪微博

扫码关注dbDao.com 微信公众号:

Comments

  1. chengwill says:

    The perfect output is shown at following:

    [root@dbu1pub~]# $CRS_HOME/bin/crs_stat -t
    Name Type Target State Host
    ————————————————————
    ora….UB.lsnr application ONLINE ONLINE dbu1pub
    ora….pub.gsd application ONLINE ONLINE dbu1pub
    ora….pub.ons application ONLINE ONLINE dbu1pub
    ora….pub.vip application ONLINE ONLINE dbu1pub
    ora….UB.lsnr application ONLINE ONLINE dbu2pub
    ora….pub.gsd application ONLINE ONLINE dbu2pub
    ora….pub.ons application ONLINE ONLINE dbu2pub
    ora….pub.vip application ONLINE ONLINE dbu2pub
    ora.ssp.db application ONLINE ONLINE dbu1pub
    ora….p1.inst application ONLINE ONLINE dbu1pub
    ora….p2.inst application ONLINE ONLINE dbu2pub

Speak Your Mind

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569