V$RECOVERY_STATUS definition in Oracle Database 11.2
V$RECOVERY_STATUS

select
  RECOVERY_CHECKPOINT,                     -- RECOVERY_CHECKPOINT DATE
  THREAD,                                  -- THREAD NUMBER
  SEQUENCE_NEEDED,                         -- SEQUENCE_NEEDED NUMBER
  SCN_NEEDED,                              -- SCN_NEEDED VARCHAR2(16)
  TIME_NEEDED,                             -- TIME_NEEDED DATE
  PREVIOUS_LOG_NAME,                       -- PREVIOUS_LOG_NAME VARCHAR2(513)
  PREVIOUS_LOG_STATUS,                     -- PREVIOUS_LOG_STATUS VARCHAR2(13)
  REASON                                   -- REASON VARCHAR2(13)
from
  GV$RECOVERY_STATUS
where
  inst_id = USERENV('Instance')
home |  up