GV$CONTROLFILE_RECORD_SECTION

select
inst_id,                 -- INST_ID NUMBER
decode                   -- TYPE VARCHAR2(28)
  (indx, 0, 'DATABASE', 1, 'CKPT PROGRESS', 2, 'REDO THREAD', 3, 'REDO LOG', 4, 'DATAFILE', 5, 'FILENAME', 6, 'TABLESPACE', 7, 'TEMPORARY FILENAME', 8, 'RMAN CONFIGURATION', 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, 'BACKUP SPFILE', 23, 'DATABASE INCARNATION', 24, 'FLASHBACK LOG', 25, 'RECOVERY DESTINATION', 26, 'INSTANCE SPACE RESERVATION', 27, 'REMOVABLE RECOVERY FILES', 28, 'RMAN STATUS', 29, 'THREAD INSTANCE NAME MAPPING', 30, 'MTTR', 31, 'DATAFILE HISTORY', 32, 'STANDBY DATABASE MATRIX', 33, 'GUARANTEED RESTORE POINT', 34, 'RESTORE POINT', '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 
where
indx not in (22)
home |  up  |  mailbox