V$RECOVERY_LOG definition in Oracle Database 11.2

V$RECOVERY_LOG

select
  THREAD#,                                 -- THREAD# NUMBER
  SEQUENCE#,                               -- SEQUENCE# NUMBER
  TIME,                                    -- TIME DATE
  ARCHIVE_NAME                             -- ARCHIVE_NAME VARCHAR2(513)
from
  GV$RECOVERY_LOG
where
  inst_id = USERENV('Instance')

home | up