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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
