Control File Dump
Control files hold the information about the redo logs and datafiles and the critical recovery information like online SCN and offline SCN of datafiles. While opening the database, the control file information is verified against the datafile header information, and the database is opened if both are in sync. Otherwise it will prompt for media recovery.
Control file dumps are usually taken to diagnose recovery-related problems. Part of the control file contents are visible in a few X$ views, such as those starting with X$KCC.
Syntax
Following methods show how to dump the control file information.
Using ALTER SESSION
In the following ALTER SESSION command, control file contents are dumped using level 10.
Using oradebug
In the ...
Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
