GV$CONTROLFILE_RECORD_SECTION

select
inst_id,                 -- INST_ID NUMBER
decode                   -- TYPE VARCHAR2(17)
  (indx, 0, 'DATABASE', 1, 'CKPT PROGRESS', 2, 'REDO THREAD', 3, 'REDO LOG', 4, 'DATAFILE', 5, 'FILENAME', 6, 'TABLESPACE', 7, 'RESERVED1', 8, 'RESERVED2', 9, 'LOG HISTORY', 10, 'OFFLINE RANGE', 11, 'ARCHIVED LOG', 12, 'BACKUP SET', 13, 'BACKUP PIECE', 14, 'BACKUP DATAFILE', 15, 'BACKUP REDOLOG', 16, 'DATAFILE COPY', 17, 'BACKUP CORRUPTION', 18, 'COPY CORRUPTION', 19, 'DELETED OBJECT', 20, 'PROXY COPY', 21, 'RESERVED4', 'UNKNOWN'),
rsrsz,                   -- RECORD_SIZE NUMBER
rsnum,                   -- RECORDS_TOTAL NUMBER
rsnus,                   -- RECORDS_USED NUMBER
rsiol,                   -- FIRST_INDEX NUMBER
rsilw,                   -- LAST_INDEX NUMBER
rsrlw                    -- LAST_RECID NUMBER
from
x$kccrs
home |  up  |  mailbox