Site icon IT Tutorial

Oracle Goldengate Step by Step Replication -1

Hi,

I will tell  step by step Replication with Goldengate.

 

If you don’t know what is the Oracle Goldengate, read the following article before this.

Oracle Goldengate Architecture

 

The extract process is the process that will run on the source side. The pump process is also an extract operation and is positioned in the source systems. The preliminary work for reading the log files of the source system for starting the extract process is included in the installation file.

Configuring Extract Process

Add Extract Process

GGSCI (MehmetSalih ) 1>  add extract EXFULL, TRANLOG, begin now


or you can point any time if you have enough archivelog

GGSCI (MehmetSalih ) 1> add extract EXFULL, TRANLOG, begin 2019-03-14 13:00

 

ADD EXTTRAIL to create a trail for online processing on the source system

GGSCI (MehmetSalih ) 2>  add exttrail /u01/goldengate/dirdat/x1, extract EXFULL




GGSCI (MehmetSalih ) 2> edit params EXFULL

You should copy following parameters, and save, exit

 

Extract Process Parameter ( EXFULL )

EXTRACT EXFULL

--Database Connection Information ( You can also write password as encrypted with values option ) 
USERID GOLDENGATE, PASSWORD gg_123
SETENV (NLS_LANG = "AMERICAN_AMERICA.WE8ISO8859P9")
TRANLOGOPTIONS ASMUSER GOLDENGATE@ASM, ASMPASSWORD gg_123

-- Discard File
DISCARDFILE /u01/goldengate/dirrpt/EXFULL.dsc, APPEND, MEGABYTES 100

-- Trail File Location
EXTTRAIL /u01/goldengate/dirdat/x1

GETUPDATEBEFORES
NOCOMPRESSDELETES
NOCOMPRESSUPDATES
WARNLONGTRANS 1H, CHECKINTERVAL 10M

--Tables to be Replicate
TABLE msdeveci.*;

 

Start Extract Process like following

GGSCI (MehmetSalih as GOLDENGATE@orcl) 82> start EXFULL



GGSCI (MehmetSalih as GOLDENGATE@orcl) 82> info EXFULL

EXTRACT EXFULL Last Started 2019-03-14 09:46 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
Process ID 19963
Log Read Checkpoint Oracle Redo Logs
2019-03-14 09:51:36 Seqno 9, RBA 546816
SCN 0.462437 (462437)

 

Configuring Pumper Process ( PXFULL )

Add Extract Process

GGSCI (MehmetSalih as GOLDENGATE@orcl) 83> ADD EXTRACT PXFULL, EXTTRAILSOURCE /u01/goldengate/dirdat/x1

 

Assing Extract Process to Pump Process

GGSCI (MehmetSalih as GOLDENGATE@orcl) 84> ADD RMTTRAIL /u01/goldengate/dirdat/x1, EXTRACT PXFULL

 

 

You should copy following parameters, and save, exit

 

 

Extract Process Parameter ( PXFULL )

 

GGSCI (MehmetSalih as GOLDENGATE@orcl) 85> edit params PXFULL

EXTRACT PXFULL

--Database Connection Information ( You can also write password as encrypted with values option ) 
USERID GOLDENGATE, PASSWORD gg_123
SETENV (NLS_LANG = "AMERICAN_AMERICA.WE8ISO8859P9")

-- Discard File
DISCARDFILE /u01/goldengate/dirrpt/PXFULL.dsc, APPEND, MEGABYTES 100

-- Remote Host Informations ( Target DB ) 
RMTHOST 192.168.63.63, MGRPORT 7809, COMPRESS
RMTTRAIL /u01/goldengate/dirdat/x1

NOPASSTHRU

-- Passthru Mode
PASSTHRU

--Tables to be Replicate ( Write all objects,needs to be replicate )
TABLE msdeveci.*;

 

start pumper process like following

GGSCI (MehmetSalih as GOLDENGATE@orcl) 87> start PXFULL

 

monitor pumper process if it is running or not.

GGSCI (MehmetSalih as GOLDENGATE@orcl) 88> info PXFULL





Read the second article to complete Goldengate Replication….

Oracle Goldengate Step by Step Replication -2

 

 

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

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

Exit mobile version