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
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
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
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 the redo logs contain
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
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:[EMAIL PROTECTED]]
Sent
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
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
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'm
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 Guard now
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 parses out
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
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
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 Oracle
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]
--
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]]
Sent: Monday
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 Inc.
Rajendra
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
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't get
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 doesn't reflect
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
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 I am
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.
, LLP
847-256-8866 x15
www.twjconsulting.com
- Original Message -
To: Multiple recipients of list 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
: 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 Is Not A Supported Interface
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
restriction.
I'm not sure what that statement
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 unsupported
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
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
large batch
loads (bank records) 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
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 log miner dictionary file
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 transactions from OLTP database and populate staging area
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
Shareplex
,
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
Shareplex
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
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 views
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 does a
: 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 are currently as customer of Quest Software using LiveReorg and
Spotlight. For those who
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
[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 populate staging area in
the dataware house.
Could you
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
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 destination
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 destination
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
: 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 are currently as customer of Quest Software using LiveReorg and
Spotlight
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 Not A Supported Interface
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,
Jim
---
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 Not A Supported Interface
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 columns for as long
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
Shareplex
Title: RE: Your views on Quest - Shareplex
Our productionruns
on amulti-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
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
: 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
that I was getting it from the VP for Technology! I guess I should
53 matches
Mail list logo
