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 time and written to the local trail. The transaction in the local trail is read by the data pump process (EPMP01) that transfers the data via TCP/IP to the remote trail. The Replicat process (ROLAP01) reads the remote trail, converts the...