V$ARCHIVE_DEST_STATUS displays runtime and configuration information for the archived redo log destinations. The information in this view does not persist across an instance shutdown.
DEST_ID
Identifies the log archive destination parameter (1 to 10)
DEST_NAME
Log archive destination parameter name
STATUS
Current status of the destination:
• VALID – Initialized and available
• INACTIVE – No destination information
• DEFERRED – Manually disabled by the user
• ERROR – Error during open or copy
• DISABLED – Disabled after error
• BAD PARAM – Parameter has errors
• ALTERNATE – Destination is in an alternate state
• FULL – Exceeded quota size for the destination
TYPE
Type of archival destination database:
• LOCAL – Local to primary database
• PHYSICAL – Physical standby
• CROSS-INSTANCE – An instance of the primary
DATABASE_MODE
Current mode of the archival destination database:
• STARTED – Instance started, not mounted
• MOUNTED – Mounted
• MOUNTED-STANDBY – Mounted standby
• OPEN – Open read/write
• OPEN_READ-ONLY – Open read-only
RECOVERY_MODE
Current mode of media recovery at the archival destination database:
• IDLE – Managed recovery is not active
• MANUAL – Manual media recovery active
• MANAGED – Managed recovery is active
• MANAGED REAL TIME APPLY – Log apply services recover redo data from standby redo logs at the same time the logs are being written to, as opposed to recovering redo from archived redo logs when a log switch occurs
PROTECTION_MODE
Indicates whether the database is protected:
• MAXIMUM PROTECTION
• MAXIMUM AVAILABILITY
• RESYNCHRONIZATION
• MAXIMUM PERFORMANCE
• UNPROTECTED
DESTINATION
Specifies the location where the redo data is to be archived
STANDBY_LOGFILE_COUNT
Indicates the total number of standby redo logs created on the standby database
STANDBY_LOGFILE_ACTIVE
Indicates the total number of standby redo logs on the standby database that are active and contain primary database online redo log information
ARCHIVED_THREAD#
Identifies the thread number of the most recent archived redo log received at the destination
ARCHIVED_SEQ#
Identifies the log sequence number of the most recent archived redo log received at the destination
APPLIED_THREAD#
Identifies the thread number of the most recent applied redo log received at the destination
APPLIED_SEQ#
Identifies the log sequence number of the most recent applied redo log received at the destination
ERROR
Displays the error text
SRL
Indicates whether standby redo logfiles are used on the standby database (YES) or not (NO)
DB_UNIQUE_NAME
Specifies the unique database name of the current instance that was defined with the DB_UNIQUE_NAME attribute on the LOG_ARCHIVE_DEST_n parameter
SYNCHRONIZATION_STATUS
Possible values for this column are as follows:
• CHECK CONFIGURATION – This database or destination does not support synchronization.
• CHECK STANDBY REDO LOG – The standby redo log at this destination is configured improperly.
• CHECK NETWORK – One or more instances of this database cannot send redo data to this destination.
• DESTINATION HAS A GAP – This destination is missing redo data needed for synchronization with this database.
• OK – This destination is synchronized with this database.
• NOT AVAILABLE – Synchronization status is not available.
SYNCHRONIZED
Possible values are:
• YES – This destination is synchronized with the primary database.
• NO – The destination is not synchronized with the primary database.
• UNKNOWN – The synchronization status of this destination cannot be determined.
