I will tell step by step Replication with Goldengate.
Read the first article before this article.
Create Replicat process on target DB
Add Replicat Process
GGSCI (Deveci ) 1> add replicat RXFULL, exttrail /u01/goldengate/dirdat/x1, checkpointtable GOLDENGATE.CHKPTBL Start Replicat Process
Login database and Add Checkpointtable to the Replication database via goldengate.
GGSCI (Deveci ) 2> dblogin USERID GOLDENGATE, PASSWORD gg_123 GGSCI (Deveci ) 3> add checkpointtable GOLDENGATE.CHKPTBL GGSCI (Deveci ) 4> edit params RXFULL
You should copy following parameters, and save, exit
REPLICAT RXFULL --Database Connection Information ( You can also write password as encrypted with values option ) SETENV (ORACLE_SID=orcl) SETENV (ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1) USERID GOLDENGATE, PASSWORD gg_123 -- Statistic and Report informations STATOPTIONS, RESETREPORTSTATS REPORTCOUNT EVERY 1 MINUTES, RATE REPORT AT 00:00 REPORTROLLOVER ON SUNDAY -- Discard file information DISCARDFILE ./dirrpt/RXFULL.dsc, APPEND, MEGABYTES 100 --Table definition information ASSUMETARGETDEFS --HANDLECOLLISIONS DBOPTIONS NOSUPPRESSTRIGGERS -- Table informations MAP msdeveci.*, TARGET msdeveci.*, colmap( usedefaults );
you can start replicat like following
GGSCI (Deveci ) 6> start replicat RXFULL
monitor replicat with following
GGSCI (Deveci ) 7> info replicat RXFULL
Create Sample Table on source database like following For GoldenGate Replication. You should see same table and data on target database in a few second or minutes according to data size.
create table msdeveci.goldengate_test as select rownum as id, rownum + 1 as id2, 'Mehmet Salih Deveci Goldengate Training' as name, mod(rownum,5) as id3, mod(rownum,10) as id4 , 14531453 as cost, trunc(sysdate - 100 + mod(rownum,10000)) as date, trunc(sysdate - 9999 + mod(rownum,10000)) as date2 from dual connect by level<=1e2;