Oracle Replication
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle Replication

  1. #1
    Join Date
    Jan 2001
    Posts
    28

    Smile

    Hi everyone,

    We are looking for a product for Oracle Replication for a very large 7x24 database.

    Can anyone suggest me a good third party tool (Other than Oracle Replication)?

    We are looking at sybase and quest products. If anyone is already using these products or have some other suggestion, please let me know.

    Any information would be greatly appreciated......

    Thanks in advance.

    Padma

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    check out the BMC softwares too.
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Nov 2000
    Posts
    212
    I would doubt if Oracle published its internals for 3'd party vendors to build GOOD replication engine. (If however it is so, I would like to know this API...)

    A while ago I looked through docs about replication engine from Sybase but the documentation was not clear to say least. Nor it was clear how they intefaced Oracle for this task.

    The issue is that to build replication one needs to serialise user transactions, i.e. to use Oracle's serialise transaction mode (this is quite expensive in terms of storage), or need access to some Oracle internals (transaction SCN).

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Instead of replicating the DB at Software level, try to do it at hardware level. Consider Clustering the hardware (CPUs) with good EMC disk arrays.

    The Standby DB or Shareplex from Quest will lead to transaction loss when the primary DB goes down.

  5. #5
    Join Date
    Jan 2001
    Posts
    28
    We talked to Quest about the transaction loss and they are saying that it will be in a queue on the target server if the primary server goes down.

    Can you please tell me more about this?

    Thanks
    Padma

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