V$archive_dest
Oracle Data Guard: V$ARCHIVE_DEST Log Destinations
Jan 5, 2026 / · 4 min read · Oracle Database Data Guard Database Administration Archive Logs Primary Database Monitoring Scripts SQL Queries High Availability v$archive_dest ·Display Log Destinations Options for Oracle Data Guard Primary Database Purpose This SQL script displays detailed information about all configured archive log destinations on an Oracle Data Guard primary database. The query retrieves critical configuration parameters from the V$ARCHIVE_DEST view, allowing database …
Read MoreOracle 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 MoreHow to Disable and Enable Oracle Archive Log Destinations
Nov 27, 2025 / · 3 min read · Oracle Database Data Guard Archive Log DBA Commands Database Administration Standby Database Oracle Backup Database Maintenance v$archive_dest ·How to Disable and Enable Oracle Archive Log Destinations Purpose The Oracle commands for disabling and enabling archive log destinations allow database administrators to control the availability of archive destinations without removing the configuration. These commands are commonly used in Oracle Data Guard …
Read More