Oracle GoldenGate Extract and Replicat Parameter Files

 The provided configuration is a typical Oracle GoldenGate unidirectional replication setup where:

• Extract Process captures changes from the source database.
• Replicat Process applies those changes to the target database.
• DDL (CREATE, ALTER, DROP, etc.) and DML (INSERT, UPDATE, DELETE) operations are replicated.

Source GoldenGate Extract Parameter file

============================================

EXTRACT EXA_ORCL

USERIDALIAS ORCL_S DOMAIN OracleGoldenGate

EXTTRAIL AA

--- End of auto generated Parameter File ---

DDL INCLUDE MAPPED  --- Mandatory

DDLOPTIONS REPORT   --- Mandatory

TABLE AMIT.*;               

TABLE SIVA.*;

TABLE PAYAL.*;

TABLE VAISH.*;

Target GoldenGate REplicat Parameter file:-

============================================

REPLICAT REP_ORCL

USERIDALIAS ORCL_T DOMAIN OracleGoldenGate

--- End of auto generated Parameter File ---

DDL INCLUDE MAPPED

DDLOPTIONS REPORT

DDLERROR DEFAULT IGNORE RETRYOP  --- This is optional, if you face any issue

OVERRIDEDUPS                     --- This is optional, if you face any issue

INSERTMISSINGUPDATES

MAP AMIT.*,TARGET AMIT.*;

MAP SIVA.*,TARGET SIVA.*;

MAP PAYAL.*,TARGET PAYAL.*;

MAP VAISH.*,TARGET VAISH.*;

Key Points:-

1. Extract captures changes from Oracle redo logs.
2. EXTTRAIL stores captured transactions in trail files.
3. TABLE defines which tables/schemas are captured.
4. Replicat applies changes on target.
5. MAP defines source-to-target object mapping.
6. DDL INCLUDE MAPPED replicates DDL for mapped objects.
7. DDLOPTIONS REPORT logs DDL actions in report files.
8. OVERRIDEDUPS handles duplicate record situations.
9. INSERTMISSINGUPDATES converts missing-row updates into inserts.
10. USERIDALIAS provides secure credential management instead of hardcoded passwords.

This configuration implements a schema-level Oracle-to-Oracle GoldenGate replication for the schemas AMIT, SIVA, PAYAL, and VAISH, including both DML and DDL replication.