Re: Cloning from physical standby
From: Harel Safra <harel.safra_at_gmail.com>
Date: Mon, 31 Jan 2011 13:37:25 +0200
Message-ID: <AANLkTinou0z2MonrmmioPZbFg4255tjXPQKVMyteRRfK_at_mail.gmail.com>
Sounds good.
I'd activate the standby (failover) instead of recreating the controlfile On Jan 31, 2011 1:23 PM, "David Pintor" <painterman_at_gmail.com> 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
Date: Mon, 31 Jan 2011 13:37:25 +0200
Message-ID: <AANLkTinou0z2MonrmmioPZbFg4255tjXPQKVMyteRRfK_at_mail.gmail.com>
Sounds good.
I'd activate the standby (failover) instead of recreating the controlfile On Jan 31, 2011 1:23 PM, "David Pintor" <painterman_at_gmail.com> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 31 2011 - 05:37:25 CST