Re: dataguard recovery

From: Leyi Zhang (Kamus) <"Leyi>
Date: Fri, 18 Mar 2011 23:19:27 +0800
Message-ID: <AANLkTinTC-hbGh=C2pi3BxPTyZi3zFMEFgecjdd6Ow8D_at_mail.gmail.com>



Assume after you did the incomplete recovery on the primary, the standby SCN is larger than primary. I think you have no way to rollback the SCN if not using flashback database.

How did you do the incomplete recovery? Restore whole database then recover until some SCN, then open resetlogs? Build a physical standby need no more than these, restore and put the database in managed recovered mode is enough (assume you have enough archived logs remained on primary), actually you are not from the scratch, you don't need to modify the tnsnames.ora, don't need to modify the init.ora.

For the logical standby, it can be converted from a physical standby.

--
Kamus <kamusis_at_gmail.com>

Visit my blog for more : http://www.dbform.com
Join ACOUG: http://www.acoug.org



On Thu, Mar 17, 2011 at 7:22 AM, ed lewis <eglewis71_at_gmail.com> wrote:

> Hi,
>     I have a 2- node rac cluster using dataguard.
> There 2 standbys, 1 physical,1 logical.
>
> If incomplete recovery is required on the primary,
> do the standbys need to be rebuilt from scratch ?
>
> Can I use the same recovery process on the standbys
> as what's used on the primary ?
>
> Flashback is not enabled.
>
> oracle 10.2.0.4, asm, rac, solaris 10.
>
> Thanks in advance for your input.
>
>     ed
-- http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 18 2011 - 10:19:27 CDT

Original text of this message