If the corruption exists at the very end of a trail file and only affects a few unrecoverable bytes, you can force the Replicat to skip to the next available valid trail file sequence.
Oracle GoldenGate (OGG) is a robust tool for real-time data integration and replication. However, administrators occasionally encounter errors that disrupt data pipelines. One such disruptive error is .
To ensure you never face an unexpected production outage from OGG-01184 again, implement these infrastructure safeguards:
ERROR OGG-01184 Expected 4 bytes, but got 0 bytes, in trail ./dirdat/xx000000, seqno XX, reading record trailer token at RBA XXXXXXX. ogg-01184 expected 4 bytes but got 0 bytes in trail
The error indicates that an Oracle GoldenGate process (typically a Pump or Replicat ) expected to read a specific amount of data (4 bytes) for a record trailer token but found nothing (0 bytes). This usually signifies that the trail file is corrupted or truncated, often due to an interrupted write operation or network failure . Immediate Troubleshooting Steps Identify the Corrupt Trail :
TRAILBYTEORDER REVERSEOPTION -- OR use the following hidden/advanced parameter if instructed by Oracle Support: ALLOWINVALIDELEMENTS Use code with caution.
In Extract and Replicat parameters, add: If the corruption exists at the very end
Confirm the target filesystem is not full, which can lead to truncated trail files.
Depending on whether the error occurs on a Pump Extract or a Replicat, choose the appropriate remediation method below.
Examine the GoldenGate report file ( .rpt ) and the global error log ( ggserr.log ) to identify which specific trail file and RBA (Relative Byte Address) caused the failure. GGSCI> view report GGSCI> view ggseclog Use code with caution. Step 2: Inspect the Trail File with Logdump One such disruptive error is
Alter the Pump/Replicat to start at the beginning of the next available sequence number. ALTER PUMP , EXTSEQNO , EXTRBA 0 4. Best Practices to Prevent OGG-01184
The Data Pump process lost connectivity to the target, leading to partial writes.
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later. Extract & Pump Abends — oracle-mosc
Restore the trail file from a known good backup if available.