GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

OGG Extract not processing recordsin RAC DB

edited Dec 27, 2018 2:54PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered

Hi,

We have configured OGG uni-directional replication from RAC db to Standalone DB.

Here are the details.

Source DB : 2-Node RAC(11.2.0.4) on OEL

Target DB : Standalone DB(11.2.0.4) on AIX.

Source DB installation's :
Grid : grid (unix user)

RDBMS & OGG : oracle(unix user).

I am configuring my GG extract and pump process as below.

##Extract parameter file

EXTRACT RACEXT

EXTTRAIL ./dirdat/re

USERID GGADMIN@pmgdev , PASSWORD xxxxxx

#TRANLOGOPTIONS ASMUSER sys@ASM1, ASMPASSWORD xxxxxxx

TRANLOGOPTIONS DBLOGREADER

DDL INCLUDE MAPPED

DDLOPTIONS ADDTRANDATA

GETENV (ORACLE_HOME)

GETENV (ORACLE_SID)

TABLEEXCLUDE SCOTT.DBMS_TABCOMP_TEMP_UNCMP

TABLEEXCLUDE SCOTT.DBMS_TABCOMP_TEMP_CMP

TABLE SCOTT.*;

##Pump Parameter file

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center