v$controlfile_record_section shows the records that are stored in a control file. select type from v$controlfile_record_section order by type ; -- ACM OPERATION -- ARCHIVED LOG -- AUXILIARY DATAFILE COPY -- BACKUP CORRUPTION -- BACKUP DATAFILE -- BACKUP PIECE -- BACKUP REDOLOG -- BACKUP SET -- BACKUP SPFILE -- CKPT PROGRESS -- COPY CORRUPTION -- DATABASE -- DATABASE BLOCK CORRUPTION -- DATABASE INCARNATION -- DATAFILE -- DATAFILE COPY -- DATAFILE HISTORY -- DELETED OBJECT -- FILENAME -- FLASHBACK LOG -- FOREIGN ARCHIVED LOG -- GUARANTEED RESTORE POINT -- INSTANCE SPACE RESERVATION -- LOG HISTORY -- MTTR -- MULTI INSTANCE REDO APPLY -- OFFLINE RANGE -- PDB RECORD -- PDBINC RECORD -- PROXY COPY -- RECOVERY DESTINATION -- REDO LOG -- REDO THREAD -- REMOVABLE RECOVERY FILES -- RESTORE POINT -- RMAN CONFIGURATION -- RMAN STATUS -- STANDBY DATABASE MATRIX -- TABLESPACE -- TABLESPACE KEY HISTORY -- TEMPORARY FILENAME -- THREAD INSTANCE NAME MAPPING