RE: ORA-01159 during controlfile recreate ?
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Jul 2004 08:47:06 -0500
Prem
Offhand I don't see anything you did wrong. My first impression is that
you've made a small mistake somewhere.
- Carefully check the sss02x01.dbf file. Is the timestamp the same as the
other files? If the database existed before, perhaps this file is from the
previous database.
- If you have a create controlfile script that ran successfully before,
carefully compare with that.
- Make sure there isn't a comma after the last file name.
A wild thought. What is MAXDATAFILES in your script?
Dennis Williams
DBA
Lifetouch, Inc.
Does believing you're the last sane man on the planet make you crazy?
Del Spooner in I Robot, played by Will Smith
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Prem Khanna J
Sent: Wednesday, July 21, 2004 4: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:
