My Oracle Support Banner

ogg for mssql cdc mode, why cdc capture job didn't capture transactions (Doc ID 2502219.1)

Last updated on JULY 20, 2024

Applies to:

Oracle GoldenGate - Version 12.3.0.1.3 and later
Information in this document applies to any platform.
With the 12.3+ CDC Extract for SQL Server, GoldenGate relies on the SQL Server CDC Capture job to capture transactions from the database transaction log and populate them into CDC staging tables. If the SQL Server database is enabled as part of an AlwaysOn Availability Group, all replicas for that database must be in sync in order for the CDC Capture job to continuously capture new transactions, otherwise the SQL Server CDC Capture job may appear to be running correctly, it just may not be populating the _CT staging tables.extract cdc mode will not capture transactions to OGG transaction table.

Goal

If Extract is not capturing data and appears hung, and the SQL Server CDC Capture job is running correctly, check if the database is part of an AlwaysOn Availability Group, and if so, have the customer check to determine that the Primary and all Secondary databases are in sync.

 

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!

In this Document
Goal
Solution


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