Testing Change Data Capture and Delivery

To test if the CDC 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 to the OLTP database as the SRC user.

   sqlplus SRC/SRC@OLTP
   SQL>
   

2. Insert a new record into the DEPT table and commit the transaction.

   SQL> INSERT INTO dept VALUES (50, 'TEST', 'LONDON');
   
   1 row created.
   
   SQL> COMMIT;
   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 transaction...