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
Trainee was trying to apply some transactions on target system but transactions not applying even though replicat is running
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
Check the parameter file and correct the table name in case of any discrepancy. Otherwise, reposition the trail using below command:
alter replicat, begin
- 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.
Did You Register For FREE GoldenGate Webinar?
NO! So your next task is to get yourself register for our FREE Webinar on Learn Oracle GoldenGate 12c for Replication & Migration to start your Goldengate journey. Click on the image below to register for FREE.
Do you have any queries in Oracle GoldenGate 12c? please reach out to us at firstname.lastname@example.org