Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Streams vs Advanced Replication
Dave,
We have both Streams and Adv. replication implemented, each has its own iss=
ues.
Recently we implemented Quest Shareplex too (just for migration purpose)
Ask yourself these questions before you decide between these two.
1)What kind of replication you are taking about?=20
Uni-directional or Bi-directional
Synchronous or Asynchronous
2) Do you update the same data in more than one database? hot-hot or hot-warm(like primary and DR site kind of)
3)What is the Oracle version you will be using to implement this solution? I heard 10g streams are much better compare to 9i. We do have some issues with 9i streams (like runaway process,etc where the capture process is running)
4) Are you going to implement this in clustered environment? If you are using 9i streams, it cannot mine redo logs. It can mine only archive redo logs.
5)How ofter you will be making structural changes to replicated objects? If you are using OAR, you have quiesce the database group where you are making structural changes. All the replication sites are NOT available for DML changes for that replication group.
Regards,
Sami
On 5/20/05, David Turner <dnt9000_at_yahoo.com> wrote:
> I'm working on a project that will use Oracle with
> some type of replication, either at the application
> layer, using advanced rep, or Oracle Streams.
>=20
-- http://www.freelists.org/webpage/oracle-lReceived on Sun May 22 2005 - 22:55:37 CDT
![]() |
![]() |