Thanks to those (Venkat, Rajendra and Yen-Wee) who replied. Problem has been
resolved.
Solution :
* Has to use CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS
ARCHIVELOG
* I forgot to delete old control files.
Thank you so much.
Regds,
New Bee
-----Original Message-----
From: Choudhary Rajendra (TTL_LKO)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 4:08 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Is it possible to copy one db to another
if the SID is differ
Hi,
You have to recreate the controlfile as "CREATE
CONTROLFILE SET
DATABASE "TEST" RESETLOGS ARCHIVELOG". The new database name
will be TEST .
Pl ensure that the old control files are deleted before
recereating the
controlfile .
Regards
Rajendra
-----Original Message-----
Sent: Wednesday, October 09, 2002 12:43 PM
To: Multiple recipients of list ORACLE-L
different
Hi,
Qn : Is it possible to copy one database to another if the
source database
name is different from the target database name ?
I need to clone Oracle Applications 11I from one machine
(source
instance:PROD) to another (target instance:TEST). I followed
the
instructions on Metalink doc 135792.1 "Cloning Oracle
Applications Release
11I". Everything works fine until I re-create the
controlfile in the target
instance.
In svrmgrl =>
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "TEST" RESETLOGS
ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 500
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE
GROUP 1 (
'/dg3/oracle/testredo/log01a.dbf',
'/dg4/oracle/testredo/log01b.dbf'
) SIZE 10M
....
DATAFILE
'/dg7/oracle/testdata/system01.dbf',
'/dg7/oracle/testdata/system02.dbf',
...
'/dg8/oracle/testdata/ctxd01.dbf',
.................
CHARACTER SET US7ASCII
CREATE CONTROLFILE REUSE DATABASE "TEST" RESETLOGS
ARCHIVELOG
*
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name PROD in file header does not match
given name of
TEST
Any advice ? Thanks. (Please reply to [EMAIL PROTECTED])
Regds,
New Bee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California -- Mailing list and web hosting
services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).
You may
also send the HELP command for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Choudhary Rajendra (TTL_LKO)
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California -- Mailing list and web hosting
services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).
You may
also send the HELP command for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
