GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Replicat cannot adapt to data schema change in real-time?

edited Jun 14, 2019 5:00AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hi,

We're trying this scenario in GoldenGate replication. The scenario should be common during service upgrade.

Site A and Site B are two replicated sites. Site A is the active side, that is, data is replicated from A to B.

Site B is upgraded first. So there may be new columns added or old columns dropped to its data schema.

And later, there may be a switch-over happened, to make site B active, and data should be replication from B to A.

On all above scenarios, there will be data replication between two different data schemas which have different number of columns.

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