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/

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and 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 [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

3 comments

  1. Hello, I want to work in your company on a voluntary basis, can you offer me anything?
    a little about me:https://about.me/ruthmcfarlane/

  2. This article is actually a pleasant one it assists new internet viewers, who are wishing for blogging.|

  3. You sound a bit out of context-you ought to add some detail?

Leave a Reply

Your email address will not be published. Required fields are marked *