Description of the illustration logicalarch2.jpg

This graphic shows the Oracle GoldenGate architecture for the Oracle GoldenGate initial load method and for the replication of ongoing data changes. In the initial load, the desired rows are selected from the source database and sent to Replicat to populate the target tables, placing the two databases in a synchronized state. In change synchronization mode, the Extract process captures transactional changes and then either sends the data to the target or else persists it to an optional local trail that is read by a data pump process that sends the data to the target. On the target, the Collector process receives the data and writes it to a local trail, from which the Replicat process gets the data and applies it to the target database.