GoldenGate Integrated Capture

What is Integrated Capture

Instead of reading from the redo/archive logs, the Oracle GoldenGate Extract process interacts directly with a database logmining server to receive data changes in the form of logical change records (LCR).

Benefits

Some of the benefits of Integrated Capture are :

  • supports more data and storage types as compared to classic capture
  • automatic integration with the RMAN log retention feature to ensure that required archive logs are not deleted
  • transparent support with RAC for the addition or removal of nodes
  • automatic support of Transparent Data Encryption

To support all Oracle data and storage types, the compatibility setting of the source database must be at least 11.2.0.3.0 with the 11.2.0.3 Database specific bundle patch for Integrated Extract 11.2.x (Doc ID 1411356.1).

Database User Privileges

In addition the privileges required for Classic Capture, two more privileges are required.

exec dbms_goldengate_auth.grant_admin_privilege(‘GGATE’);
grant select on V_$DATABASE to ggate;

Replication

The GoldenGate installation for Integrated Capture is no different than if the Classic Capture was being used.  In fact, you may run both types of extracts on the same server simultaneously.  The differences are in the login and how the extract capture process is created.  For a complete installation, you check look at one of my previous posts here.  Let’s see how it works.

Adding the Capture Process

GGSCI> DBLOGIN USERID ggate, PASSWORD ggate
GGSCI> MININGDBLOGIN USERID ggate, PASSWORD ggate
GGSCI> REGISTER EXTRACT cname DATABASE
GGSCI> add extract cname, <em><strong>integrated tranlog</strong></em>, begin now
GGSCI> add exttrail /u01/app/oracle/product/gg/dirdat/lt, extract cname

The differences from Classic Capture are highlighted and italicized above.

In addition, you should put the miningdblogin in the capture parameter file as well.

TRANLOGOPTIONS MININGUSER ggate, MININGPASSWORD ggate

The capture process above was tested using GG 11.2.1.0.1 on an Oracle 11.2.0.3 database.

Advertisements

One thought on “GoldenGate Integrated Capture

Leave a 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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s