OraFAQ Forum: Replication » Replication solution between two readable/writable databases

Home » Server Options » Replication » Replication solution between two readable/writable databases

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Replication solution between two readable/writable databases [message #672270]

Tue, 09 October 2018 08:46

fabi88
Messages: 112
Registered: November 2011

Senior Member

Hi experts,

What is the best replication solution for two readable/writable databases which should be synchronize. Both databases have same structure and each database has its own users who can write and read .

[Updated on: Tue, 09 October 2018 10:37]

Report message to a moderator

Re: Replication solution between two readable/writable databases [message #672271 is a reply to message #672270]

Tue, 09 October 2018 11:19

Michel Cadot
Messages: 68751
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Oracle version?

Report message to a moderator

Re: Replication solution between two readable/writable databases [message #672283 is a reply to message #672271]

Wed, 10 October 2018 03:24

fabi88
Messages: 112
Registered: November 2011

Senior Member

Quote:

Oracle version?

Oracle Database 12c Release 2( 12.2.0.1.0)

Report message to a moderator

Re: Replication solution between two readable/writable databases [message #672285 is a reply to message #672283]

Wed, 10 October 2018 06:57

John Watson
Messages: 8970
Registered: January 2010
Location: Global Village

Senior Member

This is a horrible problem. Advanced Replication is desupported in 12.2, Streams will be desupported in release 19 (so about 15 months time). That means your only Oracle provided product with a future is GoldenGate, with its massive overheads and licensing implications. There is the DBvisit Replicate product, which they say will be desupported in three years.

So you have to plan in terms of how long you will need this full duplex replication. If only a year or two, Streams will be fine.

Report message to a moderator

Re: Replication solution between two readable/writable databases [message #672301 is a reply to message #672285]

Wed, 10 October 2018 11:32

fabi88
Messages: 112
Registered: November 2011

Senior Member

Quote:

So you have to plan in terms of how long you will need this full duplex replication. If only a year or two, Streams will be fine.

Thank you so much for your very useful advise. So I think we should find a custom solution and strategy in application layer for sync two database.

[Updated on: Wed, 10 October 2018 11:33]

Report message to a moderator

Previous Topic:	Replication using Oracle GoldenGate.
Next Topic:	Understanding MV refresh concept

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 13 20:24:06 CDT 2025