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

Thread: 'Shareplex' tool for Oracle high availabiliy

  1. #1
    Join Date
    Feb 2001
    Posts
    17
    Hi folks,

    Has anyone of you worked on an Oracle High availibility tool called 'Shareplex'. This tool has been developed by Quest software.If so, can you please give your feedback ?

    If you are using this tool, can you also tell me whether we can contact Oracle Support for any problems with this product or Quest is the only alternative ?

    One of my clients wants to go in for this product.
    Ramki

  2. #2
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    I haven't used SharePlex, but know about it. Its a good alternative for Adv. Replication. It works based on the same technology, which is reading redo logfiles and applying the changes onto a secondary db. Problems with this product have to be reported to Quest.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by Halo
    I haven't used SharePlex, but know about it. Its a good alternative for Adv. Replication. It works based on the same technology, which is reading redo logfiles and applying the changes onto a secondary db.
    Hm, I know nothing about SharePlex appart from seeing some adds in couple of magazines, but if it is realy based on transfering informations from redo logs from one database to another then you could hardly say it is an alternative for advanced replication, and you could never claim it is based on the same technology as advanced replication. AR has nothing to do with transfering redo logs! Maybe SharePlex could more easily be compared to standby database principle...
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759

    Talking

    Thanx for the correction, that was a typo.

  5. #5
    Join Date
    Feb 2001
    Posts
    17
    Thanks for providing the info.
    Ramki

  6. #6
    Join Date
    Oct 2000
    Posts
    48
    Actually I just attended a Shareplex session at IOUG in Orlando last week and here is what I know. It is similar to a standby database in that it is a form of data replication (as opposed to storage replication like Veritas) but its not the same. It reads the redo logs at the O/S level and translates them to SQL statements then transfers these SQL statements to the target database through TCP/IP (but does not use Sql*Net). So in other words there is no real overhead on the source database because it does not use the source db engine to read the redo logs. It only connects to the source db briefly to read the data dict for object names using the object id from redo. The target database is available throughout this replication process, unless a standby database that is not accessible while in recovery mode. It can also help with backups in that you can shutdown the target database and do a cold backup of it leaving the source db available. Shareplex contends that it can keep up with 3.5G of redo generation an hour and 55G of redo generation a day. Also, Shareplex does support some DDL statements such as truncates and column changes, whereas Standby does not, and it can delay the application of the SQL statements to the target. Shareplex is command line driven and easily scriptable. And it can handle replication between different Oracle versions, nice if you want to upgrade Oracle versions using production data (aka target db) without risking it on the real production database first. And lastly, if there is disk block corruption in the redo log, it is not propogated to the target database.

    I was pretty impressed by the session, however, I hear Shareplex is kind of pricey. We are thinking about going to Shareplex. If anybody else out there uses Shareplex please let us know if it is a good High Availibity option, or if there are any pitfalls to it.

    Thanks.

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