GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Several goldengate source tables keep having their supplemental transaction log go to disabled?

in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered

Hello all,

We have setup Oracle GG Microservices 21c HUB Architecture with an Oracle 12c Source DB replicating to Oracle 19c DB. Just this past weekend, we had a new table get added into the source DB of which replicated over to the target DB. Within ./adminclient CLI, we logged into the group and also dblogin into the source DB, we issued "ADD TRANDATA schema.table" to ensure logging of supplemental redo data was indeed enabled for table.

A few days passed and then we saw that the REPLICAT process failed due to supplemental transaction log data getting disabled for the table. An UPDATE transaction was trying to run...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center