Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SharePlex info
MessageOk, in this case Shareplex might be better, if it is able to extract only relevant data from logs.
Actually, you could do somewhat similar yourself using logminer as well. You just extract all needed DML statements on either production or staging server, compress the output (because file with sql statements is going to be big but will compress well) and send over network, or go with Oracle Streams right away. There's going to be an issue with some special datatypes though IIRC.
I don't know the pricing of shareplex, maybe it'd be easier going with it..
Tanel.
Tanel,
That's nice trick, thanks a lot.
In this case whole redo steam must be passed over the network anyway. 5 MB/sec over WAN. So we'are doing research if we could same some bandwidth.
Vadim
-----Original Message-----
From: Tanel Poder [mailto:tanel.poder.003_at_mail.ee]
Sent: Thursday, August 21, 2003 5:14 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: SharePlex info
Hi!
Btw, you can physically replicate 50% of your tables with regular standby mechanisms as well. You just take the files belonging to non-needed tablespaces offline and standby recovers only the required part. You just have to arrange your tables to right tablespaces and spend your money elsewhere.
Physical standby and shareplex can operate on archivelogs, thus they can do their jobs without any additional burden to source database CPU, since you generate and archive your logs anyway. You can do archivelog's processing on target or some staging server.
Tanel.
Hi All,
I'm trying to find some technical details about SharePlex, that is:
Any opinion or pointer to any benchmark is highly appreciated.
Thanks a lot Vadim
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: tanel.poder.003_at_mail.ee Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Aug 21 2003 - 18:19:25 CDT
![]() |
![]() |