ORA-16853: apply lag has exceeded specified threshold

ORA-16853: apply lag has exceeded specified threshold

Getting following warning in one of the standby server in Dataguard environment:

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

On Oracle ORA ERROR

C:\Oracle>oerr ora 16853
16853,0000, "apply lag has exceeded specified threshold"
// *Cause: The current apply lag exceeded the value specified by the
// ApplyLagThreshold configurable property. It may be caused either by
// a large transport lag or poor performance of apply services on the
// standby database.
// *Action: Check for gaps on the standby database. If no gap is present, tune
// the apply services.

Cause:
Due to apply lag or transport lag. Check Dataguard configurations for parameter ApplyLagThreshold.

DGMGRL> show database verbose orcl;

Solution
ApplyLagThreshold configurable database property generates a warning status for a logical or physical standby when the database’s apply lag exceeds the value specified by the property.
Parameter value defined in Seconds. If you have defined the less value like in our case its 90 we make it to 7500 for approx 2 hours. A value 0 means no warning getting for apply lag.

edit database orcl set property ApplyLagThreshold=7500;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.