select
  RECID,                                   -- RECID NUMBER
  STAMP,                                   -- STAMP NUMBER
  NAME,                                    -- NAME VARCHAR2(513)
  DEST_ID,                                 -- DEST_ID NUMBER
  THREAD#,                                 -- THREAD# NUMBER
  SEQUENCE#,                               -- SEQUENCE# NUMBER
  RESETLOGS_CHANGE#,                       -- RESETLOGS_CHANGE# NUMBER
  RESETLOGS_TIME,                          -- RESETLOGS_TIME DATE
  RESETLOGS_ID,                            -- RESETLOGS_ID NUMBER
  FIRST_CHANGE#,                           -- FIRST_CHANGE# NUMBER
  FIRST_TIME,                              -- FIRST_TIME DATE
  NEXT_CHANGE#,                            -- NEXT_CHANGE# NUMBER
  NEXT_TIME,                               -- NEXT_TIME DATE
  BLOCKS,                                  -- BLOCKS NUMBER
  BLOCK_SIZE,                              -- BLOCK_SIZE NUMBER
  CREATOR,                                 -- CREATOR VARCHAR2(7)
  REGISTRAR,                               -- REGISTRAR VARCHAR2(7)
  STANDBY_DEST,                            -- STANDBY_DEST VARCHAR2(3)
  ARCHIVED,                                -- ARCHIVED VARCHAR2(3)
  APPLIED,                                 -- APPLIED VARCHAR2(9)
  DELETED,                                 -- DELETED VARCHAR2(3)
  STATUS,                                  -- STATUS VARCHAR2(1)
  COMPLETION_TIME,                         -- COMPLETION_TIME DATE
  DICTIONARY_BEGIN,                        -- DICTIONARY_BEGIN VARCHAR2(3)
  DICTIONARY_END,                          -- DICTIONARY_END VARCHAR2(3)
  END_OF_REDO,                             -- END_OF_REDO VARCHAR2(3)
  BACKUP_COUNT,                            -- BACKUP_COUNT NUMBER
  ARCHIVAL_THREAD#,                        -- ARCHIVAL_THREAD# NUMBER
  ACTIVATION#,                             -- ACTIVATION# NUMBER
  IS_RECOVERY_DEST_FILE,                   -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
  COMPRESSED,                              -- COMPRESSED VARCHAR2(3)
  FAL,                                     -- FAL VARCHAR2(3)
  END_OF_REDO_TYPE,                        -- END_OF_REDO_TYPE VARCHAR2(10)
  BACKED_BY_VSS                            -- BACKED_BY_VSS VARCHAR2(3)
from
  GV$ARCHIVED_LOG
where
  inst_id = USERENV('Instance')