Re[1]: ORA-01159 during controlfile recreate ?

Hi Tom ,Dennis, Mark and all,
thanx for ur input.this is my "create controlfile" script.
i did a "alter database backup controlfile ..." on DEV01
instance,edited it to look like this.
--------------------------------------------------------------
CREATE CONTROLFILE SET DATABASE "DEV03" RESETLOGS NOARCHIVELOG 
    MAXLOGFILES 16 
    MAXLOGMEMBERS 5 
    MAXDATAFILES 512 
    MAXINSTANCES 1 
    MAXLOGHISTORY 7260 
LOGFILE 
  GROUP 1 (
    '/home01/db03/dev03data/log01a.dbf', 
    '/home01/db03/dev03data/log01b.dbf' 
  ) SIZE 10M,
  GROUP 2 (
    '/home01/db03/dev03data/log02a.dbf',  
    '/home01/db03/dev03data/log02b.dbf' 
  ) SIZE 10M 
DATAFILE 
'/home01/db03/dev03data/system01.dbf' REUSE, 
...........
'/home01/db03/dev03data/scs02d01.dbf' REUSE, 
--'/home01/db03/dev03data/scs02x01.bdf' REUSE, 
'/home01/db03/dev03data/distutor00d01.dbf' REUSE, 
'/home01/db03/dev03data/distutor00x01.dbf' REUSE 
CHARACTER SET JA16SJIS;
--------------------------------------------------------------
actually DEV03 already exits and is a test instance.
we overwrite the DBF files of DEV03 with DEV01 -> 
change the DB name/file path in new "create controlfile" script 
-> startup nomount & re-create control file .
we do all this only to copy the data from DEV01 to DEV03.

alter.log of DEV03 says that 
----------------------------------------------------
Tablespace 'SCS02X' #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.
----------------------------------------------------
file# 400 is in all way similar with other 399 files.
WHEN IS SUCH A IN-CONSISTNENCY BETWEEN DATA DICT AND 
CONTROL FILE LIKELY TO OCCUR ?

my manager feels EXP/IMP will be cumbersome ?
any other possible suggestions for this ?
this is oracle apps 11.5.9/oracle 9.2.0.4/AIX5.2 env.

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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: