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.
On the source database server, start a
SQL*Plussession and connect it to thePDB1database as theSRCuser:sqlplus src/TIGER@PDB1We 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
commitforces 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...