The Latest Archivelog On Standby Database Keep The Status Of In-Memory (Doc ID 1384371.1)

Last updated on APRIL 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms


We find the latest archivelog on standby is 2561 which have been transferred to standby on 15:01 but it always keep IN-MEMORY, as mentioned below:

However, when we Manual create a latest archivelog on primary database, the status of the archive log 2561 turn yes.



select name,archived,applied,completion_time from v$archived_log where archived <> applied;

+ASM_DATA/bmpstb/archivelog/2_2561_754742428.dbf|YES|IN-MEMORY|2011-12-5 15:01:24



The following is part of alert.log:

Mon Dec 05 10:17:34 2011
Standby controlfile consistent with primary
RFS[5]: Selected log 6 for thread 1 sequence 3449 dbid 500312092 branch 754742428
Mon Dec 05 10:17:34 2011
Archived Log entry 113 added for thread 1 sequence 3448 ID 0x1dd2241c dest 1:
Mon Dec 05 10:17:35 2011
Media Recovery Waiting for thread 1 sequence 3449 (in transit)
Recovery of Online Redo Log: Thread 1 Group 6 Seq 3449 Reading mem 0
Mem# 0: +ASM_DATA/bmpstb/onlinelog/stand16.log
Mon Dec 05 12:33:29 2011
Archived Log entry 114 added for thread 2 sequence 2560 ID 0x1dd2241c dest 1:
Mon Dec 05 12:33:29 2011
Standby controlfile consistent with primary
RFS[6]: Selected log 10 for thread 2 sequence 2561 dbid 500312092 branch 754742428
Mon Dec 05 12:33:31 2011
Media Recovery Waiting for thread 2 sequence 2561 (in transit)
Recovery of Online Redo Log: Thread 2 Group 10 Seq 2561 Reading mem 0
Mem# 0: +ASM_DATA/bmpstb/onlinelog/stand25.log
Mon Dec 05 14:01:08 2011
Archived Log entry 115 added for thread 1 sequence 3449 ID 0x1dd2241c dest 1:
Mon Dec 05 14:01:08 2011
Standby controlfile consistent with primary
RFS[5]: Selected log 5 for thread 1 sequence 3450 dbid 500312092 branch 754742428
Mon Dec 05 14:01:08 2011
Media Recovery Waiting for thread 1 sequence 3450 (in transit)
Recovery of Online Redo Log: Thread 1 Group 5 Seq 3450 Reading mem 0
Mem# 0: +ASM_DATA/bmpstb/onlinelog/stand15.log
Mon Dec 05 15:01:22 2011
Standby controlfile consistent with primary
RFS[6]: Selected log 11 for thread 2 sequence 2562 dbid 500312092 branch 754742428
Mon Dec 05 15:01:22 2011
Media Recovery Waiting for thread 2 sequence 2562 (in transit)
Recovery of Online Redo Log: Thread 2 Group 11 Seq 2562 Reading mem 0
Mem# 0: +ASM_DATA/bmpstb/onlinelog/stand26.log
Mon Dec 05 15:01:24 2011
Archived Log entry 116 added for thread 2 sequence 2561 ID 0x1dd2241c dest 1:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms