Site icon IT Tutorial

Oracle Goldengate Step by Step Replication -2

Hi,

I will tell  step by step Replication with Goldengate.

 

 

Read the first article before this article.

Oracle Goldengate Step by Step Replication -1

Oracle Goldengate Architecture

 

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;




 

Do you want to learn Oracle Goldengate, then read the following articles.

https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/

Exit mobile version