Cloning from physical standby

  • From: David Pintor <painterman@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 31 Jan 2011 11:22:00 +0000


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.


Other related posts: