In previous articles, we have seen the configuration of change capture. Oracle Golden Gate architecture is mainly a collection of two main process Extract and Replicat.

Extract process runs as source side from which you want to capture data and Replicat process runs at Destination side where you want run replication process.

Each trail file generated by the associated extract process is read by the replicat process sequentially. Replicat supports a high volume of data replication activity and thus network activity is block based and not a record at a time.

Replicat process preserves boundaries of each transaction while replicating, so in case of loss of connectivity target database has the same level of integrity as a source database.

Characteristics of the Replicat process :

  1. The replicat process runs at the target side.
  2. Multiple replicat processes can be used in association with multiple extract process to increase throughput.
  3. The replicat process can read data from Oracle Golden Gate trail files generated by the extract process.
  4. The replicat process can perform data filtering by table, row or by an operation.
  5. We can perform data transformation using replicat.
  6. Replicat process replicates data in such a way it looks like your application performed that operation.

Step by step Configuration of Replicat process

Step 1: Create a checkpoint table in the target database

Step 2: Create a parameter file for replicat

Step 3: Create a replicat group

Step 4: Start the replicat process

Step 5: Check the status of the replicat process

If you want to be updated with all our articles send us an Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Tagged:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.