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

  • From: Frits Hoogland <frits.hoogland@xxxxxxxxx>
  • To: Oracle L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 17 Mar 2010 20:42:26 +0100

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

Other related posts: