Home > IT Answers > Oracle > Database Replication
Help

Question

  Asked: Jul 20 2004   3:01 AM GMT
  Asked by: Mysterky

Database Replication


Oracle, Oracle 8i, Oracle 9i, Architecture/Design, Installation/Upgrade, Development, SQL

Hello,

i have to set up an Database Replication for both read and write access to a tables data from anywhere. Who knows a good description with an example for the set up and administration?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jul 20 2004  10:02 AM GMT  by jkstill




First off, I am not an expert on replication.

That said, I do know enough to realize that your requirements as rather vague.

You want to setup Oracle Advanced Replication, which by all accounts is a formidable task for the uninitiated. Not included are any response time requirements, or descriptions of the network over which replication will be running.

I suggest the following:

* Get a decent book on the subject:

http://www.amazon.com/exec/obidos/ASIN/0972751335

* Setup test systems to understand how it all works

* Hire a consultant with Oracle Adv. Rep experience to
help you build a replication architecture.

my $0.02 worth.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Oracle and Development.

Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Hurmavi  |   Jul 21 2004  2:34AM GMT

Yes!
In our company we tried to build a system with WORKING two way replication about 3 years ago. It was so error prone, that it’s now converted back to a single database model.
Probably one way replication is however easier to implement.

But education, good book and/or lot of consulting are mandatory.

Cheers, Bill

 

Smeagol  |   Jul 21 2004  4:17PM GMT

Hi,

I’m not a rep expert, but have used it at a couple of sites. I have to agree with your first answerer that your requirements are rather vague. Are you talking Oracle, SQL Server or some other database? I can give you some pointers:

1. A good book for Oracle is the O’Reilley “Oracle Distributed Systems” by Charles Dye. A bit on the old side now because it covers Oracle 7 and 8i (I’m using rep on 8i).
2. Oracle training do a good replication admin course.
3.

 

Smeagol  |   Jul 21 2004  4:17PM GMT

Hi,

I’m not a rep expert, but have used it at a couple of sites. I have to agree with your first answerer that your requirements are rather vague. Are you talking Oracle, SQL Server or some other database? I can give you some pointers:

1. A good book for Oracle is the O’Reilley “Oracle Distributed Systems” by Charles Dye. A bit on the old side now because it covers Oracle 7 and 8i (I’m using rep on 8i).
2. Oracle training do a good replication admin course.
3.

 

Smeagol  |   Jul 21 2004  4:17PM GMT

Hi,

I’m not a rep expert, but have used it at a couple of sites. I have to agree with your first answerer that your requirements are rather vague. Are you talking Oracle, SQL Server or some other database? I can give you some pointers:

1. A good book for Oracle is the O’Reilley “Oracle Distributed Systems” by Charles Dye. A bit on the old side now because it covers Oracle 7 and 8i (I’m using rep on 8i).
2. Oracle training do a good replication admin course.
3.

 

Smeagol  |   Jul 21 2004  4:17PM GMT

Hi,

I’m not a rep expert, but have used it at a couple of sites. I have to agree with your first answerer that your requirements are rather vague. Are you talking Oracle, SQL Server or some other database? I can give you some pointers:

1. A good book for Oracle is the O’Reilley “Oracle Distributed Systems” by Charles Dye. A bit on the old side now because it covers Oracle 7 and 8i (I’m using rep on 8i).
2. Oracle training do a good replication admin course.
3.

 

Smeagol  |   Jul 21 2004  6:44PM GMT

Apologies to anyone who is feeling spammed by my previous attempt to answer the question; I have no idea how 6 imcomplete messages were sent!

To continue:

If you are doing 2-way rep, you must work with the application developers; the app needs to be aware where each data update originated, and also needs to be aware that data clashes can occur. In my experience, getting the mechanics of bidirectional rep working are not too bad, but you do need to put a lot of effort into designing how the application will work with it.

You don’t say which release of Oracle you are using, but if 9i or higher, take a look at Streams, which will supercede Advanced Replication. I have no experience of Streams, just came across it on Metalink one day.