- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 9:34 AM
You know, from a logistics perspective I'm interested in something here
that
maybe those that use SharePlex can cast some light on.
The only Oracle supported
The semi official shtick from Quest is that Oracle changes the log file
format rarely because the change ripples through much of the rest of the
server code. Log file format affects archiving and recovery at a pretty
basic level.
As a financials shop, I don't worry too much about keeping up with
Please bear in mind that there is one thing in a datatype being supported and another
in all functions and features of Shareplex being usable when that datatype is involved.
I am thinking about datatype long specifically.
We have been replicating a 8i database (tru64) to a 9i one (sun)using
We are working on a SharePlex project here although we are still in
test/pilot phases. We are in an apps 11i environment with an 8.1.7.4
database. So far, we have found that index organized tables are not
supported. In addition, in financials, there is a table named
hz_locations that has a UDT
This isn't a direct answer to your question, but make sure you test
logical standby thoroughly--I had to abandon the idea of using it due
to serious bugs in the apply process, and due to seriously poor
performance of the apply process.
--- elain he [EMAIL PROTECTED] wrote:
Hi,
We are
That goes for Shareplex too (sorry to state the obvious). I've been
seriously bitten in recent weeks by problems with their stuff too.
_
Tim Onions
Head of Oracle Development
Speech Machines (A MedQuist Company)
...the speech-to-data Application Service Provider
You know, from a logistics perspective I'm interested in something here that
maybe those that use SharePlex can cast some light on.
The only Oracle supported mechanism for mining the redo logs is LogMiner,
yes? Now, given that we can change the format of the redo logs from release
to release
recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: shareplex: datatype unsupported
Date: Wed, 05 Nov 2003 15:34:25 -0800
You know, from a logistics perspective I'm interested in something here
that
maybe those that use SharePlex can cast some light on.
The only Oracle supported mechanism
-From: Gorbounov,Vadim
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21,
2003 5:01 PMTo: Aponte, TonySubject: RE: SharePlex
info
Tony,
My
question was inspired by belief that SharePlex does log mining on the source
DB and hence do not send unnecessary
NT.
T¬-Original
Message-From: Yechiel Adar
[mailto:[EMAIL PROTECTED]Sent: 25 August 2003 09:10To:
Multiple recipients of list ORACLE-LSubject: Re: SharePlex
info
Sorry about the late reply but (if I remember
correctly from my research about one year ago) Shareplex does something lik
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 5:44
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SharePlex info
Your
bandwidth requirements will be the rate of changes to the actual data.
The traffic consists of the actual data and control information needed to
1)You would need lessnetwork bandwidth with shareplex than you would for transporting archive logs. about 1/3 rd ofwhat you would need for physical stdby.
2) CPU burden would be 'little' I guess.
3) Shareplex replication allows you to have the table available for read on the target. (even
Title: Message
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
Thank
you, Raju. Very helpful
-Original Message-From: raju pa
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 4:59
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
SharePlex info
1)You would need lessnetwork bandwidth with shareplex than
you would
Title: Message
Your
bandwidth requirements will be the rate of changes to the actual data. The
traffic consists of the actual data and control information needed to reassemble
the transaction on the target. The source database's other redo payload
(i.e., index operations, rollback segment
: Thursday, August 21, 2003 5:14
PMTo: Multiple recipients of list ORACLE-LSubject: 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
But you would be wanting to transfer *full*
logfiles away from your production servers anyway at least if your data is
worth something...
Tanel.
1)You would need lessnetwork bandwidth with shareplex than
you would for transporting archive logs. about 1/3 rd ofwhat you
.
- Original Message -
From:
Gorbounov,Vadim
To: Multiple recipients of list ORACLE-L
Sent: Friday, August 22, 2003 12:54
AM
Subject: RE: SharePlex info
Tanel,
That's nice trick, thanks a lot.
In
this casewhole redo steam must be passed over the network anyway. 5
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:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: Re: SharePle
: Friday, August 22, 2003 2:14
AM
Subject: RE: SharePlex info
Yes. A nice neat trick indeed. Has anyone tried this?
About your redo generation : 5MB/sec - 18000 MB/hour ==
18GB
IT is indeed huge. IS this peak or average? Good luck.
"Gorbounov,Vadim" [EMAIL
On 2003.08.09 17:14, Indy Johal wrote:
As Nelson is not in Oracle 9i, And so the option availbale with him are
Who or what is Nelson? There was a guy named Horatio Nelson who died at
Trafalgar after tasting too much of French food and was widely followed
by the paparazzi of the time because of his
Actually, I suspect I will be able to do the testing myself before I get more back
from those guys.
Matthew Zito made a good point in another reply to this message saying that 32 bit
addresses had to be translated to 64 bit addresses because of architecture
requirements so you would still
.
Allan
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 3:30
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SharePlex Summary
No
penalty. HP-UX is 64-bit os running on a 64-bit chip. Why would 64 bits impose
any
[EMAIL PROTECTED]http://www.prnewswire.com(201) 946-5687 [W](201) 400-3960 [M]We tell your story to the world.Tanel Poder [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]08/09/2003 05:59 PM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: bcc: Subject: Re
-Original Message-From: Nelson, Allan
[mailto:[EMAIL PROTECTED]Sent: Friday, August 08, 2003 3:44
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SharePlex
We are
not running 9i but 8.1.7.4, sorry for not including that earlier. We
are rolling out to our international offices
Title: Message
No
penalty. HP-UX is 64-bit os running on a 64-bit chip. Why would 64 bits impose
any
penalty? Running 64 bits is what comes naturally. Running 64 bits means
that sizeof(void *) will return 8 instead of 4.
That,
in turn, means that SGA can grow much bigger because you don't
Frankly, that does not sound logical to me, but I would be extremely
interested if there is any authenticity to the statement.
I would ask the individual who made the statement to provide the proof. I
can't stop envisioning this on the next myth list.
PST
Please respond to
Title: SharePlex
Nelson,
SharePlex does the same basic thing that Oracle does for
the logical standby, as a matter of fact if your running 9i why not use that
instead of Quests's pricey tool? I don't believe there is any additional
cost to using logical standby over the second server
Allan
As to your Shareplex comments, I'm in no position to support or refute
your conclusions. My admittedly brief experience with replication leads me
to the conclusion that there are no simple conclusions. If ever there was an
area where your mileage may vary, this is it. Replication is a
PROTECTED]Sent by: [EMAIL PROTECTED]08/09/2003 05:34 PM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: bcc: Subject: Re: SharePlex On 2003.08.09 17:14, Indy Johal wrote: As Nelson is not in Oracle 9i, And so the option availbale with him areWho
]We tell your story to the world.Tanel Poder [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]08/09/2003 03:09 PM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: bcc: Subject: Re: SharePlex Hi! If the Load is not high on the Production server and what I meant
Hi!
If the Load is not high on the Production server and what
I meant by load is the Transaction Load. As it Financial
system , so it all depend on the Modules
More like on number users and their activities..
-- Physical Standby databse - This option is good
* If there is not much load
8, 2003 5:59 PMTo:
Multiple recipients of list ORACLE-LSubject: RE:
SharePlex
Nelson,
SharePlex does the same basic thing that Oracle does for
the logical standby, as a matter of fact if your running 9i why not use that
instead of Quests's pricey tool? I don't believe there is a
Title: SharePlex Summary
Allan,
We use HP-UX 11.o 11i with 817 9i. No
difference that I've noticed. Actually 9i seems to perform
better.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Nelson, Allan
[mailto:[EMAIL PROTECTED]Sent: Tuesday,
Title: Message
Cool,
I'll give 9i a try on HPUX.
-Original Message-From: Goulet, Dick
[mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:19
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
SharePlex Summary
Allan,
We use HP-UX 11.o 11i with 817
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Nelson, AllanSent: Tuesday, August 12, 2003 4:44
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SharePlex Summary
Yes
we are PA risc rather than Itanic. The analysis I heard was the 64 bits
(8
Is your first sentence a bit of an understatement Nick ? If so I suppose you can call
your points 'leading' questions like lawyers use to trap a defendant
We use Shareplex and I have seen some of your posts on the subject (and still have
them in my saved box)
John
-Original Message-
Ha, been there done that
Not an uncommon event as I understand it.
John
-Original Message-
Sent: 09 August 2003 23:59
To: Multiple recipients of list ORACLE-L
I'll add one to the list:
nnn) How much downtime and DBA time is required when the Shareplex replication queues
get
Hi!
--- I don't meant to say Logical standby here as
Logical Standby databasse can never be Realtime as they work like streams in
Asynchronous manner. THe only option available fo Synchronous data movement is
with Oracle advance replication or Physical standby Database where it can
. They will be on Linux next
month.
Allan
-Original Message-From: Goulet, Dick
[mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 4:59
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SharePlex
Nelson,
SharePlex does the same basic thing that Oracle does
On 2003.08.09 17:14, Indy Johal wrote:
As Nelson is not in Oracle 9i, And so the option availbale with him are
Who or what is Nelson? There was a guy named Horatio Nelson who died at
Trafalgar after tasting too much of French food and was widely followed
by the paparazzi of the time
PROTECTED] cc: bcc: Subject: RE: SharePlex Actually, logical standby database does have a hidden cost because you need Data Guard which is licensedseparately. The product that mimics SharePlex is called Oracle Streams and it is a redo log based replicationtool, sort of Logminer on steroids. By the way
On 2003.08.09 09:39, Tanel Poder wrote:
MessageHi!
Mladen, does DG really have additional fee when using EE? I tried to check
from oraclestore, but got - instead:
Tanel, my @#$%! Adelphia Cable connection is down more or less throughout the
day today, so I cannot check at the Oracle Store, but
:[EMAIL PROTECTED]Sent: 09 August 2003
00:04To: Multiple recipients of list ORACLE-LSubject: RE:
SharePlex
I
know a little of their product... but I think you should be well
aware of the limitations before attempting to implement it. Here are a
couple of questions to ask the technical folks
database.
You should really check metalink notes 216212.1 and
216211.1 when thinking Apps and standby.
Tanel.
- Original Message -
From:
Mladen
Gogala
To: Multiple recipients of list ORACLE-L
Sent: Saturday, August 09, 2003 2:04
AM
Subject: RE: SharePlex
Actua
I could access oraclestore today and didn't see neither DataGuard nor
Streams in database additions section (where RAC, Data Mining and others
are).
Then did a product search on dataguard, data guard, standby - got no
positive results...
But maybe the sales guys have other story... I've luckily
Title: SharePlex
it is _supposed_ to work that way ... close to production. But last time
we looked at it, there were too many limitations relates to IOT, VARRAYS etc and
it wasn't ready for our platform and version .
but it is supposed to be good ... I have heard similar things about
Title: RE: SharePlex core dumps - help
Call Quest Software technical support. They will be more than happy to help you.
I think there is already a patch out to fix this.
Just call 1-800-306-9329 and once you speak with an operator, ask to place a support call for SharePlex.
Nick
Sounds like a bug.
If SharePlex gets an error applying SQL to the target, the table should
get marked out-of-sync and Shareplex should go on it's merry way.
Call Shareplex Support - they are usually very responsive.
- Jerry
-Original Message-
Sent: Thursday, November 07, 2002 11:35 AM
49 matches
Mail list logo