6 Working with Trails
A trail is a series of files on disk where Oracle GoldenGate stores the captured changes temporarily to support the continuous extraction and replication of database changes You can use trails to monitor path, tune networks, and data input and output.
This section describes the tasks to set up trails:
Topics:
Quick Tour of the Receiver Server Home Page
The Receiver Server is the central control service that handles all incoming trail files.
The Receiver Server works with the Distribution Server to provide compatibility with the classic remote architecture. The Receiver Server home page shows the condition of the distribution path with one end depicting the Extract and the other end, the Replicat.
You can use the Receiver Server home page to view the path details. Simply click Action, Details to see the path details. To know more, see Monitoring Paths.
Tuning Network Parameters
The network settings in Receiver Server are for Receiver Server initiated paths and must mirror the ones in Distribution Server. Network parameters include TCP flush byte options, DSCP, ToS, buffer size settings and so on.
-
Click the target-initiated path Action button and select Details.
-
From the Path Information tab, expand the Advanced Options, which has the setting for EoF Delay (centiseconds). You may typically need to edit this setting for non-Linux platfoms.
Reviewing the Receiver Server Path Information
You can constantly monitor the activity of the path on the Receiver Server Statistics page.
The Statistics tab shows you detailed information about the logical change records (LCRs) and DDLs that were read from trails, LCRs and DDLs sent and received, LCRs and DDLs filtered. It also provides information about the DML types, inserts, updates, upserts, and deletes.
The table information includes the values of LCRs read and sent. You can use the arrows to sort the tables and the search to quickly locate a specific table. The search is case insensitive and starts searching as you type to update the table.