V$archive_gap
Check Missing Archive Logs in Oracle Data Guard
Nov 26, 2025 / · 3 min read · Oracle Data Guard Database Administration Standby Database Archive Logs Replication Troubleshooting SQL Query v$archive_gap v$archived_log v$managed_standby ·Check Missing Archive Logs in Oracle Data Guard Standby Database Purpose This SQL query helps database administrators identify missing archive logs on an Oracle Data Guard standby database. When archive logs fail to transfer from the primary to the standby database, it creates gaps that prevent proper synchronization. …
Read More