GV$BACKUP definition in Oracle 8i / www.oracledba.ru
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