Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> ORA-01159 during controlfile recreate ?
hi all,
the env is oracle 9.2.0.4/oracle APPS 11.5.9/ AIX 5.2
while creating new control file, i get:
ORA-01503: CREATE CONTROLFILE FAILED 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
5.now create control file with the above edited file and i get the
above mentioned error.
in the alert log of instance 02 i find,
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,
Prem.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Wed Jul 21 2004 - 04:15:53 CDT
-----------------------------------------------------------------
![]() |
![]() |