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 database. If the row that you are trying to update does not exist in the target environment, the statement will fail.

There are many methods available to instantiate target database/schemas. You can use the non-GoldenGate methods to do this. However...