select
  GROUP#,                                  -- GROUP# NUMBER
  DBID,                                    -- DBID VARCHAR2(40)
  THREAD#,                                 -- THREAD# NUMBER
  SEQUENCE#,                               -- SEQUENCE# NUMBER
  BYTES,                                   -- BYTES NUMBER
  BLOCKSIZE,                               -- BLOCKSIZE NUMBER
  USED,                                    -- USED NUMBER
  ARCHIVED,                                -- ARCHIVED VARCHAR2(3)
  STATUS,                                  -- STATUS VARCHAR2(10)
  FIRST_CHANGE#,                           -- FIRST_CHANGE# NUMBER
  FIRST_TIME,                              -- FIRST_TIME DATE
  NEXT_CHANGE#,                            -- NEXT_CHANGE# NUMBER
  NEXT_TIME,                               -- NEXT_TIME DATE
  LAST_CHANGE#,                            -- LAST_CHANGE# NUMBER
  LAST_TIME                                -- LAST_TIME DATE
from
  GV$STANDBY_LOG
where
  inst_id = USERENV('Instance')