RE: Oracle migration using shareplex or goldengate or TTS
- From: Laimutis.Nedzinskas@xxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 25 Jun 2013 10:03:23 +0300
What about performance aspect of GG/Shareplex choise.
Say how many MB/sec of redo GG/Shareplex is capabale of tuneling through,
provided network is not an issue.
My personal experience with Oracle Streams is that at the end of the day
serialization is done by exactly one process which is as fast as one CPU
core.
Brgds, Laimis N
---------------------------------------------------------------------------------
Please consider the environment before printing this e-mail
From: John Hallas <John.Hallas@xxxxxxxxxxxxxxxxxx>
To: "exriscer@xxxxxxxxx" <exriscer@xxxxxxxxx>,
"haroon.qureshi@xxxxxxxxx" <haroon.qureshi@xxxxxxxxx>
Cc: oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: 2013.06.18 22:06
Subject: RE: Oracle migration using shareplex or goldengate or TTS
Two good answers so far, both coming down on the side of GG over TTS.
My two pennies worth is that for all the difficulties of TTS I would prefer
the consistency of taking a full tablepace(s) across intact and knowing no
rows could be missing or out of sync. Factor in that TTS does not cost
anything extra then it seems a no brainer.
However if you have to have no outage migration (which is not what the op
needed) then TTS is no use and GG/Shareplex is the tool of choice.
I have used Shareplex in the past for a migration and it was a good tool. I
am sure GG (which we use but not for migrations) is just as good.
John
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Ls Cheng
Sent: 16 June 2013 10:47
To: haroon.qureshi@xxxxxxxxx
Cc: oracle-l
Subject: Re: Oracle migration using shareplex or goldengate or TTS
Hi
I have had experience with OGG, very good, virtually no downtime (in my
case was aprox 5 to 10 minutes in several migrations). You dont need as
much as preparation as TTS but there are preparations specially migrating
from old 9i to latest versions.
But you need a lot of $$$ to buy OGG because you have to license both
source and target systems. I have a few customers had to use other ways
such as TTS because of the license costs, you cannot buy OGG just for
migration purposes, if the customer cannot find a use for OGG after the
migration then they need to seriously considering if it's worth it.
Thanks
--
LSC
--
//www.freelists.org/webpage/oracle-l
______________________________________________________________________
Wm Morrison Supermarkets Plc is registered in England with number 358949.
The registered office of the company is situated at Gain Lane, Bradford,
West Yorkshire BD3 7DL. This email and any attachments are intended for the
addressee(s) only and may be confidential.
If you are not the intended recipient, please inform the sender by replying
to the email that you have received in error and then destroy the email.
If you are not the intended recipient, you must not use, disclose, copy or
rely on the email or its attachments in any way.
This email does not constitute a contract in writing for the purposes of
the Law of Property (Miscellaneous Provisions) Act 1989.
Our Standard Terms and Conditions of Purchase, as may be amended from time
to time, apply to any contract that we enter into. The current version of
our Standard Terms and Conditions of Purchase is available at:
http://www.morrisons.co.uk/gscop
Although we have taken steps to ensure the email and its attachments are
virus-free, we cannot guarantee this or accept any responsibility,
and it is the responsibility of recipients to carry out their own virus
checks.
______________________________________________________________________
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
