PROBLEM:
We have observed below error in dgmgrl :
DGMGRL> show database prdstby
Database - prdstby
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 9 minutes 24 seconds (computed 0 seconds ago)
Apply Lag: 9 minutes 24 seconds (computed 0 seconds ago)
Average Apply Rate: 488.00 KByte/s
Real Time Query: ON
Instance(s):
prdstby
Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold
Database Status:
WARNING
DGMGRL> show configuration
Configuration - dg_config_PRD
Protection Mode: MaxPerformance
Members:
ne - Primary database
prdby - Physical standby database
prdstby - Physical standby database
Warning: ORA-16809: multiple warnings detected for the member
Fast-Start Failover: DISABLED
SOLUTION:
1.Check for the delaymin parametr:
DGMGRL> show database verbose prdstby DelayMins
DelayMins = -0-
2. Change the value to a higher value
DGMGRL> edit database prdstby set property DelayMins=15;
Property -delaymins" updated
DGMGRL>
3. Now check again:
DGMGRL> show database prdstby
Database - prdstby
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 502.00 KByte/s
Real Time Query: ON
Instance(s):
prdstby
Database Status:
SUCCESS
dgmgrlORA- TROUBLESHOOTING