Re: Cloning from physical standby
- From: David Pintor <painterman@xxxxxxxxx>
- To: "Sheehan, Jeremy" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>
- Date: Mon, 31 Jan 2011 16:16:55 +0000
Thanks again.
It was straight forward enough. As you asked, these are the steps i
followed:
- Shutdown test db
- Stop applying logs on UPAY:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
- Check that the database is consistent by opening it on read-only mode.
alter database open readonly;
- Put the database back in the way it was.
shutdown immediate;
startup nomount
alter database mount standby database ;
- Copy the files from standby to test environment
- Reactivate the standby:
alter database recover managed standby database disconnect from session;
- Recreate control files in test and open the db...!
And that's it!
Regards,
David
On 31 January 2011 14:17, Sheehan, Jeremy
<JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>wrote:
> Be mindful of anything set to nologging the database as well. We had some
> issues with materialized views set to nologging when we cloned from a
> standby.
>
>
>
> Jeremy
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *David Pintor
> *Sent:* Monday, January 31, 2011 9:07 AM
> *To:* Subodh Deshpande
> *Cc:* oracle-l@xxxxxxxxxxxxx
>
> *Subject:* Re: Cloning from physical standby
>
>
>
> Will do, Sobodh, and thanks to everyone who commented.
>
>
> I think I'm not going to use RMAN cause i'm not really familiar with the
> syntax and need to start this right now, but i reckon it might be easier to
> do!
>
> Cheers,
>
> David
>
>
> On 31 January 2011 14:03, Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
> wrote:
>
> just update when you are completed, I am bit curious...:)..subodh
>
>
>
> On 31 January 2011 16:52, David Pintor <painterman@xxxxxxxxx> 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
>
>
>
> --
> ==============================
> DO NOT FORGET TO SMILE TODAY
> ==============================
>
>
>
Other related posts:
