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

Trail file management

In a busy database environment, redo data generation can increase significantly, particularly with the required supplemental logging enabled on your source tables. As we know, an Oracle database will "recycle" its redo logs in a round-robin fashion, switching to the next log when full. GoldenGate scans the redo logs and writes its own Trail files to the dirdat subdirectory. Although the Trail file data is typically a quarter the size of its equivalent redo data, if left unmanaged, the volume of files in dirdat can be significant. In the worst case, filling the filesystem to 100% utilized. Obviously this is not ideal, so GoldenGate has provided an automated mechanism for purging Trail files from this area.

This is achieved ...

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