Apply lag has NULL value in v$dataguard_stats (Doc ID 2323661.1)

Last updated on DECEMBER 05, 2018

Applies to:

Symptoms

Primary and standby databases are in sync but we see error "ORA-16854: apply lag could not be determined" in DGMGRL:

Check if there is lag:

Primary:
SQL> select thread#, max(sequence#) "Last Primary Seq Generated" from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# group by thread# order by 1;

THREAD# Last Primary Seq Generated
---------- --------------------------
1 68982

Standby:
SQL> select thread#, max(sequence#) "Last Standby Seq Received" from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# group by thread# order by 1;

THREAD# Last Standby Seq Received
---------- -------------------------
1 68982

SQL> select thread#, max(sequence#) "Last Standby Seq Applied" from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# and val.applied in ('YES','IN-MEMORY') group by thread# order by 1;

THREAD# Last Standby Seq Applied
---------- ------------------------
1 68982

there is no lag, but DataGuard Broker show error:

DGMGRL> show configuration

Configuration - broker

Protection Mode: MaxPerformance
Members:
chicago - Primary database
boston - Physical standby database
Warning: ORA-16854: apply lag could not be determined

Changes

Cause

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