GV$BACKUP
select inst_id, -- INST_ID NUMBER hxfil, -- FILE# NUMBER decode -- STATUS VARCHAR2(18) (hxerr, 0, decode (bitand (fhsta, 1), 0, 'NOT ACTIVE', 'ACTIVE'), 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 (fhbsc), -- CHANGE# NUMBER to_date -- TIME DATE (fhbti, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') from x$kcvfhonl

home |  up  |  mailbox