Starting GoldenGate Continuous Real-Time Replication

Start the GoldenGate Replicat process rep using GGSCI, specifying the SCN value from which to start.

GGSCI>START REPLICAT rep, AFTERCSN 12345678

Note:

GoldenGate refers to this value as a CSN (Commit Sequence Number) rather than an SCN, hence the parameter name AFTERCSN.

You can see the changes are replicated from source database to TimesTen. You can also check the status of a Replicat process using the following GGSCI command.

GGSCI>INFO REPLICAT rep

You now have a working setup that uses GoldenGate to replicate data changes from your source Oracle database to your TimesTen cache database.