Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Implementing replication in Oracle 10&11 Standard Edition

456140Jul 29 2008 — edited Sep 22 2008
I am implementing an oracle based application which will run under Linux/Oracle 10gr2 standard edition and which will soon be upgraded to Oracle 11g standard edition.

One of the requirements of the application is that a hot standby must be provided. To provide the hot standby, I must implement some sort of replication mechanism, but the nice replication features (data guard, streams, advanced replication, basic replication) are only available with Oracle enterprise edition.

Two questions:

1. It appears that I will be building a home-made replication mechanisms. I am planning on using insert/update/delete triggers and dblinks to trap database updates and propogate them to the standby server. (alternatively, may write them to files as SQL statements and have the second server load the files). Is their a better way to implement replication in Oracle SE. (esp. a feature of Oracle SE that I could be using to do this?).

2. Oracle Advanced and Basic Replication are not shown in the Oracle 11 Editions Description web page which lists the availability of features across the various oracle versions. I assume it is still supported in Oracle 11, but is Oracle Streams now the "best practice" for implementing replication (i.e. instead of advanced replication?)

Thanks in advance,

Werner
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2008
Added on Jul 29 2008
5 comments
1,012 views