Subscriber Count

    464

Subscribe to Posts by Email

Pages

Example 11: Missing Trail File

Sometimes there is likely hood that extract trail files are deleted by manually or by discard process.

In those cases, replicat process will abend since it does not have a trail file. Not only the replicat, the extract process itself will abend if its the current extract file.

The following is the sample errors in those cases, if an extract file is deleted.

2015-04-16 08:52:08  ERROR   OGG-01496  Oracle GoldenGate Capture for Oracle, myload2.prm:  Failed to open target trail file /data/ggate/dirdat/bb000007, at RBA 12678462.

In case of missing trail file or files, you can create a extract for specific period and run the extract, in this case you must have archives present in the location