Actually, Velpuri explains precisely why do you need to do that. Backup controlfile does not contain last SCN, so one has to do recovery to bring all datafiles to the same SCN. As there is always a possibility that log files have some other SCNs, they need to be reset and cleaned or those SCNs will end up in database during the next instance recovery (not necessarily media recovery). If you put RMAN into the mixture, be aware that when one does "alter database open resetlogs", he ends up with a new database incarnation which is no longer registered and needs to be synchronized. In other words, you will not be able to perform backups until your database is re-registered. On Mon, 2003-10-06 at 14:49, Govindan K wrote: > Hi Scott > > Answer to Question 1 (answers Question 2, 3 too). > Bkp & Rcvry by Rama Velpuri - Case 8:Recovery with a Bkp control file > <quote> > If you use a backup control file, you need to perform media recovery. > Also, Oracle will force you to use the 'using backup controlfile' > option. > Once recovery is done, you must start up the database with the > RESETLOGS > option, and have to take a complete backup of your database. The > reason > for this is that, Oracle needs to update certain data structures in > the > backup controlfile before opening the database, and this is done > during > RESETLOGS. After the database is open, you should immediately take a > full online or offline backup of the database because you cannot > restore > any of the datafiles from before RESETLOGS and try to rollforward. > </quote> > > The book is arguably one of the BEST written on Oracle Backup and > Recovery ever. > Better get one. > > HTH > GovindanK > <-----Original Message-----> > > > From: scott scott > Sent: 10/6/2003 2:37:24 > AM > To: > [EMAIL PROTECTED] > Subject: Re: Basic > question about > controlfile recovery > > Listers, > > sorry for this basic > questionnare. > > ...was reading the RMAN > B&R docs (9iR2).got > these > doubts and thought of > claryfying it with u > experts. > > Q1.after a controlfile > recovery from backup,is > "open > resetlogs" always > necessary ? > > Q2.is there any > scenario,where "open > resetlogs" is not > necessary after > controlfile recovery ? > > Q3.i have backup ( one > day old ) of all my > datafiles/archivelogs/controlfile.now,when all my > controlfiles are lost > with online redologs > intact, > is complete recovery > possible ? if so, is > "open > resetlogs" reqd. & why > ? > > Please enlighten me. > i'll c! ontinue > RTF(ine)M. > > Regards, > Scott. > > > > > Author: scott scott > INET: > [EMAIL PROTECTED] > > > _______________________________________________________________ > Get Your 10MB account for FREE at http://mail.arabia.com ! > [image]Access MILLIONS of JOBS NOW! -- Mladen Gogala Oracle DBA
Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
