V$ARCHIVE_DEST_STATUS definition in Oracle Database 11.2
V$ARCHIVE_DEST_STATUS

select
  DEST_ID,                                 -- DEST_ID NUMBER
  DEST_NAME,                               -- DEST_NAME VARCHAR2(256)
  STATUS,                                  -- STATUS VARCHAR2(9)
  TYPE,                                    -- TYPE VARCHAR2(14)
  DATABASE_MODE,                           -- DATABASE_MODE VARCHAR2(15)
  RECOVERY_MODE,                           -- RECOVERY_MODE VARCHAR2(23)
  PROTECTION_MODE,                         -- PROTECTION_MODE VARCHAR2(20)
  DESTINATION,                             -- DESTINATION VARCHAR2(256)
  STANDBY_LOGFILE_COUNT,                   -- STANDBY_LOGFILE_COUNT NUMBER
  STANDBY_LOGFILE_ACTIVE,                  -- STANDBY_LOGFILE_ACTIVE NUMBER
  ARCHIVED_THREAD#,                        -- ARCHIVED_THREAD# NUMBER
  ARCHIVED_SEQ#,                           -- ARCHIVED_SEQ# NUMBER
  APPLIED_THREAD#,                         -- APPLIED_THREAD# NUMBER
  APPLIED_SEQ#,                            -- APPLIED_SEQ# NUMBER
  ERROR,                                   -- ERROR VARCHAR2(256)
  SRL,                                     -- SRL VARCHAR2(3)
  DB_UNIQUE_NAME,                          -- DB_UNIQUE_NAME VARCHAR2(30)
  SYNCHRONIZATION_STATUS,                  -- SYNCHRONIZATION_STATUS VARCHAR2(22)
  SYNCHRONIZED,                            -- SYNCHRONIZED VARCHAR2(3)
  GAP_STATUS                               -- GAP_STATUS VARCHAR2(24)
from
  GV$ARCHIVE_DEST_STATUS
where
  inst_id = USERENV('Instance')

home |  up