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 18.104.22.168.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!