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 -------------------------------

Posted

in

by

Tags:

Comments

One response to “Script:优化crs_stat命令的输出”

  1. chengwill Avatar
    chengwill

    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

Leave a Reply

Your email address will not be published. Required fields are marked *