OGG Replication Stops As Any Node In Sql Server Alwayson Data Synchronization Is Suspended
Last updated on JULY 05, 2018
Applies to:Oracle GoldenGate - Version 188.8.131.52.2 and later
Information in this document applies to any platform.
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.
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 hundreds of Community platforms