RE: Re[2]: ORA-01159 during controlfile recreate ?
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 Jul 2004 09:43:06 -0500
Hemant
That is a good point. I thought Prem had mentioned this was from a cold
backup, but in case I am mistaken, there may be some additional complexity
that I didn't account for.
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Hemant K Chitale
Sent: Thursday, July 22, 2004 9:10 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re[2]: ORA-01159 during controlfile recreate ?
As your original database name was DEV01 and you are renaming it to DEV03,
if this is a Hot Backup, you must first complete recovery of the database
with the
name DEV01. --ie, do NOT run "create controlfile .. SET DEV03" but use
"create controlfile DEV01 resetlogs", then "recover database using backup
controlfile",
"alter database open resetlogs", "alter database backup controlfile to
trace"
and .. now .. use the new controlfile to rename the database with the "SET
DEV03 RESETLOGS"
and, of course, OPEN RESETLOGS.
OPEN RESETLOGS is required when
a) Performing an incomplete recovery {which you must do first with the
same db_name DEV01}
b) Renaming a database {which are you doing to rename the DB to DEV03}
In any case, your CREATE CONTROLFILE statement seems to be missing some
datafiles.
Why not generate it from the original database DEV01 and modify it ? In
fact, your hot
backup could have included a Controlfile Backup also, which you could have
used to regenerate
the CREATE CONTROLFILE statement.
Hemant
At 10:15 AM Thursday, you wrote:
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.
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://web.singnet.com.sg/~hkchital
"A man's reputation is what other people think of him; his character is
what he really is."
-- Miner, Jack
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
