Re: DB recovery -- Urgent!

From: Fraser McCallum <fmcc_at_NOSPAModbaguru.com>
Date: Sat, 2 Feb 2002 11:34:53 -0000
Message-ID: <49Q68.22484$oK1.174374@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:34:53 CST