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