V$ARCHIVE_DEST

Shows all archived redo log destinations.

Columns

 
   DEST_ID
   DEST_NAME
   STATUS
   BINDING
   NAME_SPACE
   TARGET
   ARCHIVER
   SCHEDULE
   DESTINATION
   LOG_SEQUENCE
   REOPEN_SECS
   DELAY_MINS
   NET_TIMEOUT
   PROCESS
   REGISTER
   FAIL_DATE
   FAIL_SEQUENCE
   FAIL_BLOCK
   FAILURE_COUNT
   MAX_FAILURE
   ERROR
   ALTERNATE
   DEPENDENCY
   REMOTE_TEMPLATE
   QUOTA_SIZE
   QUOTA_USED
   MOUNTID
   TRANSMIT_MODE
   ASYNC_BLOCKS
   AFFIRM
   TYPE

Example

select dest_id, destination from v$archive_dest

Related:

V$ARCHIVE 
V$ARCHIVED_LOG 
V$ARCHIVE_PROCESSES 
V$BACKUP 
V$BACKUP_ASYNC_IO 
V$BACKUP_CORRUPTION 
V$BACKUP_DATAFILE 
V$BACKUP_DEVICE 
V$BACKUP_PIECE 
V$BACKUP_REDOLOG 
V$BACKUP_SET 
V$DELETED_OBJECT 
V$RECOVERY_FILE_STATUS 
V$RECOVERY_LOG 
V$RECOVERY_PROGRESS 
V$RECOVERY_STATUS 
V$RECOVER_FILE


© Copyright SS64.com 1999-2014
Some rights reserved