Cloning from physical standby

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



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
Received on Mon Jan 31 2011 - 05:22:00 CST

Original text of this message