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).
Re: Is it possible to copy one db to another if the SID is different
Hi, Please use SET in create controlfile statement if you are going to change the DB Name. CREATE CONTROLFILE REUSE SET DATABASE TEST RESETLOGS ARCHIVELOG thnx Venkat ORACLE-L@fatcity. com To: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Is it possible to copy one db to another if the SID is different 10/09/02 12:43 PM Please respond to ORACLE-L 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).
Re: Is it possible to copy one db to another if the SID is different
CHAN Chor Ling Catherine (CSC) wrote: 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 -- Catherine, It IS possible, I have done it a number of times, although long ago. Out the top of my head I think that the problem is with the REUSE after the CREATE CONTROL FILE. It doesn't pertain to the files, creating a control file will not do anything to the data files (you probably feared overwriting them). And afterwards you need an ALTER DATABASE to change the global name. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
RE: Is it possible to copy one db to another if the SID is different
Dear New Bee: We do this all the time, and the problem you're having is the one that I tripped over my first time, too. There is an important word missing from your command. It's not... CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG ...it is ... CREATE CONTROLFILE REUSE SET DATABASE TEST RESETLOGS ARCHIVELOG ^^^ And when you ALTER DATABASE OPEN you'll also need to say RESETLOGS. HTH, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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).