RE: Re[2]: ORA-01159 during controlfile recreate ?

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 22 Jul 2004 09:43:06 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00A80@EXCHMN3>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Hemant K Chitale Sent: Thursday, July 22, 2004 9:10 AM
To: oracle-l_at_freelists.org
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

Performing an incomplete recovery {which you must do first with the same db_name DEV01}
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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jul 22 2004 - 09:46:11 CDT