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 00:23:22 -0800
Message-ID: <F001.004E3FF1.20021009002322@fatcity.com>

Hi Yen-wee,

I tried but still get the following error message :

CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS NOARCHIVELOG *
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name PROD in file header does not match given name of TEST
ORA-01110: data file 6: '/dg8/oracle/testdata/ctxd01.dbf'

Any advice ? Thanks. (Please reply to clchan_at_nie.edu.sg)

Regds,
New Bee

		-----Original Message-----
		From:	yen-wee.tan_at_amd.com [mailto:yen-wee.tan_at_amd.com]
		Sent:	Wednesday, October 09, 2002 3:18 PM
		To:	CHAN Chor Ling Catherine (CSC)
		Subject:	RE: Is it possible to copy one db to another

if the SID is differ ent

Can u try SET instead of REUSE?

		CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS ARCHIVELOG


		....

		....

		....



		-----Original Message-----
		From: CHAN Chor Ling Catherine (CSC)
[mailto:clchan_at_nie.edu.sg]
		Sent: Wednesday, October 09, 2002 3:13 PM
		To: Multiple recipients of list ORACLE-L
		Subject: 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 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: 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 - 03:23:22 CDT