Re: Restoring control file required?

IMHO the only time you need to restore a control file is when you have lost it.

In fact I dont think it is even recommended restoring a controlfile if you have not lost it (and only lost datafiles) because this will force you to perform an incomplete recovery, i.e you might lose data unless you know until which scn you need to recover.

Thanks

--
LSC


On 8/3/07, Nadeem M. Khan <nadeem.m.khan_at_gmail.com> wrote:


>

> 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

>

>

>


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