If automatic recovery is unavailable, you must manually move the process past the corruption: For Replicat:
Save the file and start the Replicat. Note: Remove temporary parameters once the process successfully moves past the broken file. Best Practices to Prevent OGG-01184 ogg-01184 expected 4 bytes but got 0 bytes in trail
The built-in logdump utility is the primary tool for diagnosing trail file integrity. It allows you to "look inside" the binary trail file at the exact byte level to see what is or isn't there. To run the diagnostic, follow these steps: If automatic recovery is unavailable, you must manually
If you are using Oracle GoldenGate 12.2 or higher, you can often recover remote trails automatically: Stop the Pump process on the source. Delete the corrupted trail file from the target. It allows you to "look inside" the binary
Because this error involves potential data loss through skipping records, Oracle officially recommends contacting Oracle Support if the cause cannot be immediately determined. repositioning command based on your current sequence number and RBA? OGG-01184 - Oracle GoldenGate Error Messages
Check the actual size of the trail file mentioned in the error log using OS commands (e.g.,
ls -l ./dirdat/rt* If the last trail file is suspiciously small or ends abruptly, it may be incomplete.
