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  |  mailbox