hi you have to do a alter database backup controlfile to trace on the source database
change all occurrences PROD in TEST in the created backup controlfile the create controlfile reuse has to be create controlfile SET database "test" oracle note 61590.1 on metalink g.g. kor rdw the netherlands > -----Oorspronkelijk bericht----- > Van: CHAN Chor Ling Catherine (CSC) [SMTP:[EMAIL PROTECTED]] > Verzonden: woensdag 9 oktober 2002 9:13 > Aan: Multiple recipients of list ORACLE-L > Onderwerp: 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: 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).
