Demo session to start replication of tables from Source oracle database to target oracle database
Step-1 To create Extract process, click on + sign and click on Next button.
What is Extract:- The Extract process captures data from the source database and writes it to a trail file (EN).
Note:- We are using Integrated Extract, Please choose as per your requirement
Once click on Next button, below page appears. Please fill the details
Once we click on Next button, Below next page appears.
Now, add tables name here and click on create button as shown in below snap
Once click on create button, the Extract process created as below snap
Step-2 Now to create Replicat process for Target Database, Click on + sign on Replicats side.
What is Replicat :- The Replicat process delivers the change data from the trail file (NE) created by the Extract, to the target database.
Note:- Replicat reads the trail file on the target database, re-creates the DML or DDL operations, and applies them to the target database.Pre-requisite:- make sure that you added your checkpoint table for the target database (POPDB)
Use the same name of the trail file (as Extract process) 
Below is the next page, where we need to add tables as shown in below snap 
Add MAP tables as shown in below snap then click on Create button (Do not Start Replicat process)
Now, Both the process (Extract and Replicat process) has bee added
Now, Please start the Extract Process, which looks like below snap 
Step-3 On this step, Please take the expdp backup of the required tables.
First, check the current_scn from source database and use this to expdp backup as shown in below snap.
Now take the backup using FLASHBACK_SCN parameter and transfer to target Oracle database.
Transfer this backup to Target database and restore it.
Restore the backup to Target Database as shown in below snap
Step-4 Now Login to OGG console and start the Replicat process using CSN
Use Start Point option as After CSN and CSN option as 3698151 (FLASHBACK_SCN used in expdp backup)
Once click on Start button, Please check the status of Replicat process as shown in below snap.
There is lag in Replicat side, But after few minutes this will be the fine.
Now, Once everything is perfect. Please do some of the DML/DDL on source database and check the row count on both source and target database.
Thank you for joining the session.............................Enjoy and Stay connected.
NEXT–> Manage all the process using command line tool used in OGG microservice.
Caution: It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.
Thank you,
A. Rawat
Email: 88arawat@gmail.com