How can we recover control file and how to know information in a control file?

@ : Home > > Interview Room

We can’t recover or restore lost control file, but we can still startup the database using control files created using multiplexing in different locations.
We can query the following command
SQL> alter database backup controlfile to trace;
We find a trace file(.trc) in udump location. We can edit it and find the complete database structure.


Multiplexing can also be done using Following command
SQL> alter database backup controlfile to <Different location/path>.

Alert me