Performing an initial load using GoldenGate

So far we have seen how to replicate the changes that occur in a source environment continuously to the target environment. GoldenGate applies these changes using the standard SQL calls to the target database. The success of these statements depends on the state of the data within the database. For this it is imperative that your source and target databases are in a synchronous state before you start the continuous replication between them. If your target database tables are not in the same state as the source database tables, it is quite possible that certain statements will fail. A simple example of this case is when you try to apply an UPDATE statement to the target database that was run in the source ...

Get Oracle GoldenGate 11g Complete Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.