O'Reilly logo

Oracle GoldenGate 11g Implementer's guide by John P Jeffries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

More about trail files

Trail files are used by Extract and Replicat processes, and their primary role is for data persistence. One could argue that writing files to what could be deemed as a "staging area" is wasteful and suboptimal. That said, GoldenGate writes 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 canonical format being unstructured with a header record. Each record is of a variable record length containing the changed data. A trail can contain numerous trail files each having a two-character prefix with a 6 digit sequence number suffix.

An Extract process can write data to many trails. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required