GV$DATAFILE_HEADER
select inst_id, -- INST_ID NUMBER hxfil, -- FILE# NUMBER decode -- STATUS VARCHAR2(7) (hxons, 0, 'OFFLINE', 'ONLINE'), decode -- ERROR VARCHAR2(18) (hxerr, 0, NULL, 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', 14, 'WRONG RESETLOGS', 15, 'OLD CONTROLFILE', 'UNKNOWN ERROR'), hxver, -- FORMAT NUMBER decode -- RECOVER VARCHAR2(3) (hxnrcv, 0, 'NO', 1, 'YES', NULL), decode -- FUZZY VARCHAR2(3) (hxifz, 0, 'NO', 1, 'YES', NULL), to_number (fhcrs), -- CREATION_CHANGE# NUMBER to_date -- CREATION_TIME DATE (fhcrt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'), fhtnm, -- TABLESPACE_NAME VARCHAR2(30) fhtsn, -- TS# NUMBER fhrfn, -- RFILE# NUMBER to_number (fhrls), -- RESETLOGS_CHANGE# NUMBER to_date -- RESETLOGS_TIME DATE (fhrlc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'), to_number (fhscn), -- CHECKPOINT_CHANGE# NUMBER to_date -- CHECKPOINT_TIME DATE (fhtim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'), fhcpc, -- CHECKPOINT_COUNT NUMBER fhfsz*fhbsz, -- BYTES NUMBER fhfsz, -- BLOCKS NUMBER hxfnm, -- NAME VARCHAR2(513) decode -- SPACE_HEADER VARCHAR2(40) (hxlmdba, 0, NULL, hxlmdba), decode -- LAST_DEALLOC_SCN VARCHAR2(16) (hxlmld_scn, '0', NULL, hxlmld_scn) from x$kcvfh

home |  up  |  mailbox