Re: DB recovery -- Urgent!

From: Fraser McCallum <fmcc_at_NOSPAModbaguru.com>
Date: Sat, 2 Feb 2002 11:40:16 -0000
Message-ID: <7eQ68.7857$bP3.51995@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

"Fraser McCallum" <fmcc_at_NOSPAModbaguru.com> wrote in message news:49Q68.22484$oK1.174374_at_NewsReader...
> James,
>
> While you have your database mounted you can use "alter database create
> datafile '/directoyinfo/filename.dbf' to recreate your missing datafiles.
> Then perform your recovery. This will only work if you are using your
> current control files not the ones from your old backup. This is why you
> should backup your control files anytime you add a datafile to your
database
> and also why Oracle recommends multiplexing them!
>
> Kind Regards
>
> Fraser McCallum
> MVP Oracle Administration
> www.brainbench.com
>
> "James" <jamesyang_at_163.net> wrote in message
> news:86815f22.0202020022.20c1c67f_at_posting.google.com...
> > The lastest DB backup is 3 days ago. And we have all the needed
> > archive redo logs. The question for me is we added some datafile after
> > the laster DB backup. Can we recover the DB back without a free space
> > issue?
> >
> > Urgent! Please help.
> >
> > Thanks
> > James
>
>
Received on Sat Feb 02 2002 - 05:40:16 CST