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).
