Re: Shareplex

Hey Saad,

In the last month, I used SharePlex to migrate 4 schemas from 12.1 on AIX to 19.6 on OL7 (major version and endian change). It's a logical replication, replaying DML (and most DDL, which is configurable) in the target database. To start, I did a data pump export/import from an SCN. Once in place, the replication was started from that SCN (plus 1). I left that running for about 6 days, as the export/import took almost 10 hours due to the data volume and network bandwidth and I wanted to have enough time to restart in case there were issues. The only issues I encountered were a short hiccup due to the network being over an internet VPN thanks to COVID delays in getting our dedicated MPLS up. SharePlex seamlessly picked up where it left off after the network hiccup. After much testing and two full test runs, the actual transfer went flawlessly.

This migration was made a little more complex because our 19.6 target database is used as a SharePlex source for our reporting database (cascading replication), and the latter setup is still being used. So, we had a term license for the migration and we have an annual license for the reporting database replication. Given this complexity and timelines, we employed technical services ("consultant") for our setup, and I'm happy with the result.

My only real gripe is that I know that our peak DML times cause some (minor) delay in the replay on the target, but I don't know how to measure it. In DG, there's a view to get a histogram of apply lag times. In SharePlex, I don't see anything like that. There's detailed information on each piece of SharePlex (read, export, import, post), but nothing I can find that tells me how long it's taking rows to get from source to target. Then again, I'm still very new to SharePlex.

Very happy with SharePlex. Would definitely recommend.

My $.02,
Rich

On Wed, Aug 5, 2020 at 1:59 PM Khan, Muhammad <MKhan16_at_northwell.edu> wrote:

> Hey DB gang,
>
>
>
> Has anybody used Quest’s product shareplex for database migration and/or
> upgrade? Need to know some candid reviews.
>
>
>
> We have a upgrade project for oracle 11.2.0.3 on standard edition , hence
> Goldengate is not an option. We are looking for a zero downtime upgrade and
> wondering if shareplex can be helpful?!
>
>
>
>
>
> -Saad
>
>
>
> The information contained in this electronic e-mail transmission and any
> attachments are intended only for the use of the individual or entity to
> whom or to which it is addressed, and may contain information that is
> privileged, confidential and exempt from disclosure under applicable law.
> If the reader of this communication is not the intended recipient, or the
> employee or agent responsible for delivering this communication to the
> intended recipient, you are hereby notified that any dissemination,
> distribution, copying or disclosure of this communication and any
> attachment is strictly prohibited. If you have received this transmission
> in error, please notify the sender immediately by telephone and electronic
> mail, and delete the original communication and any attachment from any
> computer, server or other electronic recording or storage device or medium.
> Receipt by anyone other than the intended recipient is not a waiver of any
> attorney-client, physician-patient or other privilege.

--
http://www.freelists.org/webpage/oracle-l