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 17:33:27 -0800
Message-ID: <F001.004E5266.20021009173327@fatcity.com>

Hi,

Thanks for those who replied. I've solved the problem. Solution: Use SET database in the CREATE CONTROLFILE command and I forgot to delete the old control files.

Regds,
New Bee

		-----Original Message-----
		From:	Vergara, Michael (TEM) [mailto:mvergara_at_guidant.com]
		Sent:	Thursday, October 10, 2002 5:34 AM
		To:	Multiple recipients of list ORACLE-L
		Subject:	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: mvergara_at_guidant.com

		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 - 20:33:27 CDT