Oracle GoldenGate Processes – Part 2 – Extract
The extract process of Oracle GoldenGate is used to perform change data capture from the source database. The extract can be used to read the online transaction log (in Oracle the online redo logs) or the associated archive logs. The data that is extracted from the source database is then placed into an trail file (another topic for a post) for shipping to the apply sided.
To configure an extract process there needs to be a parameter file associated with it. The parameter file can be edited after adding the extract to the Oracle GoldenGate environment if needed. In order to configure an extract it needs to be added to the environment and assigned a local trail file location.
Adding an Extract and Local Trail File:
Using GGSCI:
$ cd $OGG_HOME
$ ./ggsci
GGSCI> add extract EXT, tranlog, begin now
GGSCI> add exttrail ./dirdat/lt, extract EXT, megabytes 200
Note: The trail file is required to be prefixed with a two letter prefix.
Edit Extract Parameter File:
From GGSCI:
$ cd $OGG_HOME
$ ./ggsci
GGSCI> edit params EXT
Edit Extract Parameter File from Command Line:
$ cd $OGG_HOME
$ cd ./dirprm
$ vi ./ext.prm
Example of Extract Parameter File:
EXTRACT EXT
USERID ggate, PASSWORD ggate
TRANLOGOPTIONS DBLOGREADER
SETENV (ORACLE_HOME=”/u01/app/oracle/product/11.2.0/db_3″)
SETENV (ORACLE_SID=”orcl”)
WARNLONGTRANS 1h, CHECKINTERVAL 30m
EXTTRAIL ./dirdat/lt
WILDCARDRESOLVE IMMEDIATE
TABLE SCOTT.*;
Start/Stop the Extract:
Start Extract:
$ cd $OGG_HOME
$ ./ggsci
GGSCI> start extract EXT
Stop Extract:
$ cd $OGG_HOME
$ ./ggsci
GGSCI> stop extract EXT
Enjoy!
about.me: http://about.me/dbasolved
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”.
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.
I love how this blog gives a voice to important social and political issues It’s important to use your platform for good, and you do that flawlessly
When I initially commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several emails with the same comment. Is there any way you can remove people from that service? Bless you!
Regards for this post, I am a big fan of this website would like to go on updated.
det. Denne side har bestemt alle de oplysninger, jeg ønskede om dette emne, og vidste ikke, hvem jeg skulle spørge. Dette er min 1. kommentar her, så jeg ville bare give en hurtig
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
The Natural Mounjaro Recipe is more than just a diet—it’s a sustainable and natural approach to weight management and overall health.
Introducing to you the most prestigious online entertainment address today. Visit now to experience now!
muito dele está a aparecer em toda a Internet sem o meu acordo.
公益社団法人日本水難救済会. “くま クマ 熊 ベアー 5”.主婦と生活社.演:沖わか子 小雪と同室の看護婦。虎之介の結婚後はたびたび後を追い回し、新婚夫婦をゲンナリさせる。虎之介に惚れていたが、最終的には新との結婚を祝福。 お互いの感情の行き違いから離婚寸前まで陥ったが周囲の取りなしもあり龍之介と復縁。演:河内桃子龍之介の妻。演:水野哲 龍之介と章子との一人息子。
Thank you for this great post! It has been extremely helpful. I hope that you will carry on sharing your wisdom with us.