[oracle@srac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.FAN.db application ONLINE ONLINE srac1
ora....n1.inst application ONLINE ONLINE srac1
ora....n2.inst application ONLINE ONLINE srac2
ora....SM1.asm application ONLINE ONLINE srac1
ora....C1.lsnr application ONLINE ONLINE srac1
ora.srac1.gsd application ONLINE ONLINE srac1
ora.srac1.ons application ONLINE ONLINE srac1
ora.srac1.vip application ONLINE ONLINE srac1
ora....SM2.asm application ONLINE ONLINE srac2
ora....C2.lsnr application ONLINE ONLINE srac2
ora.srac2.gsd application ONLINE ONLINE srac2
ora.srac2.ons application ONLINE ONLINE srac2
ora.srac2.vip application ONLINE ONLINE srac2
[oracle@srac1 ~]$ sh crs_stat.sh -t
Name Target State Host
------------------------------ ---------- --------- -------
ora.FAN.db ONLINE ONLINE srac1
ora.FAN.fan1.inst ONLINE ONLINE srac1
ora.FAN.fan2.inst ONLINE ONLINE srac2
ora.srac1.ASM1.asm ONLINE ONLINE srac1
ora.srac1.LISTENER_SRAC1.lsnr ONLINE ONLINE srac1
ora.srac1.gsd ONLINE ONLINE srac1
ora.srac1.ons ONLINE ONLINE srac1
ora.srac1.vip ONLINE ONLINE srac1
ora.srac2.ASM2.asm ONLINE ONLINE srac2
ora.srac2.LISTENER_SRAC2.lsnr ONLINE ONLINE srac2
ora.srac2.gsd ONLINE ONLINE srac2
ora.srac2.ons ONLINE ONLINE srac2
ora.srac2.vip ONLINE ONLINE srac2
[oracle@srac1 ~]$ vi crs_stat.sh

awk \
'BEGIN {printf "%-30s %-10s %-10s %-10s\n","Name ","Target ","State ","Host ";
printf "%-30s %-10s %-10s %-10s\n","------------------------------","----------", "---------","-------";}'

$ORA_CRS_HOME/bin/./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;}'

CRS_HOME自己改一下

ITPub博客

一个CRS_STAT脚本

最新文章