Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I need to keep two whole databases constantly synchronized.

That includes:

  • Data (of course)
  • DDL Changes (also changes to stored procedures and pl/sql packages)

All changes need to be propagated back and forth. E.g. changes to one database must be visible in the other database as soon as possible.

The databases are geographically separated by a few thousand miles and the connection between them is quite slow and cannot be made faster.

The size of the databases is maybe 100GB.

Can this be done with Oracle Streams? How would you do it?

share|improve this question
1  
Building a one-way replication system involves quite a lot of work. A two-way replication system is arguably an order of magnitude more complex. Since you're intent on running a two-way replication system, I suggest you start with reading the Advanced Replication doc, particularly the chapter about conflict resolution. Good luck with your project ! – Vincent Malgrat Feb 7 at 15:06

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.