Below is Oracle Documentation from Physical Storage Structures
The control file contains the following types of records:
- Circular reuse recordsThese records contain noncritical information that is eligible to be overwritten if needed. When all available record slots are full, the database either expands the control file to make room for a new record or overwrites the oldest record. Examples include records about archived redo log files and RMAN backups.
Question:
How to find out the circular reuse records from view v$controlfile_record_section?