Re: Copy 11g DB/Instance onto the same server
- From: kathryn axelrod <kat.axe@xxxxxxxxx>
- To: s.cislaghi@xxxxxxxxx
- Date: Wed, 17 Mar 2010 13:35:10 -0700
On 11g you can actually now do live duplicates (no pre-existing-backup
needed). I think that's what Jeremiah was referring to. (
http://www.colestock.com/blogs/2008/01/new-in-11g-active-database-duplication.html).
I haven't used it yet but it looks nifty.
On Wed, Mar 17, 2010 at 12:42 PM, Stefano Cislaghi <s.cislaghi@xxxxxxxxx>wrote:
> 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:
