ADG同步延迟监控

╰半夏微凉° 2022-09-08 11:59 279阅读 0赞

## 查看延迟脚本 ##

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;

![在这里插入图片描述][a213e825004840e5b691b91c054b5933.png]

#!/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

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_22_color_FFFFFF_t_70_g_se_x_16]

## 定时任务 ##

编写脚本
    crontab -e 
    0-59 * * * * sh stblag.sh >> /home/oracle/bpx.log 2>&1
    
    查看定时任务
    crontab -l

![在这里插入图片描述][8d96ae3aa99f485db2fb63cf17b9b012.png]

## 查看日志 ##

![在这里插入图片描述][bac83c6601404ea1851b073c84fe7249.png]  
![在这里插入图片描述][ab00c4384ecd4011872402c0092744a2.png]

[a213e825004840e5b691b91c054b5933.png]: /images/20220829/d7c14873f5eb40a29b35a3f83140785e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_22_color_FFFFFF_t_70_g_se_x_16]: /images/20220829/779ef8ad8ac2434f9eee34afbe112fbe.png
[8d96ae3aa99f485db2fb63cf17b9b012.png]: /images/20220829/6f63916212204161b4be36e3e09d8f72.png
[bac83c6601404ea1851b073c84fe7249.png]: /images/20220829/d4a289f12ba14bb8855ffcc3252d35c0.png
[ab00c4384ecd4011872402c0092744a2.png]: /images/20220829/81cd52475fb94e03bcd7cc669cc14411.png