Dynamic Performance (V$) Views, 7 of 238

V$ARCHIVE_DEST

V$ARCHIVE_DEST describes, for the current instance, all the archived redo log destinations, their current value, mode, and status.

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
`BINDING`	`VARCHAR2(9)`	Specifies how failure will affect the archival operation: `MANDATORY` - Successful archival is required `OPTIONAL` - Successful archival is not required (depends on `LOG_ARCHIVE_MIN_SUCCEED_DEST`)
`NAME_SPACE`	`VARCHAR2(7)`	Identifies the scope of parameter setting: `SYSTEM` - System definition `SESSION` - Session definition
`TARGET`	`VARCHAR2(7)`	Specifies whether the archive destination is local or remote to the primary database: `PRIMARY` - local `STANDBY` - remote
`ARCHIVER`	`VARCHAR2(10)`	Identifies the archiver process relative to the database where the query is issued: `ARC``n` `FOREGROUND` `LGWR` `RFS`
`SCHEDULE`	`VARCHAR2(8)`	Indicates whether the archival of this destination is `INACTIVE`, `PENDING`, `ACTIVE`, or `LATENT`
`DESTINATION`	`VARCHAR2(256)`	Specifies the location where the archived redo logs are to be archived
`LOG_SEQUENCE`	`NUMBER`	Identifies the sequence number of the last archived redo log to be archived
`REOPEN_SECS`	`NUMBER`	Identifies the retry time (in seconds) after error
`DELAY_MINS`	`NUMBER`	Identifies the delay interval (in minutes) before the archived redo log is automatically applied to a standby database
`NET_TIMEOUT`	`NUMBER`	Number of seconds the log writer process will wait for status from the network server of a network operation issued by the log writer process
`PROCESS`	`VARCHAR2(10)`	Identifies the archiver process relative to the primary database, even if the query is issued on the standby database: `ARC``n` `FOREGROUND` `LGWR`
`REGISTER`	`VARCHAR2(3)`	Indicates whether the archived redo log is registered in the remote destination control file. If the archived redo log is registered, it is available to the managed recovery operation: `YES` `NO`
`FAIL_DATE`	`DATE`	Date and time of last error
`FAIL_SEQUENCE`	`NUMBER`	Sequence number of the archived redo log being archived when the last error occurred
`FAIL_BLOCK`	`NUMBER`	Block number of the archived redo log being archived when the last error occurred
`FAILURE_COUNT`	`NUMBER`	Current number of contiguous archival operation failures that have occurred for the destination
`MAX_FAILURE`	`NUMBER`	Allows you to control the number of times log transport services will attempt to re-establish communication and resume archival operations with a failed destination
`ERROR`	`VARCHAR2(256)`	Displays the error text
`ALTERNATE`	`VARCHAR2(256)`	Alternate destination, if any
`DEPENDENCY`	`VARCHAR2(256)`	Dependent archive destination, if any
`REMOTE_TEMPLATE`	`VARCHAR2(256)`	Specifies the template to be used to derive the location to be recorded
`QUOTA_SIZE`	`NUMBER`	Destination quotas, expressed in bytes
`QUOTA_USED`	`NUMBER`	Size of all the archived redo logs currently residing on the specified destination
`MOUNTID`	`NUMBER`	Instance mount identifier
`TRANSMIT_MODE`	`VARCHAR2(12)`	Specifies network transmission mode: `SYNC=PARALLEL` `SYNC=NOPARALLEL` `ASYNC`
`ASYNC_BLOCKS`	`NUMBER`	Number of blocks specified for the `ASYNC` attribute
`AFFIRM`	`VARCHAR2(3)`	Specifies disk I/O mode
`TYPE`	`VARCHAR2(7)`	Indicates whether the archived log destination definition is `PUBLIC` or `PRIVATE`. Only `PUBLIC` destinations can be modified at runtime using the `ALTER SYSTEM SET` or `ALTER SESSION SET` statements. By default, all archived log destinations are `PUBLIC`.

See Also: