Dynamic Performance (V$) Views, 7 of 211

V$ARCHIVE_DEST

This view describes, for the current instance, all the archive log destinations, their current value, mode, and status.

Column	Datatype	Description
`DEST_ID`	`NUMBER`	ID (1-5)
`STATUS`	`VARCHAR2(9)`	Status: `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
`BINDING`	`VARCHAR2(9)`	Requirement for success: `MANDATORY`- must succeed `OPTIONAL` - need not succeed (depends on `LOG_ARCHIVE_MIS_SUCCEED_DEST`)
`NAME_SPACE`	`VARCHAR2(7)`	Definition scope: `SYSTEM` - system definition `SESSION` - session definition
`TARGET`	`VARCHAR2(7)`	Target: `PRIMARY`- copy to primary `STANDBY`- copy to standby
`REOPEN_SECS`	`NUMBER`	Retry time in seconds (after error)
`DESTINATION`	`VARCHAR2(256)`	Destination text string (translated primary location or standby service name)
`FAIL_DATE`	`DATE`	Date and time of any last error
`FAIL_SEQUENCE`	`NUMBER`	Any log sequence number at last error
`FAIL_BLOCK`	`NUMBER`	Any block number at last error
`ERROR`	`VARCHAR2(256)`	Text of any last error