V$archived_log
Check Oracle Data Guard Standby Synchronization Status
Jan 3, 2026 / · 5 min read · v$log v$archive_dest_status Oracle Data Guard Standby Database Database Monitoring Oracle Views DBA Scripts Sequence Numbers Replication v$archived_log v$dataguard_stats ·How to Check Physical Standby Database Synchronization Physical standby databases in Oracle Data Guard need regular monitoring to ensure they stay synchronized with the primary database. The most effective way to check synchronization status is by comparing the current sequence number on the primary database with the …
Read MoreCheck 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 MoreRegister Missing Log File in Oracle Data Guard Database
Oct 26, 2025 / · 6 min read · Oracle Database Data Guard Archive Logs Physical Standby Database Recovery DBA Scripts Gap Resolution Log Management V$ARCHIVED_LOG v$managed_standby ·Register Missing Log File in Oracle Database The ALTER DATABASE REGISTER PHYSICAL LOGFILE command is used to manually register archived redo log files in an Oracle Data Guard environment, specifically for physical standby databases. This command becomes essential when automatic log registration fails or when gaps occur …
Read More