Home » Server Options » Replication » Bi-Directional Replication through Golden Gate (Oracle 10.2.0.4.0, Centos 4.5)
Bi-Directional Replication through Golden Gate [message #472599] Sun, 22 August 2010 23:46 Go to next message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

Hi,
For using replication in our production, here i am testing golden gate as replication tool. I tested all scenario in Uni direction ( source to destination). Now have to test replication with DDL support in Bi-Direction. Not getting any Doc for doing replication in Bi-direction( Two Way). If any one has done the same, then please share limitation of replication in Bi-direction through Golden Gate if possible please share config File too.

Regds
Rajnish
Re: Bi-Directional Replication through Golden Gate [message #472721 is a reply to message #472599] Mon, 23 August 2010 08:38 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Advanced Replication

Babu
Re: Bi-Directional Replication through Golden Gate [message #472739 is a reply to message #472721] Mon, 23 August 2010 09:29 Go to previous messageGo to next message
Michel Cadot
Messages: 67132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How this documentation on Oracle rdbms replication will help to answer a question about Golden Gate?

Regards
Michel
Re: Bi-Directional Replication through Golden Gate [message #472741 is a reply to message #472599] Mon, 23 August 2010 09:31 Go to previous messageGo to next message
Michel Cadot
Messages: 67132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know the answer but maybe the following starting page about Golden Gate on OTN will lead you to it:
http://www.oracle.com/technetwork/middleware/goldengate/overview/index-086263.html

Regards
Michel
Re: Bi-Directional Replication through Golden Gate [message #473117 is a reply to message #472599] Thu, 26 August 2010 02:15 Go to previous messageGo to next message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

Hi Friends

I got the limitation of Bi-directional from oracle GG Admin Doc.
If any one want i can share with them. Brief

1. DDL not supported
2. Oracle commercially not supported Bi-directional


Regds
rajnish
Re: Bi-Directional Replication through Golden Gate [message #473118 is a reply to message #472739] Thu, 26 August 2010 02:18 Go to previous messageGo to next message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

Actually doing setup Bi-directional and was looking, Is we can avail all features as single side replication in Bi-directional.

Regds
rajnish
Re: Bi-Directional Replication through Golden Gate [message #473123 is a reply to message #473117] Thu, 26 August 2010 02:44 Go to previous messageGo to next message
Michel Cadot
Messages: 67132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Re: Bi-Directional Replication through Golden Gate [message #473371 is a reply to message #473117] Fri, 27 August 2010 10:49 Go to previous message
sovekconsulting
Messages: 9
Registered: June 2010
Location: Canada
Junior Member
[quote title=kumarrajnishgupta wrote on Thu, 26 August 2010 2. Oracle commercially not supported Bi-directional
[/quote]

possible conflicts with bi-directional replication (if you cross replicate same tables) can not be resolved by jut GG, it should be done on application level.

It might be a reason for not supporting bi-directional replication.

Regards,
SK
Previous Topic: cannot fast refresh turncated MV even after complete refresh
Next Topic: refresh_snapshot and ORA-00942: table or view does not exist
Goto Forum:
  


Current Time: Tue May 26 13:38:11 CDT 2020