Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-01159 during controlfile recreate ?

RE: ORA-01159 during controlfile recreate ?

From: Mark W. Farnham <>
Date: Wed, 21 Jul 2004 10:53:24 -0400
Message-ID: <>

  1. I think you mean to write "test database" where you write "test instance." I'm not really sure what a test instance would be, but it would not involve copying database files, just constructing an environment to start up an Oracle instance on the database files.
  2. When and how did you perform the rename database command? Did you just set a different database name? Then all the old files are your old database name, but the one file create controlfile added has the new database name (which it then immediately does not like because it is different from the others.)
  3. I've always found database rename simpler to execute using backup control file to trace and editting the text file. You're trying to get create controlfile to create an emergency replacement control file AND rename the database in one step.
  4. I'd investigate what the deal is with the missing file in the original database. Is it just an offline tablespace you don't really need?

Good luck. I hope I didn't misinterpret your evidence given this partial top of my head guess at what is going on.


-----Original Message-----

[]On Behalf Of Prem Khanna J Sent: Wednesday, July 21, 2004 5:00 AM
Subject: ORA-01159 during controlfile recreate ?

hi all,
the env is oracle APPS 11.5.9/ AIX 5.2

while creating new control file, i get:

ORA-01159: file is not from same database as previous files - wrong database id
ORA-01110: data file 400 '/home01/db03/dev03data/sss02x01.dbf'

sequence of steps i did :
1.copy all(and only) DBF files (about 400 files) of instance 01 2.move all these DBF files to a test instance 02   i.e.,overwrite the exiting DBF files of 02 3.backup controlfile of 01 using "alter database backup controlfile" 4.edit it to REUSE the copied DBF files from 01 and SET new   database name create control file with the above edited file and i get the   above mentioned error.

in the alert log of instance 02 i find,

Tablespace 'SSS02X' #392 found in data dictionary, but not in the controlfile. Adding to controlfile. File #400 found in data dictionary but not in controlfile. Creating OFFLINE file 'MISSING00400' in the controlfile. This file can no longer be recovered so it must be dropped.

i face problem only with one file and all others get thro. when is this error likely to happen and how to get rid of this error ? am i missing anything ?

Thanks and Regards,

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.

Archives are at FAQ is at

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.

Archives are at FAQ is at
Received on Wed Jul 21 2004 - 10:25:54 CDT

Original text of this message