V$RECOVER_FILE definition in Oracle Database 11.2
V$RECOVER_FILE

select
  FILE#,                                   -- FILE# NUMBER
  "ONLINE",                                -- ONLINE VARCHAR2(7)
  ONLINE_STATUS,                           -- ONLINE_STATUS VARCHAR2(7)
  ERROR,                                   -- ERROR VARCHAR2(18)
  CHANGE#,                                 -- CHANGE# NUMBER
  TIME                                     -- TIME DATE
from
  GV$RECOVER_FILE
where
  inst_id = USERENV('Instance')
home |  up