Logical Standby Standby Redo Logs Are Not In Use (Doc ID 1088703.1)

Last updated on APRIL 04, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 and later   [Release: 10.1 and later ]
Information in this document applies to any platform.

Symptoms

In a Data Guard Logical Standby Database Setup, Standby Redologs are not used although they are configured properly on the Standby Database and the Primary Database is using LGWR to transfer archive logs. This causes updates on Primary Database can not been seen on the Logical Standby until a log switch is done on the Primary.

Primary:
log_archive_dest_2 = SERVICE=logstd LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=logstd

Standby:

select * from v$standby_log:
GROUP#     DBID  THREAD#    SEQUENCE#  BYTES USED ARC STATUS
---------- ----- ---------- ---------- ---------- ---------- ---
   FIRST_CHANGE#    FIRST_TIM    LAST_CHANGE#    LAST_TIME
 ---------- ------------- --------- ------------ ---------
8 UNASSIGNED       1         0        209715200 512 NO UNASSIGNED
0 0
9 UNASSIGNED       1         0        209715200 512 NO UNASSIGNED
0 0
10 UNASSIGNED      2         0        209715200 512 NO UNASSIGNED
0 0
11 UNASSIGNED      2         0        209715200 512 NO UNASSIGNED
0 0
12 UNASSIGNED      3         0        209715200 512 NO UNASSIGNED
0 0
13 UNASSIGNED      3         0        209715200 512 NO UNASSIGNED
0 0

alert log of Standby:

Sun Apr 11 22:35:05 2010
RFS[7]: Completed archive primary log 1 thread 1 sequence 157 (logstd1)
Sun Apr 11 22:35:05 2010
RFS[7]: Archived Log: '+FLASH_EXT/logstd/sdby_arc/1_157_714908041.dbf'
..
Sun Apr 11 22:35:05 2010
RFS[7]: Begin archive primary thread 1 sequence 158 (logstd1)
Sun Apr 11 22:35:08 2010
RFS[7]: Completed archive primary log 2 thread 1 sequence 158 (xlodrcdc1)
Sun Apr 11 22:35:08 2010
RFS[7]: Archived Log: '+FLASH_EXT/logstd/sdby_arc/1_158_714908041.dbf'
Committing creation of archivelog '+FLASH_EXT/logstd/sdby_arc/1_158_714908041.dbf'


Changes

New setup

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