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>
<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 !
