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
Vijay Kumar says
Hi,
I want to take book regarding golden gate interview
Rohit Pathak says
Hi Vijay,
Please check the below to get 20+ Interview questions for Golden Gate
Url: https://k21academy.com/goldengate01
Thanks & Regards,
Rohit (TeamK21)
navnish says
Golden gate process is running however lag is increasing and also in stats no of transaction is increasing , any way we can check where GG replicate is stuck
Brian says
check the parameter streams_pool_size
should be 2500M