RE: ORA-01159 during controlfile recreate ?
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Jul 2004 10:53:24 -0400
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.
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Prem Khanna J
Sent: Wednesday, July 21, 2004 5:00 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
