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