Re: Question about building physical standby from hot backup

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Fri, 3 Aug 2012 14:05:55 -0300
Message-ID: <CAJ2dSGTap2cfuL3fuxT+ZGz7Yz-RMT5oGFnysBD7zk3Y=J=X2Q_at_mail.gmail.com>

rman has a nice little feature called duplicate for standby. It will take care of everything. (you may need to manually create the standby redologs in the new primary, if you haven't already done so). You may want to take a look at dataguard broker, it will do everything for you... but it's in the "this is new and we have to iron out some bugs" stage. I expect the 12g version will be more stable :P

also, in 11.2 you can use duplicate from active database: rman > duplicate target database for standby from active database... so you don't even need a shared backup location!

hth
Alan.-

On Fri, Aug 3, 2012 at 4:41 AM, Subodh Deshpande <deshpande.subodh_at_gmail.com
> wrote:

> use rman..it will take care of everything...
> On 3 August 2012 08:16, Michael Schmitt <mschmitt_at_uchicago.edu> wrote:
>
> > Hello,
> > We run Data guard in one of our 11.2.0.2 environments and had to fail
> over
> > to the physical standby today. We are going to need to rebuild the old
> > primary server from scratch and setup Data guard again.
> >
> > I had a question about using a hot backup to setup the new physical
> > standby. Do you copy the redo log files over if you use a hot backup to
> > create the physical standby, or will the redo log files get recreated
> > if/when we ever switch over to it (after it syncs up of course)?
> >
> > Thanks in advance
> >
> > Mike
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> =============================================
> This Gmail Account will be deactivated in One Months Time
> =============================================
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 03 2012 - 12:05:55 CDT