Hello,
We have a disaster standby database where archive logs are not received consistently from the primary.
Some sequence numbers are missing in between, and because of this the archive gap is continuously increasing and log apply falls behind.
In some cases we manually transfer logs (BRRESTORE/script), but this is not stable and gaps still occur.
Questions:
- What are the common reasons for missing archive logs on standby?
- How can we automatically detect and resolve archive gaps?
- Should this be fully handled by Data Guard (FAL, real-time apply, standby redo logs), or is an external script needed?
Any best practices or example scripts for gap handling would be appreciated.
Thanks.