RE: Oracle migration using shareplex or goldengate or TTS
Date: Tue, 25 Jun 2013 10:03:23 +0300
Message-ID: <OFB2A93589.2D78D09A-ONC2257B95.00263B24-C2257B95.0026C3C3_at_seb.lt>
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_at_morrisonsplc.co.uk>
To: "exriscer_at_gmail.com" <exriscer_at_gmail.com>, "haroon.qureshi_at_gmail.com" <haroon.qureshi_at_gmail.com>
Cc: oracle-l <oracle-l_at_freelists.org>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Ls Cheng
Sent: 16 June 2013 10:47
To: haroon.qureshi_at_gmail.com
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
--
http://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.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 25 2013 - 09:03:23 CEST