Cloning from physical standby

From: David Pintor <>
Date: Mon, 31 Jan 2011 11:22:00 +0000
Message-ID: <>


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.


Received on Mon Jan 31 2011 - 05:22:00 CST

Original text of this message