Golden Gate Replicat On Tandem Abends With File Not Found Error(Error 11) During Replication.
Last updated on MARCH 01, 2018
Applies to:Oracle GoldenGate - Version 18.104.22.168.8 and later
Information in this document applies to any platform.
We have a golden gate extract and replicat configured between our two Tandem boxes. Today replicat got abended .We retain 30 day's of files and everyday at 02:00 AM a process will kick off the cutover. This cutover will create current dated file and delete the latest 30th day file. Below is the steps we follow for cutover
Stop the replicat
Start the replicat
$DATA21.PRO1N.RN123456 is the file which was delete today. As per the process we stopped the replicat,did the cutover and restarted the replicat. We have few seconds delay configured between stopping the replicate and the cutover. Today after stopping the replicat some refund transactions came in for date RN123456. So the file got updated and the extract trail file also had that transaction detail of RN123456 file. But as our cutover process deleted the RN123456 file it was not able to replicate the data on other system. The replicate got abended with error 11(File not found). This is very rare scenario wherein we received transaction for the data which had to be deleted. But we would like to handle this scenario so that in future the replicate will not abend.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms