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

  • From: "Robertson Lee - lerobe" <Lee.Robertson@xxxxxxxxxx>
  • To: "Oracle L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 18 Mar 2010 09:16:07 -0000

Agreed, I use the duplicate feature on a regular basis 

 

Lee

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Frits Hoogland
Sent: 17 March 2010 19:42
To: Oracle L
Cc: s.cislaghi@xxxxxxxxx; jwilton@xxxxxxxxxxxxx
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.

 

frits

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





Stefano,

 

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

 

Jeremiah Wilton

Blue Gecko, Inc.

http://www.bluegecko.net <http://www.bluegecko.net/> 

 

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 <po04541@xxxxxxxxx>




I want to copy my Oracle 11.2.0.1.0 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.
****************************************************************************

Other related posts: