Home » Server Options » Replication » Two databases in sync
Two databases in sync [message #75202] Sat, 29 June 2002 23:05 Go to next message
Pankaj Mittal
Messages: 1
Registered: June 2002
Junior Member
I need to keep two databases in Sync over a network.
For eg. if a object in one Database gets updated the object in the other DB should get updated instantly. what are the various options available of doing the same? and where can I find more information about them?
Please enlighten.
Re: Two databases in sync [message #75216 is a reply to message #75202] Sun, 21 July 2002 17:32 Go to previous message
David Simpson
Messages: 29
Registered: May 2002
Junior Member
If you are using Enterprise Edition you may consider Oracle's Advanced Replication. Here is a link to a tech note I have written which can provide some ideas to consider when planning Advanced Replication:

http://www.dotcomsolutionsinc.net/support/repgen/repgen_tn_replication_design.html

Here are some scripts which could be helpful to you when setting up replication:
http://www.dotcomsolutionsinc.net/products/repgen/repgen_files.html

One of the critical aspects of replication which is handled by these scripts is the implementation of a robust method of conflict resolution.

Another method to consider is creating a Standby database - which should be done if upon looking at the above tech note you determine that Replication is not appropriate for your installation.
The following list of scripts provides an example of how you can set up a standby database (start with script #77 on this page):

http://www.dotcomsolutionsinc.net/products/installgen/installgen_files_sol901.html

David Simpson
www.dotcomsolutionsinc.net

Previous Topic: Changing Master Definition Site
Next Topic: Replication serving
Goto Forum:
  


Current Time: Thu Jul 16 12:55:58 CDT 2020