Category Golden Gate

Oracle Golden Gate Incremental Refresh between source and target database / schema

by Snehashish Ghosh

Scenario


 After doing initial data loading into the source and target schema/database it is required to configure Oracle Golden Gate so that source schema/database is automatically remains in sync with target schema/database.

Solution


 Configure Extract Process on the Source System


 1.     Add Supplemental log data

Adding supplemental log data will ensure that the primary key columns are also captured by the extract process along with the changed columns for the rows.

d:\ogg>ggsci
GGSCI (WIN1) 1> dblogin userid ggate

Password:

Successfully logged into database.

GGSCI (win1) 2> add trandata sender.tcustmer

GGSCI(win1) 3> add trandata sender.tcustord

2.     Add Extract checkpoint in oracle redo log

GGSCI (WIN1) 5> add extract extsend, tranlog, begin now

EXTRACT added.

3...

Read More