重庆思庄Oracle、Redhat认证学习论坛

标题: DG备库同步延迟的处理 [打印本页]

作者: 刘泽宇 时间: 2020-11-29 11:52
标题: DG备库同步延迟的处理
本帖最后由刘泽宇于 2021-1-18 13:50 编辑

测试发现物理备库的同步出现长时间的延迟，在主库上进行了修改后，备库要等待10分钟以上才出现同步检查备库的一些状态：
SQL>select DEST_NAME,STATUS,RECOVERY_MODE from v$archive_dest_status;
DEST__NAME                STATUS    RECOVERY_MODE
---------------------       ---------------- -----------------------
LOG_ARCHIVE_DEST_1    VALID       MANAGED
LOG_ARCHIVE_DEST_2    VALID       IDLE
LOG_ARCHIVE_DEST_3    INACTIVE IDLE
LOG_ARCHIVE_DEST_4    INACTIVE IDLE
LOG_ARCHIVE_DEST_5    INACTIVE IDLE
LOG_ARCHIVE_DEST_6    INACTIVE IDLE
LOG_ARCHIVE_DEST_7    INACTIVE IDLE
LOG_ARCHIVE_DEST_8    INACTIVE IDLE
LOG_ARCHIVE_DEST_9    INACTIVE IDLE
LOG_ARCHIVE_DEST_10 INACTIVE IDLE
LOG_ARCHIVE_DEST_11 INACTIVE IDLE
LOG_ARCHIVE_DEST_12 INACTIVE IDLE
LOG_ARCHIVE_DEST_13 INACTIVE IDLE
LOG_ARCHIVE_DEST_14 INACTIVE IDLE
LOG_ARCHIVE_DEST_15 INACTIVE IDLE
LOG_ARCHIVE_DEST_16 INACTIVE IDLE
LOG_ARCHIVE_DEST 17 INACTIVE IDLE
LOG_ARCHIVE_DEST_18 INACTIVE IDLE
LOG_ARCHIVE_DEST 19 INACTIVE IDLE
LOG_ARCHIVE_DEST_20 INACTIVE IDLE
LOG_ARCHIVE_DEST_21 INACTIVE IDLE
LOG_ARCHIVE_DEST_22 INACTIVE IDLE
LOG_ARCHIVE_DEST_23 INACTIVE IDLE
LOG_ARCHIVE_DEST_24 INACTIVE IDLE
LOG_ARCHIVE_DEST_25 INACTIVE IDLE
LOG_ARCHIVE_DEST_26 INACTIVE IDLE
LOG_ARCHIVE_DEST_27 INACTIVE IDLE
LOG_ARCHIVE_DEST_28 INACTIVE rDLE
LOG_ARCHIVE_DEST_29 INACTIVE IDLE
LOG_ARCHIVE_DEST_30 INACTIVE IDLE
LOG_ARCHIVE_DEST_31 INACTIVE IDLE
STANDBY_ARCHIVE_DEST VALID    IDLE

32  rows selected.

SQL>select process,status from v$managed_standby;
PROCESS       STATUS
-----------------  ------------
ARCH CLOSING
ARCH  CONNECTED
ARCH  CLOSING
ARCH  CLOSING
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
MRPO  WAIT_FOR_LOG

13 rows selected.

发现状态为：WAIT_FOR_LOG，不是实时应用
先取消当前同步，重新开启实时应用：
alter database recover managed standby database cancel;
alter database recover managed standby database using current logfile disconnect from session;
再检查状态：
MRPO  APPLYING_LOG
此时同步为实时了

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)