Database Administration (MOSC)

MOSC Banner

ORA-16853: apply lag has exceeded specified threshold

Hi,

We still get ORA-16853 for logical DR(19.10 version on SunOS 5.11 sparc  host) after changing ApplyLagThreshold to 37000(around 10 hours) with details below:

DGMGRL> show configuration;

Configuration - JKEPCON_DG

 Protection Mode: MaxPerformance

 Members:

 JKEPCON  - Primary database

  JKEPCONSBY - Physical standby database

  JKEPCONLBY - Logical standby database

   Warning: ORA-16853: apply lag has exceeded specified threshold

Fast-Start Failover: Disabled

Configuration Status:

WARNING  (status updated 59 seconds ago)

DGMGRL> show database verbose JKEPCONLBY ApplyLagThreshold;

 ApplyLagThreshold = '37000'


I have also checked the logical DR with more information below for your reference:

On Primary:

SQL> SELECT current_scn FROM v$database;

CURRENT_SCN

-----------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center