Re: Restoring control file required?
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: nadeem.m.khan@xxxxxxxxx
- Date: Sun, 5 Aug 2007 21:36:45 +0200
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@xxxxxxxxx> 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.
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
