Oracle Views
Oracle Data Guard Log Destinations Monitoring Script
Jan 4, 2026 / · 5 min read · Oracle Data Guard Database Monitoring SQL Scripts High Availability Backup Recovery DBA Scripts Oracle Views v$archive_dest_status v$archive_dest ·Oracle Database Log Destinations Monitoring Script for Data Guard Purpose This Oracle SQL script monitors all log destinations in a Data Guard configuration from the primary database. The query provides real-time information about archive log destinations, their status, operational modes, and standby redo log activity. …
Read MoreOracle Data Guard Standby Redo Log Query: Groups and Members
Jan 1, 2026 / · 10 min read · Oracle Database Data Guard Standby Logs SQL Scripts Database Administration Redo Logs Oracle Views DBA Tools v$standby_log v$logfile ·List All Standby Redo Logs in Oracle Data Guard Purpose A switchover attempted on a busy Friday afternoon reveals the gap: the standby has been synchronized for months, but no standby redo log group was sized to match the primary's 500 MB online redo logs. The configuration worked fine for the archived-log transport …
Read More