Sounds good. I'd activate the standby (failover) instead of recreating the controlfile On Jan 31, 2011 1:23 PM, "David Pintor" <painterman@xxxxxxxxx> wrote: > 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