- 03 Dec, 2023
- 0 Comments
- 56 Secs Read
ORA-16855: Transport Lag Has Exceeded Specified Threshold
Problem :
We have observed below error in dgmgrl :
DGMGRL> show database prim
Database – prim
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):
prim
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
prim – Physical standby database
Warning: ORA-16809: multiple warnings detected for the member
Fast-Start Failover: DISABLED
Solution :
1.Check for the delaymin parametr:1 2 | DGMGRL> show database verbose prim DelayMinsDelayMins = ‘0’ |
1 2 3 | DGMGRL> edit database prim set property DelayMins=15;Property “delaymins” updatedDGMGRL> |
1 2 3 4 5 6 7 8 9 10 11 12 | DGMGRL> show database primDatabase – primRole: PHYSICAL STANDBYIntended State: APPLY-ONTransport Lag: 0 seconds (computed 0 seconds ago)Apply Lag: 0 seconds (computed 0 seconds ago)Average Apply Rate: 502.00 KByte/sReal Time Query: ONInstance(s):primDatabase Status:SUCCESS |