Hi,experts
Today,i have come to my office,suddenly found 'current log sequence lag archived log sequence which have applied in my Oracle 11.2.0.4.0 Data Guard physical standby'.
My check process as follows,
SYS@standby28> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/oradata/arch
Oldest online log sequence 29424
Next log sequence to archive 0
Current log sequence 29430
SYS@standby28> select max(sequence#) from v$archived_log where applied='YES';
MAX(SEQUENCE#)
--------------
29704
SYS@standby28> set linesize 200
SYS@standby28> set pagesize 200
SYS@standby28> select process,status,thread#,sequence#,block#,blocks,delay_mins from v$managed_standby;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS DELAY_MINS
------------------ ------------------------ ---------- ---------- ---------- ---------- ----------
ARCH CLOSING 1 29703 2580480 720 0
ARCH CONNECTED 0 0 0 0 0
ARCH CLOSING 1 29702 2596864 98 0
ARCH CLOSING 1 29704 22528 1815 0
RFS IDLE 0 0 0 0 0
RFS IDLE 0 0 0 0 0
RFS IDLE 1 29705 1156407 5 0
MRP0 APPLYING_LOG 1 29705 1156406 4194304 0
RFS IDLE 0 0 0 0 0
SYS@standby28> select open_mode from v$database;
OPEN_MODE
----------------------------------------
READ ONLY WITH APPLY
Abnormal part of alert log file as follows,
......
Tue Sep 26 22:36:18 2017
RFS[10]: Selected log 17 for thread 1 sequence 29705 dbid 298590189 branch 910276848
Tue Sep 26 22:36:18 2017
Archived Log entry 20157 added for thread 1 sequence 29704 ID 0x11cc49ed dest 1:
Tue Sep 26 22:36:18 2017
Media Recovery Waiting for thread 1 sequence 29705 (in transit)
Recovery of Online Redo Log: Thread 1 Group 17 Seq 29705 Reading mem 0
Mem# 0: /u01/oradata/standby28/standbyredo02.log
......
Please give me some guiding suggestions,Thanks!
Regards,
Quanwen Zhao