Replicat running but not applying transactions – Oracle GoldenGate:

In this post we cover one of issues that our trainee faced during replication that replicat is running but not applying transactions, one of the common issue/query that we get frequently from our trainees in our training Oracle GoldenGate 12c Administration.

We have noticed as per our experience during training, there are some of the common queries/issues faced by trainees while they are supporting the Goldengate environment or setting up the new environment. Hence we have come up with a blog series on those common issues/questions and resolution. Here is the third Query:

Check here for the second query, you have compressed table in database and confused how to replicat it? Get answer from here

Issue: 

Trainee was trying to apply some transactions on target system but transactions not applying even though replicat is running

Reasons:

Below are the possible reasons:
1) The wrong trail is being read
2) The table name format is incorrectly specified
3) Wrong table name specified

Solution:

Check the parameter file and correct the table name in case of any discrepancy. Otherwise, reposition the trail using below command:

alter replicat, begin

Related/Further Reading:

• Tuning Replicat Transactions
• Oracle GoldenGate: How to Handle Tables Without Primary Keys/Unique Indexes
• Oracle GoldenGate: How to replicate compressed table in database
• Oracle GoldenGate 12c: Step by step Activity Guides 
• Oracle GoldenGate 12c Administration

This post is from our Oracle GoldenGate 12c Administration Training, in which we cover  Architecture, Installation, Configuring & Preparing the Environment, DML Replication – Online Change Synchronization, Initial Load, Zero Downtime Migration & Upgrading using GoldenGate, Oracle GoldenGate Security, Performance of Oracle GoldenGate and Troubleshooting and much more.

Next Task For You

Want to move ahead in your career and want to get a higher Earning Job?
Get 7+ Courses for DBAs & Apps DBA in a bundle program and learn from the Industry’s best Experts