Re: Cloning from physical standby

  • From: Martin Berger <martin.a.berger@xxxxxxxxx>
  • To: painterman@xxxxxxxxx
  • Date: Tue, 1 Feb 2011 20:06:06 +0100

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


Other related posts: