More about trail files

Trail files are used by Extract and Replicat processes; their primary role is for data persistence. You could argue that writing files to what could be deemed as a staging area is wasteful and suboptimal. Having said that, GoldenGate writes only the committed transactions to trail files in large blocks minimizing I/O. Furthermore, the architecture provides a guaranteed no data loss solution that is not to be underestimated.

The trail

By default, trail files are in the canonical format being unstructured, but with a header record. They are stored in the ./dirdat subdirectory under the GoldenGate Home. Each record contains the changed data and is of a variable record length. A trail can contain numerous trail files, each having ...

Get Oracle GoldenGate 12c Implementer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.