Re: Copy 11g DB/Instance onto the same server
- From: Stefano Cislaghi <s.cislaghi@xxxxxxxxx>
- To: Jeremiah Wilton <jwilton@xxxxxxxxxxxxx>
- Date: Wed, 17 Mar 2010 20:42:32 +0100
Jeremiah,
Yep you're right. Sorry I didn't explain myself correctly... if you've a
backup already configured RMAN is certain the faster solution.
Many times RMAN and backup are not already configured and if your db is not
in production yet you may copy datafiles.
Stefano
--
http://www.stefanocislaghi.eu
2010/3/17 Jeremiah Wilton <jwilton@xxxxxxxxxxxxx>
> 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:
