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

  • From: Guenadi Jilevski <gjilevski@xxxxxxxxx>
  • To: dedba@xxxxxxxxxx
  • Date: Wed, 19 Sep 2012 18:41:01 +0300

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@xxxxxxxxxx> 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@xxxxxxxxxx
> > <mailto:dedba@xxxxxxxxxx>> wrote:
> >
> >     G'day!
>
> <snip due to overquoting>
>
> >     Cheers,
> >     Tony
> >     --
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


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


Other related posts: