Nick,
Thanks for the notes.
I've often wondered how Shareplex
did its thing.
Just for kicks - have you tried writing
a collision handler for streams ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon
Title: RE: quest SharePlex
Would the same thing work if you shut down the
Shareplex processes after the row had chained,
and restarted them before you updated the chained
piece ?
-- Yes
And does Shareplex guarantee that it will
never report a 1555 error regardless of how long it
is shut
Very cute - this tends to suggest that Shareplex is
spotting the appearance of chains in the log and
storing the list of rowids.
Would the same thing work if you shut down the
Shareplex processes after the row had chained,
and restarted them before you updated the chained
piece ? And does Sharep
Title: RE: quest SharePlex
This is actually part of the 'magic' of SharePlex. The way we obtain the PK information from the database if the PK was not modified is very tricky.
I can tell you some of the 'magic' but not all of it. (NDA type stuff)
In all updates t
Title: RE: quest shareplex
Has anyone used Oracle Streams for simple "A" to "B" replication? Likes/dislikes? Can it be used in 8.1.7?
Thanx,
Alan Martin
Defense Logistics Information Service
[EMAIL PROTECTED]
-Original Message-
From: Khedr, Waleed [mailto:[EM
Hi,
I have used Shareplex for a number of years now, albeit with a
relatively simple configuration (bi-directional master-to-master
replication across a WAN). We had a few teething problems with
earlier versions of the software, but since our last upgrade about
18months ago, we have had no proble
Thanks for the reply.
That covers the object/data_object id problem, and gives
the ability to identify which columns in the dump are the
primary key columns.
But when you update a row, the redo will only contain the
primary key if the primary key has been modified, so you
should hardly ever find
Title: RE: quest SharePlex
You provide a 'configuration file' which is just a flat file of table names on the source machine and table names on the target machine. Then we go through an activation process that takes the table name on the source and grabs the object id from Orac
I'm sure you know Oracle has a new product "Oracle Streams" that does the
same:
http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/server
.920/a96571/strmover.htm#43906
Waleed
-Original Message-
Sent: Friday, January 17, 2003 11:14 AM
To: Multiple recipients of list OR
Since the redo log contains only details about
object id, row location, and changed values , how
do you derive a table-name and key value for
the SQL to be applied ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://ww
Title: RE: quest shareplex
I was going to keep quite... but here goes. :)
-
Yes, of course I'll be glad to help.
Basically...
Log Based replication for Oracle. A capture process continually reads the online redo logs and p
Title: RE: quest shareplex
It allows for master to master replication. My understanding is that Oracle's Data Guard now does the same thing. Shareplex was faster then replication with less latency because it would read from the online redo files from Oracle. I understand that Data
Quest Shareplex is a replication software.
Nick Wagner from Quest is on this list and he is been very helpful
and I am sure he will be glad to provide you info on it. Right Nick? :)
-Original Message-
Sent: Friday, January 17, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
I
I'm working with a couple of IBM gals(don't you all get offended) who
are asking about shareplex, i've not used it and have no idea whether
its good or not(or for that matter what its purpose is).
Anyone enlighten me.
thanks, joe
Joseph S Testa
Chief Technology Officer
Data Management Consul
Thanks Raj, had a laugh over that one. My instant reaction is that the sales
rep sensed that there wasn't going to be a pot of gold at the end of that
rainbow and decided to donate his problem to his competitor.
Seriously, I've found that replication is one of those things that looks
better the
Title: RE: Experience with Quest Shareplex
Unfortunately this was from vendor's sales rep.
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
personal and do
Title: RE: Experience with Quest Shareplex
From
indirect experience it is another layer of administration and requires some
manually steps depending on the configuration of your database/system.
Again, for that reason might want to consider Oracle's similar product that way
you won&
I did some investigation into SharePlex a few years ago. I tried for months
to get someone to respond to email and voicemail messages to the vendor that
"I want to buy SharePlex and I have the money". Eventually I got the
software for evaluation. I found once again that replication isn't easy,
Title: RE: Experience with Quest Shareplex
Last I heard about shareplex that it still had some problems with IOTs
and user defined types ... they seems to be working on those though
...
Raj
__
Rajendra
Jamadagni
MIS, ESPN
Title: RE: Experience with Quest Shareplex
Hasn't Oracle basically built-in this same functionality in a current version of the RDBMS - wouldn't you want to check that out first? - Just a thought.
-Original Message-
From: Schauss, Peter [mailto:[EMAIL PROTECTED]]
Se
Does anyone have experience with a product called Shareplex
by Quest Software. We have some remote access performance
issues and my management is looking at this product
as a possible solution for a distributed database.
thanks,
Peter Schauss
Northrop Grumman Corporation
[EMAIL PROTECTED]
--
Ple
Hi,
I changed the Subject to SHAREPLEX, lets close out the contention thread.
Could be why there are no responses. A couple people on the list definitely use it
and I know I certaintly will have a lot to say about it but have to do it later as I
am working on Prod issues right now.
Title: REPLICATION: Quest Shareplex
Hi,
I changed the Subject to SHAREPLEX, lets close out the contention thread. Could be why there are no responses. A couple people on the list definitely use it and I know I certaintly will have a lot to say about it but have to do it later as
Last Revision Date: 17-FEB-2000
Language: USAENG
PURPOSE
---
To explain why any extraction of data from redo logs is not supported.
SCOPE & APPLICATION
---
Customers who are considering using Quest SharePlex for disaster
recovery.
Extracting Data from Red
made it in there or not. Perhaps someone else knows
> about this.
>
> Marc Perkowitz
> Senior Consultant
> TWJ Consulting, LLP
>
> 847-256-8866 x15
> www.twjconsulting.com
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
&g
Title: RE: Your views on Quest - Shareplex
>-Original Message-
>From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
>
>The person giving the presentation on Shareplex
>stated that there could be no chained rows when the sharepex file,
> apparently analogous to the lo
ssage
to: [EMAIL PROTECTED] (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).
RE: Your views on Que
ication tool we
chose would be fast enough to keep up with the large data loads. When we
tested Oracle Replication and Quest Shareplex, we found that Shareplex was
significantly faster. I personally argued against it initially for some of
the reasons posters here have mentioned (e.g. it uses &quo
Title: RE: Your views on Quest - Shareplex - Thank you all
If anyone wants to learn more about SharePlex for Oracle by Quest Software, I will be hosting an interactive conference call next Wednesday. This technical presentation describes SharePlex and how it offers live, up-to-the-minute
Thank you all for giving your time to express your opinions. I would be
consolidating all the opinions I received in the list and send a mail within
the next two days. I hope, this consolidation would help for any future
queries on this subject.
Thanks,
Rao
[EMAIL PROTECTED]
--
Please see t
cords) every night, but especially at the end of each
quarter
> and at the end of the year. We wanted to ensure that the replication tool
we
> chose would be fast enough to keep up with the large data loads. When we
> tested Oracle Replication and Quest Shareplex, we found that Share
Title: RE: Your views on Quest - Shareplex
The
person giving the presentation on Shareplex stated that there could
be no chained rows when the sharepex file, apparently analogous to the log miner
dictionary file is created.
-Original Message-From: Jacques Kilchoer
[mailto
Title: RE: Your views on Quest - Shareplex
> -Original Message-
> From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
>
> We are looking into the product as well, but have yet to even
> toy with the product. There is a "no chained rows"
> restricti
RACLE-L <[EMAIL PROTECTED]>
>Subject: Re:Your views on Quest - Shareplex
>Date: Tue, 29 May 2001 13:06:11 -0800
>
>Rachel,
>
>Sorry for the confusion - I meant that my sales rep got Eyal to reply to
>this, and then sent me the informative email. I did not, however, know
&
We are looking into the product as well, but have yet to even toy with the product.
There is a "no chained rows" restriction. Shareplex does not replicate transactions
on sys objects. A table dropped on one side will not be dropped on the other. It
apparently will replicate truncates howev
Title: RE: Your views on Quest - Shareplex
Our production runs
on a multi-threaded app.
And, it is the Single
threaded nature of Shareplex with the LONG columns in the db that
did
not make it suitable for
us. Shareplex just could not catch up with the DML activity in our
Production
ra" wrote:
>
> List,
>
> My company is considering Quest - Shareplex.
>
> We are considering to use this in our dataware house. Basically, this will
> pull all the transactions from OLTP database and populate staging area in
> the dataware house.
>
> Could you ple
Title: RE: Your views on Quest - Shareplex
>-Original Message-
>From: Brian MacLean [mailto:[EMAIL PROTECTED]]
>As of a year ago it was single threaded
>and didn't handle long columns.
I talked to one of the SharePlex developers.
a) Shareplex has handled long co
SCOPE & APPLICATION
---
Customers who are considering using Quest SharePlex for disaster
recovery.
Extracting Data from Redo Logs Is Not A Supported Interface
------
Quest SharePlex for Oracle replicates data to one or more othe
erface
> Type:
> BULLETIN
> Status:
> PUBLISHED
>
> Content Type: TEXT/PLAIN
> Creation Date: 22-JAN-2000
> Last Revision Date: 17-FEB-2000
> Language: USAENG
>
> PURPOSE
> ---
>
> To explain why any extraction of data from
I guess it is in the LOGICALLY. Standby databases are maintained as
asynchronous physical copies - which is why they can at best be opened
read-only. Typical technical doc obfuscation :-).
Jim Hawkins wrote:
>
> Jared,
>
> That's a really good question! I don't know the answer...
>
> Sorry,
---
To explain why any extraction of data from redo logs is not supported.
SCOPE & APPLICATION
---
Customers who are considering using Quest SharePlex for disaster
recovery.
Extracting Data from Redo Logs Is
e
source.
> He's brilliant.
>
> Rachel
>
>
> >From: "Jim Hawkins" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re:Your views on Quest - Shareplex
Standby database? How do you recover a DB using archived redo logs?
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Tuesday, May 29, 2001 14:41
To: Multiple recipients of lis
Jared,
That's a really good question! I don't know the answer...
Sorry,
Jim
> On Tuesday 29 May 2001 12:01, Jim Hawkins wrote:
>
> From note on MetaLink:
>
> >
> >1) There is not sufficient information in the logs to logically
> >replicate transactions, so the data applied to the de
Jared,
That's a really good question! I don't know the answer...
Sorry,
Jim
> On Tuesday 29 May 2001 12:01, Jim Hawkins wrote:
>
> From note on MetaLink:
>
> >
> >1) There is not sufficient information in the logs to logically
> >replicate transactions, so the data applied to the de
Here's a theory: Eyal is referring to chained and migrated rows. With media
recovery, the recovering instance infers where the migrated or chained data is
located, becuase it is an exact physical copy. Since the SharePlex replicated
instance is not an exact physical copy of the primary, it must
ist ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 12:16 PM
> List,
>
> My company is considering Quest - Shareplex.
>
> We are considering to use this in our dataware house. Basically, this
will
> pull all the transactions from OLTP database and popula
It is most assuredly true!
An interesting aside: A local recruiter recently told me that Dan Hotka,
who is from near here and sometimes presents at our local user group
meetings, was a local Quest "sales rep"! [Methinks recruiters are almost
universally clueless. These kinds of statements go a
rilliant.
Rachel
>From: "Jim Hawkins" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re:Your views on Quest - Shareplex
>Date: Tue, 29 May 2001 11:01:21 -0800
>
>All,
>
>We
On Tuesday 29 May 2001 12:01, Jim Hawkins wrote:
>From note on MetaLink:
>
>1) There is not sufficient information in the logs to logically
>replicate transactions, so the data applied to the destination system
>may be different from the primary, and therefore inaccurate.
So how doe
Title: RE: Your views on Quest - Shareplex
As of a year ago it was single threaded and didn't handle long columns.
-Original Message-
From: Rao, Maheswara [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 10:17 AM
To: Multiple recipients of list ORACLE-L
Subject: Your vie
Last Revision Date: 17-FEB-2000
Language: USAENG
PURPOSE
---
To explain why any extraction of data from redo logs is not supported.
SCOPE & APPLICATION
---
Customers who are considering using Quest SharePlex for disaster
recovery.
Extracting Data from Redo Logs
D] 05/29/01 01:16PM >>>
List,
My company is considering Quest - Shareplex.
We are considering to use this in our dataware house. Basically, this will
pull all the transactions from OLTP database and populate staging area in
the dataware house.
Could you please give your experiences a
> Author: "Rao; Maheswara" <[EMAIL PROTECTED]>
> Date: 5/29/2001 9:16 AM
>
> List,
>
> My company is considering Quest - Shareplex.
>
> We are considering to use this in our dataware house. Basically, this will
> pull all the transacti
Reply Separator
Author: "Rao; Maheswara" <[EMAIL PROTECTED]>
Date: 5/29/2001 9:16 AM
List,
My company is considering Quest - Shareplex.
We are considering to use this in our dataware house. Basically, this will
pull all the transaction
List,
My company is considering Quest - Shareplex.
We are considering to use this in our dataware house. Basically, this will
pull all the transactions from OLTP database and populate staging area in
the dataware house.
Could you please give your experiences and the pros and cons of this
57 matches
Mail list logo