oracle 集群检查集群资源状态脚本

oracle 集群检查集群资源状态脚本

#/bin/sh

source   /home/oracle/.bash_profile

gridpath=`ps -ef|grep crsd.bin|grep -v grep|awk '{print $8}'`

${gridpath%/*}/crsctl stat res -t |grep  -v   Resources |grep   -v  ^-- > res.log 

#head -n 6 res.log

while read line

do

        tmp=`echo $line | grep "^ora"`

        exception=`echo $line | grep -E "OFFLINE|UNKNOWN|ONLINE"`

        if [ "X$tmp" != "X" ];then

                title=`echo $line | grep "^ora" | awk '{print $1}'`

        fi

        

        if [ "X$exception" != "X" ];then

                #echo $title : $exception

                echo $title : $exception >> /tmp/tst.txt

        fi

        

done < res.log