|Dump Level||Dump Contains|
|1||only the file header|
|2||just the file header, the database info record, and checkpoint progress records|
|3||all record types, but just the earliest and latest records for circular reuse record types|
|4||as above, but includes the 4 most recent records for circular reuse record types|
|5+||as above, but the number of circular reuse records included doubles with each level|
For example, the following syntax could be used to get a text dump on the controlfile in the trace file of the current process
showing all the controlfile record types but only the oldest and most recent of the circular reuse records.
oradebug dump controlf 3
alter session set events 'immediate trace name controlf level 3';
© Ixora Pty Ltd. All rights reserved.