Oracle-L: Is it possible to copy one db to another if the SID is different

From: CHAN Chor Ling Catherine (CSC) <clchan_at_nie.edu.sg>
Date: Tue, 08 Oct 2002 23:13:24 -0800
Message-ID: <F001.004E3F73.20021008231324@fatcity.com>

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 clchan_at_nie.edu.sg)

Regds,
New Bee

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: clchan_at_nie.edu.sg

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: ListGuru_at_fatcity.com (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).

Received on Wed Oct 09 2002 - 02:13:24 CDT