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
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
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
12 matches
Mail list logo