ADG同步延迟监控

查看延迟脚本

col value for a20
col name for a24
col DATUM_TIME for a20
col TIME_COMPUTED for a25
SELECT name, value, datum_time, time_computed FROM V$DATAGUARD_STATS;

#!/bin/bash
PATH=$PATH:$HOME/bin
export PATH
ORACLE_SID=orcl2
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG
ORACLE_BASE=/opt/oracle
ORACLE_HOME=$ORACLE_BASE/products/19.3.0
TNS_ADMIN=$ORACLE_HOME/network/admin
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/oracm/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/jdbc
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib:$ORACLE_HOME/oracm/lib:/usr/lib
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib:$ORACLE_HOME/jdbc/lib
SQLPATH=$ORACLE_HOME/sqlplus/admin:$ORACLE_HOME/rdbms/admin:/home/oracle/woqu
export ORACLE_BASE ORACLE_HOME ORA_NLS33 ORACLE_SID PATH LD_LIBRARY_PATH CLASSPATH TNS_ADMIN SQLPATH
NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss";export NLS_DATE_FORMAT
umask 0022

/opt/oracle/products/19.3.0/bin/sqlplus / as sysdba << EOF
@/home/oracle/woqu/stblag.sql
EOF
exit

定时任务

编写脚本
crontab -e 
0-59 * * * * sh stblag.sh >> /home/oracle/bpx.log 2>&1

查看定时任务
crontab -l 

查看日志

cat bpx.log | grep "apply lag" | grep -v 00:00:00
cat bpx.log | grep "transport lag" | grep -v 00:00:00
cat bpx.log | grep "apply finish time" | grep -v 00:00:00