Earlier I wrote a blog post about moving the Oracle Golden Gate Extract from “Classic” capture to “Integrated” capture. In this post, we will take a look at how to move a “Classic” replicat (apply) to an “Integrated” replicat (apply) process.
The initial step to migrate the replicat from “Classic” to “Integrated” are the same as the extract. Look here for the initial details. This post picks up when we are getting ready to stop the replicat and perform the migration.
Before we can do anything with the replcat, we need to be in GGSCI.
[[email protected] oggcore_1]$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 22.214.171.124.0 17185003 17451407_FBO Linux, x64, 64bit (optimized), Oracle 11g on Oct 29 2013 00:31:40 Operating system character set identified as UTF-8. Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved. GGSCI (oel.acme.com) 1>
Now, we need to stop the replciat (apply) process that we are using.
GGSCI (oel.acme.com) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING JAGENT STOPPED EXTRACT RUNNING EXT 00:00:09 00:00:00 EXTRACT RUNNING PMP 00:00:00 00:00:10 REPLICAT RUNNING REP 00:00:00 00:00:08 GGSCI (oel.acme.com) 2> stop replicat rep Sending STOP request to REPLICAT REP ... Request processed.
With the replicat stopped, we need to log into the database through GGSCI.
GGSCI (oel.acme.com) 3> dblogin userid ggate, password ggate Successfully logged into database.
Next, we need to alter the replicat to make it integrated.
GGSCI (oel.acme.com) 4> alter replicat rep, integrated REPLICAT (Integrated) altered.
Finally, we need to start the replicat.
GGSCI (oel.acme.com) 5> start replicat rep Sending START request to MANAGER ... REPLICAT REP starting
Once the replicat has been started, we can check the replicat and look at the details with the INFO option.
GGSCI (oel.acme.com) 7> info replicat rep, detail REPLICAT REP Last Started 2014-04-21 14:06 Status RUNNING INTEGRATED Checkpoint Lag 00:00:00 (updated 00:00:03 ago) Process ID 28410 Log Read Checkpoint File ./dirdat/rt000000 2014-04-21 12:42:14.030503 RBA 6912167 INTEGRATED Replicat DBLOGIN Provided, inbound server name is OGG$REP in ATTACHED state Current Log BSN value: <NULL> Extract Source Begin End ./dirdat/rt000000 2014-04-21 12:42 2014-04-21 12:42 ./dirdat/rt000000 2014-04-21 12:42 2014-04-21 12:42 ./dirdat/rt000000 * Initialized * 2014-04-21 12:42 ./dirdat/rt000000 * Initialized * 2014-04-21 12:42 ./dirdat/rt000000 * Initialized * First Record ./dirdat/rt000000 * Initialized * First Record Current directory /oracle/app/product/12.1.2/oggcore_1 Report file /oracle/app/product/12.1.2/oggcore_1/dirrpt/REP.rpt Parameter file /oracle/app/product/12.1.2/oggcore_1/dirprm/REP.prm Checkpoint file /oracle/app/product/12.1.2/oggcore_1/dirchk/REP.cpr Checkpoint table ggate.checkpoint Process file /oracle/app/product/12.1.2/oggcore_1/dirpcs/REP.pcr Error log /oracle/app/product/12.1.2/oggcore_1/ggserr.log
From looking at the details of the replicat, you can see that it is now integrated and using the DBLOGIN that we provided earlier.
Current Oracle Certs
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”.
Reblogged this on Dinesh Ram Kali..
Are there any concerns or caveats when going from classic to integrated replicat? Or should it perform the same if not better?
No concerns going from classic to integrated with the replicat. It should perform better, but it depends on what you are applying. Keep in mind, you are moving the apply process into the database and turning will require not only GG tuning but database tuning as well … for example: STREAMS_POOL in the SGA.
Dig it, thanks much.