Path: news.easynews.com!easynews!novia!novia!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> <49Q68.22484$oK1.174374@NewsReader> Subject: Re: DB recovery -- Urgent! Lines: 45 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: <7eQ68.7857$bP3.51995@NewsReader> Date: Sat, 2 Feb 2002 11:40:16 -0000 NNTP-Posting-Host: 217.34.224.169 X-Trace: NewsReader 1012649987 217.34.224.169 (Sat, 02 Feb 2002 11:39:47 GMT) NNTP-Posting-Date: Sat, 02 Feb 2002 11:39:47 GMT Xref: easynews comp.databases.oracle.server:133671 X-Received-Date: Sat, 02 Feb 2002 04:40:33 MST (news.easynews.com) 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" wrote in message news: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" 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 > >