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

  • From: De DBA <dedba@xxxxxxxxxx>
  • To: Oracle-L@xxxxxxxxxxxxx
  • Date: Wed, 19 Sep 2012 15:15:15 +1000

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


Other related posts: