RAJESHKUMAR GOVINDARAJAN

blogs from COCHIN

DDL Replication and DDL mapping Restriction DEMO in oracle goldengate
The components that support the replication of DDL and the replication of transactional data changes (DML) are independent of each other. Therefore, you can synchronize: just DDL changes just DML changes both DDL and DML By default the DDL replication is disabled on the source database (extract side...
Posted on 23 December 2018 | 1:17 am
Read post
Understanding RBA using demo by table data recover in goldengate environment
This is purely for understanding the RBA. please do not try this in production environment without proper understanding and knowledge of your goldengate replicat configuration. reverting back the Replicat RBA will impact all the tables in replicat group. so be cautious. Demo:- below are the RBA note...
Posted on 22 December 2018 | 5:21 am
Read post
Modifying Columns of a Table in Goldengate configuration when not using DDL replication
Here is a demo to modify/add columns in a table in oracle goldengate configuration. In this demo, I used both source and target in the same database. Database name:- ggtest1 Step 1:- Preparing the Environment SQL> select log_mode from v$database; LOG_MODE ------------ ARCHIVELOG SQL> alter database...
Posted on 21 December 2018 | 2:27 am
Read post