| 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: Re[2]: ORA-01159 during controlfile recreate ?
Prem
In my experience you do not want to try the recovery if you are simply trying to recover the database to test from a cold backup. Just skip that step and open the database with resetlogs.
Dennis Williams
DBA
Lifetouch, Inc.
"We all want progress, but if you're on the wrong road, progress means
doing an about-turn and walking back to the right road; in that case,
the man who turns back soonest is the most progressive."
-- C.S. Lewis
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Prem Khanna J
Sent: Wednesday, July 21, 2004 9:15 PM
To: oracle-l_at_freelists.org
Subject: Re[2]: ORA-01159 during controlfile recreate ?
Hi all,
(...continuing with my previous post....)
after re-creating the control file,should i,
RECOVER DATABASE USING BACKUP CONTROLFILE; (i did not do this.i am not sure whether to do this in this case !! )
before
ALTER DATABASE OPEN RESETLOGS;
Thanks and Regards,
Prem.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |