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/

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.

2 comments

  1. 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

Leave a Reply

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