Dynamic Performance (V$) Views, 8 of 237

V$ARCHIVE_DEST_STATUS

V$ARCHIVE_DEST_STATUS displays runtime and configuration information for the archived redo log destinations.

Column	Datatype	Description
`DEST_ID`	`NUMBER`	Identifies the log archive destination parameter (1 to 10)
`DEST_NAME`	`VARCHAR2(256)`	???
`STATUS`	`VARCHAR2(9)`	Identifies the 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`	`VARCHAR2(14)`	Identifies the type of archival destination database: `LOCAL` - Local to primary database `PHYSICAL` - Physical standby `CROSS-INSTANCE` - An instance of the primary
`DATABASE_MODE`	`VARCHAR2(15)`	Identifies the 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`	`VARCHAR2(7)`	Identifies the 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
`PROTECTION_MODE`	`VARCHAR2(20)`	Indicates whether the database is protected: `MAXIMUM PROTECTION` `MAXIMUM AVAILABILITY` `RESYNCHRONIZATION` `MAXIMUM PERFORMANCE` `UNPROTECTED`
`DESTINATION`	`VARCHAR2(256)`	Specifies the location where the archived redo logs are to be archived
`STANDBY_LOGFILE_COUNT`	`NUMBER`	Indicates the total number of standby redo logs created on the standby database
`STANDBY_LOGFILE_ACTIVE`	`NUMBER`	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#`	`NUMBER`	Identifies the thread number of the most recent archived redo log received at the destination
`ARCHIVED_SEQ#`	`NUMBER`	Identifies the log sequence number of the most recent archived redo log received at the destination
`APPLIED_THREAD#`	`NUMBER`	Identifies the thread number of the most recent applied redo log received at the destination
`APPLIED_SEQ#`	`NUMBER`	Identifies the log sequence number of the most recent applied redo log received at the destination
`ERROR`	`VARCHAR2(256)`	Displays the error text
`SRL`	`VARCHAR2(3)`	Indicates the use of standby redo logfiles on the standby database (`YES`) or (`NO`)