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

Joe
Sent from the crackberry, so please excuse the typos and terseness.

• Original Message ----- From: kathryn axelrod [kat.axe_at_gmail.com] Sent: 03/17/2010 01:35 PM MST To: s.cislaghi_at_gmail.com Cc: Jeremiah Wilton <jwilton_at_bluegecko.net>; Oracle L <oracle-l_at_freelists.org> Subject: Re: Copy 11g DB/Instance onto the same server

 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_at_gmail.com>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_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


--
http://www.freelists.org/webpage/oracle-l