Re: DB recovery -- Urgent!

From: Fraser McCallum <fmcc_at_NOSPAModbaguru.com>
Date: Thu, 7 Feb 2002 12:09:05 -0000
Message-ID: <17u88.39001$oK1.322467@NewsReader>

Yes. For this scenario do the following:

Startup nomount
run the create controlfile command that is in the tracefile made by your backup controlfile command
alter database mount;
alter database create datafile 'filename'; (do this for each missing datafile)
recover database using backup controlfile; (pay special attention to any errors that come up. Fix them and continue this step until you get a recovery complete message)
alter database open resetlogs;

Hopefully it should be all back to normal now. It's also a very good idea to do a full backup at this point.

Kind Regards

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"James" <jamesyang_at_163.net> wrote in message

news:86815f22.0202061819.414a30f_at_posting.google.com...

> "Fraser McCallum" <fmcc_at_NOSPAModbaguru.com> wrote in message
news:<7eQ68.7857$bP3.51995_at_NewsReader>...
> > James,
> >
> > One further note, if you were to recover using a control file you
created
> > with the backup control file command you will need to issue a "recover
> > database using backup controlfile;" rather than just a "recover
database".
> >
> > Kind Regards
> >
> > Fraser McCallum
> > MVP Oracle Administration
> > www.brainbench.com
>
> For "recover database using backup controlfile", does oracle permit ut
> to add new datafile during the recovery?
>
> Thanks
> James
>
Received on Thu Feb 07 2002 - 06:09:05 CST