#!/usr/bin/bash
source /etc/profile
source ~/.bash_profile
p_seq=`sqlplus -silent '/ as sysdba' << EOSQL
set pagesize 0 feedback off verify off heading off echo off
select max(sequence#) from v\\$managed_standby;
EOSQL`
s_seq=`sqlplus -silent 'sys/ImDbaProd12#@SL as sysdba' <<EOSQL
set pagesize 0 feedback off verify off heading off echo off
select max(sequence#) from v\\$managed_standby;
EOSQL`
diff=`echo $(($p_seq-$s_seq))`
if [ $diff -lt 15 ];then
echo "`date +%F-%T`siebel生产环境主从同步无异常" >>/tmp/adg_status.txt
else
echo -e "siebel生产环境主从不同步,请检查\n主库scn号为$p_seq,备库scn号为$s_seq" | mail -s "siebel数据库主从不同步报警" DBA@immotors.com >/dev/null 2>&1
fi
mo_adg
最新推荐文章于 2023-02-20 11:58:36 发布