DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Oralce Replication Manager vs. SharePlex

  1. #1
    Join Date
    Feb 2003
    Location
    New York
    Posts
    75

    Oralce Replication Manager vs. SharePlex

    Hi, gurus
    Has anyone ever used Quest replication tool, SharePlex? is it reliable comparing to oracle's replication manager? I would appreciate if anyone could shed some lights on this. Thanks.
    P.S. we are curently evaluating which tool to go with.

    D.F
    Still learning

  2. #2
    Join Date
    Jan 2001
    Posts
    191
    I used shareplex.
    It is stable and reliable to me. It is easy to manage also. Oracle replication need to have primary key in tables to be able to replicate (or at least you have to know what is a primary key). I think oracle replication use internal triggers to replicate tables. Shareplex read the log file to do replication.

    xyz2000

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by xyz2000
    I used shareplex.
    It is stable and reliable to me. It is easy to manage also. Oracle replication need to have primary key in tables to be able to replicate (or at least you have to know what is a primary key). I think oracle replication use internal triggers to replicate tables. Shareplex read the log file to do replication.

    xyz2000
    The mathods SharePlex uses do not give the possibility to replicate several DDL-statements such as droping a table, altering the structure of the database, etc.

    SharePlex is a system for regeneration of SQL-statements.

    Libelle is good.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Jan 2001
    Posts
    191
    I only used snapshot replication for oracle. I don't think it can replicate DDL use snapshot replication. I never set up oracle master replication. so I don't know if oracle can replicate DDL. Can some one tell me if oracle replication can replicate DDL?

    xyz2000

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well at least shareplex is a much superior technology than replication

  6. #6
    Join Date
    Aug 2001
    Posts
    267
    Well Pando please tell us atleast 2 or three big advantages over ORacle replication manager . Really I don't know. In our DBA home room we got a big discussion on this topic. Just trying to understand big advantages of shareplex.
    Raghu

  7. #7
    Join Date
    Jan 2001
    Posts
    191
    When network is down, shareplex will stop some process. when network is up, shareplex will restart that process again. Since it only read the log file, it will have less performance impact on production database. While oracle use internal triggers to do replication, it do slow down production database.
    Why do you need replication? If one of your database is readonly, then, use standby database. I was told in oracle 9i, standby database can open for read and under recover mode at same time, although I never set it up myself. I am still using oracle 8i.

    xyz2000

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width