Oracle GoldenGate 12c Implementer's Guide

Testing change data capture and delivery

To test whether change synchronization is working, we must make some data changes on our source database and ensure that they are propagated to and applied on the target.

The following simple steps provide a basic test case that will confirm all is well.

1. On the source database server, start a SQL*Plus session and connect it to the PDB1 database as the SRC user:

   sqlplus src/TIGER@PDB1
   

2. We can call the following script to generate a test transaction:

   SQL> @src_test_transaction.sql
   
   1 row created.
   
   
   1 row created.
   
   
   1 row updated.
   
   
   Commit complete.
   

   Issuing a commit forces Oracle to write the transaction details to the database's online redo logs. These are subsequently read by the Extract process (EOLTP01) in real ...