Switch to Integrated Replicat

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.

Code 1:

[oracle@oel oggcore_1]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 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.

Code 2:

GGSCI (oel.acme.com) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

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.

Code 3:

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.

Code 4:

GGSCI (oel.acme.com) 4> alter replicat rep, integrated
REPLICAT (Integrated) altered.

Finally, we need to start the replicat.

Code 5:

GGSCI (oel.acme.com) 5> start replicat rep

Sending START request to MANAGER ...

Once the replicat has been started, we can check the replicat and look at the details with the INFO option.

Code 6:

GGSCI (oel.acme.com) 7> info replicat rep, detail

REPLICAT   REP       Last Started 2014-04-21 14:06   Status RUNNING
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

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.


twitter: @dbasolved

blog: http://dbasolved.com


  1. Are there any concerns or caveats when going from classic to integrated replicat? Or should it perform the same if not better?

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

      1. Dig it, thanks much.

Leave a Reply to curtisbl Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: