Re: Cloning from physical standby

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Tue, 1 Feb 2011 20:06:06 +0100
Message-Id: <23DFBAE5-27CB-49DF-8BB1-292F89B6C6EE_at_gmail.com>



If you are on 11g, I'd suggest a

        Duplicate From Active Database
   from the DG machine to your target.
It does not even use your backup system (tape and tape robots can be so slow). It also does not need the DG apply stopped.

as always, watch out the bugs :-)

best regards,
 Martin

Am 31.01.2011 um 12:22 schrieb David Pintor:

> Hi,
>
> This question might seem a bit obvious for many of you, I'm just trying to figure out which would be the best way to clone a database using the physical standby (so i don't need to touch prod) into a test environment. I was thinking about the following steps:
>
> - Stopping the physical standby
> - Copying the files across to the test environment
> - Restarting the physical standby (so it gets in sync again)
> - Recreating the control file in test and starting up the db.
>
> Would this, roughly, be correct?
>
> Thanks for your help.
>
> David

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 01 2011 - 13:06:06 CST

Original text of this message