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

From: Choudhary Rajendra (TTL_LKO) <rajan_at_telco.co.in>
Date: Wed, 09 Oct 2002 00:08:28 -0800
Message-ID: <F001.004E3FD5.20021009000828@fatcity.com>

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 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Choudhary Rajendra (TTL_LKO)
  INET: rajan_at_telco.co.in

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 - 03:08:28 CDT