Luckily I have never had this situation in production, and what I have read also suggests using the ascii file created from 'BACKUP CONTROLFILE TO TRACE' for recovery. I just had a little time on my hands and decided to give it a try. As I stated, I am by no means an expert in recovery (more like a novice), I was just stating what I observed. Maybe someone else will let us know their opinion.
Thanks for your input. Rob Pegram --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > Is this recovery method valid? The loss of > controlfiles is supposed to be > recovered using the trace file generated from a > previous BACKUP CONTROLFILE > TO TRACE, isn't it? At least according to the > Oracle8 Backup and Recovery > class it is. > > The part that concerns me is that you are recovering > using an ONLINE redo > log (don't know if it was the active one or not). > Could be the paranoid in > me, but that just doesn't seem right. The admission > that "I don't think > this is 100% true for every situation" would seem to > suggest that you agree > that this method shouldn't be used for > backup/recovery on production > databases. > > My $.02. > > Rich Jesse System/Database > Administrator > [EMAIL PROTECTED] Quad/Tech > International, Sussex, WI USA > > -----Original Message----- > Sent: Friday, October 26, 2001 08:30 > To: Multiple recipients of list ORACLE-L > > > Tim, > > > You can not simply cancel a "recover > > database using backup > > controlfile" since Oracle is expecting you perform > a > > complete recovery ( > > since your not using the UNTIL CANCEL/TIME/CHANGE > ) > > and canceling a complete > > recovery leaves the stop SCN in the controlfile at > > infinity... Therefore, > > the recovery is never complete and you will always > > receive the "needs media > > recovery message"... > > I don't think this is 100% true for every situation. > > I am no recovery expert, but I just did this the > other > day, and to verify it, I ran the test again this > morning. > > 1. Shutdown abort > 2. Delete all current controlfiles > 3. Replaced the binary controlfiles from last hot > backup (they were copied as part of the backup > script) > 4. Startup mount > 5. Recover database using backup controlfile > 6. Kept applying logs - only trick was that the > last > log was an online redo log, so I had to type in that > log explicitly. There I received the message Media > Recover Complete. > 7. Alter database open resetlogs. > > Rob Pegram > Oracle Certified DBA > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
