Re: Dataguard role switching procedure with active GoldenGate replication - is there a best practice?

From: Guenadi Jilevski <gjilevski_at_gmail.com>
Date: Wed, 19 Sep 2012 18:41:01 +0300
Message-ID: <CADFytLjxZn2MLCPB_w+j6HCjDWNodsTKw9qyqWpvrySGd3t1eQ_at_mail.gmail.com>



Hi,
Small clarification in addition to the previous E-mail. With NFS you would stop/start the replicats only with a copy you would stop/start the pump and replicats.

Regards,

Guenadi Jilevski

On Wed, Sep 19, 2012 at 8:15 AM, De DBA <dedba_at_tpg.com.au> wrote:

> Hi Guenadi,
>
> Yes, it is temporary and a once-off. This has merit.. I hadn't
> considered it even. As I understand, as long as the standby is
> completely synchronised, the replicats should in this scenario simply
> pick up at the point where they left off? If so, there should be no need
> even to stop datapump or extract on server A when NFS mount from B to C
> is used, should there?
>
> Cheers,
> Tony
>
> On 19/09/12 12:36 PM, Guenadi Jilevski wrote:
> > Hi,
> > Will it be just one time move or a permanent requirement for replication
> > to B or C?
> > If it is a one time move I would NFS mount OGG home from B to C or copy
> > OGG from B to C and will start same replicats on C after B switchover to
> > C, note same checkpoint files on both replicat site. If replicat crashes
> > it is Recoverable. The adjustment will be the rmthost parameter on the
> > pump only.
> > If it is a constant requirement than I would implement two pumps one
> > to B and the second to C, but can use the above approach as well.
> > The previously suggested order of making sure that extract, capture
> > transactions ( send extract * logend, send extract getlag), make sure
> > that pump process trail records and replicat applies until all record
> > applied (send replicat status etc) applies in both cases.
> > Regards,
> > Guenadi Jilevski
> >
> > On Tue, Sep 18, 2012 at 3:05 PM, De DBA <dedba_at_tpg.com.au
> > <mailto:dedba_at_tpg.com.au>> wrote:
> >
> > G'day!
>
> <snip due to overquoting>
>
> > Cheers,
> > Tony
> > --
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 19 2012 - 10:41:01 CDT

Original text of this message