My Oracle Support Banner

Data Guard Do Not Real-time Apply To Standby even though SRL are configured (Doc ID 2864452.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

 Dataguard showing Transport lag/Apply Lag  due to SRL (standby redo logs) not getting used even though they are Configured.

 Since SRL is not used Archivelogs are been sent across to Standby.

 Alert log of Standby shows


Alert log standby

rfs (PID:12499): Possible network disconnect with primary database
2022-04-20T08:00:04.999857+07:00
rfs (PID:12568): Archived Log entry 30 added for B-1090121210.T-2.S-1000 ID 0x8ccd9030 LAD:2
rfs (PID:12568): No SRLs available for T-2    ====================================================>No SRL even though they have been configured and created.
2022-04-20T08:00:05.136739+07:00
rfs (PID:12568): Opened log for T-2.S-1000 dbid 

2022-04-20T08:00:05.551321+07:00
PR00 (PID:12722): Media Recovery Log +<disk group name>/thread_2_seq_1000.128.1102486857  ========================> Using archivelog

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.