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')