Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: ORA-01159 during controlfile recreate ?

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

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Thu, 22 Jul 2004 22:09:45 +0800
Message-Id: <6.1.0.6.0.20040722220440.024519e8@pop.singnet.com.sg>

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

  1. Performing an incomplete recovery {which you must do first with the same db_name DEV01}
  2. 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."


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:14:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US