RE: ORA-01159 during controlfile recreate ?

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Wed, 21 Jul 2004 08:01:39 -0400
Message-ID: <DE8A21F8F1D0254EA4A9214D52AB2FEDAD5D00@exchsen0a1ma>

Prem,

My guess is that the rest of your files would become invalid also. Since this is the last file, I think it is the first one being processed and thus found invalid.

Why didn't you copy the control files over also? You can still recreate them, but I'm gussing that Oracle is a little confused. How did you start the database - startup nomount, correct? Can you show us the create controlfile script?

Tom Mercadante
Oracle Certified Professional

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

From: Prem Khanna J [mailto:premj_at_rediffmail.com] Sent: Wednesday, July 21, 2004 5:00 AM
To: oracle-l_at_freelists.org
Subject: 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,

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_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 Wed Jul 21 2004 - 07:00:59 CDT