Hi,
I am responsible for ~6,000 instances running world wide. My company embeds Oracle Database 19c and Oracle GoldenGate 19 into it's software product. I occasionally see the following error in ggserr.log:
2025-02-21T10:00:14.933-0600 ERROR OGG-02171 Oracle GoldenGate Capture for Oracle, pcapture.prm: Error reading LCR from data source. Status 500, data source type TrailDataSource.
2025-02-21T10:00:14.933-0600 ERROR OGG-01091 Oracle GoldenGate Capture for Oracle, pcapture.prm: Unable to open file "/home/root/home/company/oracle/oracle/product/gg/dirdat/V1035335/aa000000093" (error 2, No such file or directory).
2025-02-21T10:00:14.941-0600 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, pcapture.prm: PROCESS ABENDING.
What are the implications if I simply do the following to resolve the issue:
ggsci
dblogin userid stradmin@V1035335, password <password>
ALTER EXTRACT PCAPTURE, EXTSEQNO 0 EXTRBA 0
exit
Best,
Dan