Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!news.moat.net!border1.nntp.sjc.giganews.com!border2.nntp.sjc.giganews.com!nntp.giganews.com!news1.optus.net.au!optus!newsfeeder.syd.optusnet.com.au!news.optusnet.com.au!not-for-mail Reply-To: "Noons" From: "Noons" Newsgroups: comp.databases.oracle.server References: <1b4c4d5d.0403021044.3e0f6217@posting.google.com> Subject: Re: Oracle Recovery Date: Wed, 3 Mar 2004 18:08:22 +1100 Organization: Noneovyabuzness MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Lines: 22 Message-ID: <404584a7$0$3956$afc38c87@news.optusnet.com.au> NNTP-Posting-Host: 211.30.91.186 X-Trace: 1078297767 3956 211.30.91.186 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:256172 "Jeff" wrote in message news:1b4c4d5d.0403021044.3e0f6217@posting.google.com... > Hi. > > Can I roll forward logs accross a previous recovery. The previous > recovery initiated was not what I needed and I need to go back > further, restore the data files, and then roll forward the logs > accross the previous recovery. Thx. You can IF you can restore the control files as well to prior the initiated recovery. Rule number 1 of ANY oracle recovery: back up the control files as they are BEFORE you start the recovery! Corollary to above: only reset the control files to "three multiplexed" AFTER you are fairly certain that you don't need to go back in time. -- Cheers Nuno Souto wizofoz2k@yahoo.com.au.nospam