GV$RECOVER_FILE definition in Oracle Database 11.2
GV$RECOVER_FILE

select
  inst_id,                                 -- INST_ID NUMBER
  hxfil,                                   -- FILE# NUMBER
  decode(                                  -- ONLINE VARCHAR2(7)
    hxons, 0, 'OFFLINE', 'ONLINE'),
  decode(                                  -- ONLINE_STATUS VARCHAR2(7)
    hxons, 0, 'OFFLINE', 'ONLINE'),
  decode(                                  -- ERROR VARCHAR2(18)
    hxerr, 0,'',1,'FILE MISSING', 2,'OFFLINE NORMAL', 3,'NOT VERIFIED', 4,'FILE NOT FOUND',5,'CANNOT OPEN FILE', 6,'CANNOT READ HEADER', 7,'CORRUPT HEADER',8,'WRONG FILE TYPE', 9,'WRONG DATABASE', 10,'WRONG FILE NUMBER',11,'WRONG FILE CREATE', 12,'WRONG FILE CREATE', 16,'DELAYED OPEN','UNKNOWN ERROR'),
  to_number(fhscn),                        -- CHANGE# NUMBER
  to_date(                                 -- TIME DATE
    fhtim,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian') 
from
  x$kcvfhmrr

home |  up