Oracle Goldengate Step by Step Replication -2

Hi,

I will tell  step by step Replication with Goldengate.

 

 

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;





Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

2 thoughts on “Oracle Goldengate Step by Step Replication -2