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