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