oracle dataguard延迟,Oracle DataGuard延迟应用归档归档日志

1. 查看主库的参数设置：

SQL> show parameter log_archive_dest_2

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_2 string SERVICE=STANDBY LGWR SYNC AFFI

RM VALID_FOR=(ONLINE_LOGFILES,

PRIMARY_ROLE) DB_UNIQUE_NAME=S

TANDBY

2. 在主库设置延时5分钟：

SQL> alter system set log_archive_dest_2=‘SERVICE=STANDBY LGWR SYNC AFFIRM delay=5VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STANDBY‘;

3. 验证是否延时：

主库执行：

SQL> alter system switch logfile;

System altered.

SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)

--------------

28

备库：

Wed Jun 13 19:48:53 2012

Archived Log entry 14 added for thread 1 sequence 28 ID 0x4c9d8928 dest 1:

ARCb: Archive log thread 1 sequence 28 available in 5 minute(s)

Wed Jun 13 19:48:54 2012

Media Recovery Delayed for 5 minute(s) (thread 1 sequence 28) <<<<<<<

Wed Jun 13 19:53:54 2012

Media Recovery Log /u01/oracle/arch1/standby/1_28_757620395.arc<<<<<5分钟后才应用这个归档

Media Recovery Waiting for thread 1 sequence 29 (in transit)

原文：https://www.cnblogs.com/omsql/p/11666900.html