Oracle GoldenGate Processes – Part 4 – Replicat
The replicat process is the apply process within the Oracle GoldenGate environment. The replicat is responsible for reading the remote trail files and applying the data found in cronilogical order. This ensures that the data is applied in the same order it was captured.
Until recently there was only one version of a replicat, that version was the classic version. As of 12.1.2.0, there are now three distinct versions of a replicat. These replicat types are:
- Classic Mode
- Coordinated Mode
- Integrated Mode
Each of on these modes provide some sort of benefit depending on the database being applied to. Oracle is pushing everyone to a more integrated approach; however, you have to be on database version 11.2.0.4 at a minimum.
To configure the replicat process is similar to the extract and data pump processes.
Adding a Replicat:
From GGSCI (classic):
$ cd $OGG_HOME
$ ./ggsci
GGSCI> add replicat REP, exttrail ./dirdat/rt
Note: The add command is assuming that you already have a checkpoint table configured in the target environment.
Edit Replicat parameter file:
From GGSCI:
$ cd $OGG_HOME
$ ./ggsci
GGSCI> edit params REP
From Command Line:
$ cd $OGG_HOME
$ cd ./dirprm
$ vi REP.prm
Example of Replicat Parameter file:
REPLICAT REP
SETENV (ORACLE_HOME=”/u01/app/oracle/product/11.2.0/db_3″)
SETENV (ORACLE_SID=”orcl”)
USERID ggate, PASSWORD ggate
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/REP.dsc, append, megabytes 500
WILDCARDRESOLVE IMMEDIATE
MAP SCOTT.*, TARGET SCOTT.*;
Start the Replicat process:
Depending on if you are starting the replicat for the first time or not; how you start is going to be similar yet different.
To star the Replicat after an inital load:
$ cd $OGG_HOME
$ ./ggsci
GGSCI> start replicat REP, atcsn [ current_scn ]
Note: The current_scn needs be obtained from the source database prior to doing the inital load of data to the target. This ensure the consistancy of the data and provides a starting point for the replicat to start applying data from.
To start Replicat normally:
$ cd $OGG_HOME
$ ./ggsci
GGSCI> start replicat REP
Stop the Replicat process:
Stop replicat normally:
$ cd $OGG_HOME
$ ./ggsci
GGSCI> stop replicat REP
Enjoy!
about.me: http://about.me/dbasolved
Current Oracle Certs

Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.

Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.
Good site you’ve got here.. It’s difficult to find high-quality writing like yours nowadays. I truly appreciate individuals like you! Take care!!
Saved as a favorite, I really like your blog!
Good post. I learn something more challenging on completely different blogs everyday. It is going to always be stimulating to read content material from different writers and observe a little bit one thing from their store. I’d favor to use some with the content on my weblog whether you don’t mind. Natually I’ll offer you a hyperlink in your net blog. Thanks for sharing.
Dedicated to excellence, BWER offers Iraq’s industries durable, reliable weighbridge systems that streamline operations and ensure compliance with local and global standards.
Obrigado|Olá a todos, os conteúdos existentes nesta
79906 478145Interested in start up a online business on line denotes revealing your service also providers not only to humans within your town, nevertheless , to numerous future prospects which are cyberspace on several occasions. pays everyday 675028
Děkuji|Ahoj všem, obsah, který je na této stránce k dispozici.
I loved as much as youll receive carried out right here The sketch is tasteful your authored material stylish nonetheless you command get bought an nervousness over that you wish be delivering the following unwell unquestionably come more formerly again since exactly the same nearly a lot often inside case you shield this hike
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.