select
  RECID,                                   -- RECID NUMBER
  STAMP,                                   -- STAMP NUMBER
  SET_STAMP,                               -- SET_STAMP NUMBER
  SET_COUNT,                               -- SET_COUNT NUMBER
  THREAD#,                                 -- THREAD# NUMBER
  SEQUENCE#,                               -- SEQUENCE# NUMBER
  RESETLOGS_CHANGE#,                       -- RESETLOGS_CHANGE# NUMBER
  RESETLOGS_TIME,                          -- RESETLOGS_TIME DATE
  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
  TERMINAL                                 -- TERMINAL VARCHAR2(3)
from
  GV$BACKUP_REDOLOG
where
  inst_id = USERENV('Instance')