Database Replication

pts.
Tags:
Architecture/Design
Development
Installation/Upgrade
Oracle
Oracle 8i
Oracle 9i
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Hurmavi
    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
    0 pointsBadges:
    report
  • Smeagol
    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.
    0 pointsBadges:
    report
  • Smeagol
    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.
    0 pointsBadges:
    report
  • Smeagol
    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.
    0 pointsBadges:
    report
  • Smeagol
    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.
    0 pointsBadges:
    report
  • Smeagol
    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.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following