dataguard 多实例状态检查linux

备查询

c.sh
for i in $(ps -ef|grep pmon|grep oracle|grep -v grep|awk -F ‘pmon_’ ‘{print $2}’|grep -v $2)
do
./dg.sh $i
done

dg.sh

export ORACLE_SID=$1
sqlplus -S / as sysdba