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

From: De DBA <dedba_at_tpg.com.au>
Date: Wed, 19 Sep 2012 15:15:15 +1000
Message-ID: <505954E3.30608_at_tpg.com.au>



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
Received on Wed Sep 19 2012 - 00:15:15 CDT

Original text of this message