Path: news.easynews.com!easynews!newshub2.home.com!news.home.com!dispose.news.demon.net!demon!btnet-peer0!btnet-peer1!btnet-feed3!btnet!NewsPeer!Fusion!NewsReader.POSTED!not-for-mail Reply-To: "Fraser McCallum" From: "Fraser McCallum" Newsgroups: comp.databases.oracle.server References: <86815f22.0202020022.20c1c67f@posting.google.com> Subject: Re: DB recovery -- Urgent! Lines: 28 Organization: www.BrainBench.com X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 Message-ID: <49Q68.22484$oK1.174374@NewsReader> Date: Sat, 2 Feb 2002 11:34:53 -0000 NNTP-Posting-Host: 217.34.224.169 X-Trace: NewsReader 1012649664 217.34.224.169 (Sat, 02 Feb 2002 11:34:24 GMT) NNTP-Posting-Date: Sat, 02 Feb 2002 11:34:24 GMT Xref: easynews comp.databases.oracle.server:133670 X-Received-Date: Sat, 02 Feb 2002 04:35:11 MST (news.easynews.com) 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" wrote in message news:86815f22.0202020022.20c1c67f@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