ORA-01159 during controlfile recreate ? 2004-07-21 - By Prem Khanna J
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 (See ORA-01503.ora-code.com): CREATE CONTROLFILE FAILED
ORA-01159 (See ORA-01159.ora-code.com): file is not from same database as previous files - wrong database id
ORA-01110 (See ORA-01110.ora-code.com): 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,
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---
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,
Prem.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
