Hi Yen-wee,
I tried but still get the following error message :
CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS NOARCHIVELOG
*
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name PROD in file header does not match given name of
TEST
ORA-01110: data file 6: '/dg8/oracle/testdata/ctxd01.dbf'
Any advice ? Thanks. (Please reply to [EMAIL PROTECTED])
Regds,
New Bee
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 3:18 PM
To: CHAN Chor Ling Catherine (CSC)
Subject: RE: Is it possible to copy one db to another
if the SID is differ ent
Hi
Can u try SET instead of REUSE?
CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS ARCHIVELOG
....
....
....
-----Original Message-----
From: CHAN Chor Ling Catherine (CSC)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L
Subject: Is it possible to copy one db to another if the SID
is
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: 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).
