Re: Cloning from physical standby
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-lReceived on Tue Feb 01 2011 - 13:06:06 CST