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

From: Jeremiah Wilton <jwilton_at_bluegecko.net>
Date: Wed, 17 Mar 2010 12:36:22 -0700
Message-Id: <EEC7952F-8DAA-47F2-AC65-8396769A0093_at_bluegecko.net>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 17 2010 - 14:36:22 CDT

Original text of this message