| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Basic question about controlfile recovery
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: ORACLE-L_at_fatcity.com
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 continue RTF(ine)M.
Regards,
Scott.
Author: scott scott
INET: orababies_at_yahoo.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Govindan K INET: gkatteri_at_omanmail.com 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: ListGuru_at_fatcity.com (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).Received on Mon Oct 06 2003 - 13:49:25 CDT
 |
 |