GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Downstream Mining for multiple oracle db in real-time using Integrated Capture

edited Sep 6, 2023 7:57AM in GoldenGate, Streams and Distributed Database (MOSC) Question

Oracle Database 19.16 on HPUX  B.11.31 U ia64

Scenario: One of my critical system includes two databases. One of them is 52Tb, second one is 2Tb. We are planning to migrate them to a different platform (HPUX big to X86 little) with near zero downtime without running any OGG process on legacy source server.

I have couple of queries to start evaluating the possibilities of using OGG.

Q1. Is it possible to configure OGG Downstream mining server for capturing transactions from multiple sources (Oracle DBs) in real-time using Integrated Extract?

Each Oracle DB will have its own IE.

Q2. Is it possible to use many IE in above setup for one source DB (52Tb) to distributes tables with heavy DML/modules.

Tagged:

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center