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

From: CHAN Chor Ling Catherine (CSC) <clchan_at_nie.edu.sg>
Date: Wed, 09 Oct 2002 01:11:15 -0800
Message-ID: <F001.004E409C.20021009011115@fatcity.com>

Thanks to those (Venkat, Rajendra and Yen-Wee) who replied. Problem has been resolved.

Solution :
* Has to use CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS ARCHIVELOG
* I forgot to delete old control files.

Thank you so much.

Regds,
New Bee

		-----Original Message-----
		From:	Choudhary Rajendra (TTL_LKO)
[mailto:rajan_at_telco.co.in]
		Sent:	Wednesday, October 09, 2002 4:08 PM
		To:	Multiple recipients of list ORACLE-L
		Subject:	RE: Is it possible to copy one db to another

if the SID is differ

		  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).

-- 
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 - 04:11:15 CDT