Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.algx.net!dca6-feed2.news.algx.net!allegiance!feed2.news.rcn.net!rcn!newsfeed1.earthlink.net!newsfeed.earthlink.net!stamper.news.pas.earthlink.net!newsread1.prod.itd.earthlink.net.POSTED!not-for-mail Message-ID: <3CAC7068.5C766C04@BACKSIESearthlink.net> From: Sean M X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Recover Help Please - needs more recovery References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 18 Date: Thu, 04 Apr 2002 15:25:17 GMT NNTP-Posting-Host: 206.71.120.1 X-Complaints-To: abuse@earthlink.net X-Trace: newsread1.prod.itd.earthlink.net 1017933917 206.71.120.1 (Thu, 04 Apr 2002 07:25:17 PST) NNTP-Posting-Date: Thu, 04 Apr 2002 07:25:17 PST Organization: EarthLink Inc. -- http://www.EarthLink.net Xref: easynews comp.databases.oracle.server:142036 X-Received-Date: Thu, 04 Apr 2002 08:23:10 MST (news.easynews.com) "Howard J. Rogers" wrote: > > Yup. Easy. Make sure that no data files exist from a time more recent than > the control file. The only time I can think you need a 'using backup > controlfile' is if you are restoring a binary version of the control file, > and if it is from a time before the data files (or the online redo logs, > I'll concede!). Or if you've just recreated your controlfile (typically using the sql generated from an 'alter database backup controlfile to trace' command). A common scenario where this would arise is after cloning a database from a hotbackup. You're renaming the database, so you must recreate the controlfile. You also then need to recover the hotbackup to make it consistent, hence the "using backup controlfile" clause is required. Regards, Sean