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.
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….
Do you want to learn Oracle Goldengate, then read the following articles.
https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/
MR. Mehmet Salih Deveci Your
Your attention to colleagues, spreading your experience is nowadays a very rare thing and should be appreciated by us with respect and admiration for your person. Your parents must be very proud of the good child they raised.
Thank you.
writing from Brazil I send cordial and respectful greetings of happiness and joys in your life.
Hiran Horta
Thanks for your nice comments.