My Oracle Support Banner

OGG Replication Stops As Any Node In Sql Server Alwayson Data Synchronization Is Suspended (Doc ID 2416268.1)

Last updated on JULY 05, 2018

Applies to:

Oracle GoldenGate - Version 12.3.0.1.2 and later
Information in this document applies to any platform.

Goal

We have sql server always on replication between 4 nodes. the GG is setup to replicate from the primary node of the four node alwayson to aws MSSQL server.
The issue We have noticed that if always on data synchronization is stopped to any secondary node the GG replication also stops and new data is not replicated to AWS . As soon as the alwayson data sync is back the GG starts replicating the data. Please helps us to understand if this is an expected behavior of GG with alwayson. This is happening both for synchronous and asynchronous alwayson setup.

If this is a expected behavior is there any parameter to change the same behavior to a conscious GG replication irrespective of the alwayson secondary data sysnc status.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.