GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

GoldenGate: multiple replicate reading same trail file

edited Oct 7, 2019 4:19PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered ✓

Hi,

I have a question about having multiple GoldenGate instance reading the same trail file.

Setup: I have 2 GoldenGate instance

~/ogg_1, port 7809: GoldenGate for Oracle

~/ogg_2, port 27809: GoldenGate for BigData

Assume the source is Oracle Database, sid=boston

Assume I have 2 target database, sid=london, sid=tokyo

Assume I have 1 target big data instance, (say kafka)

I am replicating HR schema.

Is the following valid configuration?

Configuration 1: 1 extract, 1 trail and 2 replicate process reading the same trail file.

EXT_BOS, with TABLE hr.*; (local trail file under ~/ogg_1/dirdat/bo)

REP_LO: dblogin gg_london (trail file ~/ogg_1/dirdat/bo)

REP_TK: dblogin gg_tokyo. (trail file ~/ogg_1/dirdat/bo)

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