I got the below error in one of my standby environment. Error – ORA-16853: apply lag has exceeded specified threshold
DGMGRL> show database dev12cdr
Database - dev12cdr
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 4 minutes 37 seconds (computed 32 seconds ago)
Apply Lag: 4 minutes 37 seconds (computed 32 seconds ago)
Average Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
dev12c
Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
Database Status:
WARNING
DGMGRL>
Cause: This is due the Apply Lag Threshold. Check and modify the dataguard configuration parameter ApplyLagThreshold.
Solution: Modify the ApplyLagThreshold parameter in database configuration
show database verbose dev12cdr;
edit database dev12cdr set property ApplyLagThreshold=3600;