Restoring control file required?

From: Nadeem M. Khan <nadeem.m.khan_at_gmail.com>
Date: Fri, 3 Aug 2007 12:02:37 +0530
Message-ID: <2ede0e110708022332q1ca5a14j55c40bed376d00f9@mail.gmail.com>

Greetings.

Got a teeny weeny doubt here.
When is it necessary to restore the controlfile? Ofcourse one scenario is when I have lost all copies of my current control file.

Suppose I lose a datafile, I need to restore it. But do I need to restore the control file as well for recovering? What if a tablespace is dropped?

My conclusion after doing a bit of R&D is that if a datafile is dropped/damaged, the
controlfile need not be restored. But If a tablespace is dropped then then all datafiles and the controlfile need to be restored for (incomplete) recovery.

Any inputs appreciated. Documents/Links even more appreciated.

Regards,
NMK.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 03 2007 - 01:32:37 CDT