RE: Copy 11g DB/Instance onto the same server

From: Robertson Lee - lerobe <>
Date: Thu, 18 Mar 2010 09:16:07 -0000
Message-ID: <>

Agreed, I use the duplicate feature on a regular basis  


[] On Behalf Of Frits Hoogland Sent: 17 March 2010 19:42
To: Oracle L
Cc:; Subject: Re: Copy 11g DB/Instance onto the same server  

totally agree with jeremiah: the duplicate feature allows cloning/duplication with very little manual intervention needed.  


On Mar 17, 2010, at 8:36 PM, Jeremiah Wilton wrote:


Why is copying the database cold faster than RMAN duplicate? In 11g we can duplicate from live DB.  

Jeremiah Wilton

Blue Gecko, Inc. <>  

On Mar 17, 2010, at 12:05 PM, Stefano Cislaghi wrote:

IMHO there's a faster solution. If you're able to shutdown your DB for a while (it dependes about its own size) you may:

  1. shutdown immediate
  2. copy all datafiles and pfile to the new location
  3. startup your original database
  4. Recreate the controlfile for the duplicated one
  5. Startup the new one

2010/3/17 patrick obrien <>

I want to copy my Oracle DB/Instance on my AIX Server to the same server.  

The biggest obstacles I am having at the moment is the putting together the correct listener configuration and creating my CTL file.      

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank You.

Received on Thu Mar 18 2010 - 04:16:07 CDT

Original text of this message