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_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 - 20:14:40 CDT
