Re: Streams for one-time single source replication

From: Chris Taylor <>
Date: Thu, 6 Feb 2014 14:36:36 -0600
Message-ID: <>

Well, that definitely complicates things...

The standby idea would be an all or nothing. I was thinking about SQL Apply but again you wouldn't have the ability to narrow it down to specific schemas IIRC.

So, uhm, good luck? ;)

How big are these schemas? I imagine we're talking about a lot of data for each? If not, and I say this hesitantly, you could create a schema of views on the new AIX 7.1 database pointed back to your original database on AIX 5.x and run MERGE commands on the new database to merge the changes until cutover. I'd only consider that for fairly small schemas though.

Other than that, it sounds like a streams approach might be your only option.

So, every schema in the existing AIX 5.x 11.x database is not moving over to your new AIX 7 box? I'm curious why only some schemas would be moved I guess...


On Thu, Feb 6, 2014 at 2:22 PM, Rich Jesse <
> wrote:

> Chris writes:
> > You could do a standby on the AIX 7.1 box - keep the
> archivelogs
> > shipping over and the standby up to date. Then on the cutover date, you
> > shutdown the primary, resync the last transactions and then patch to
> > Although, you might be able to do a standby from
> to
> > since only the patch release version is changing (haven't
> tested
> > that scenario).
> Would this work for a logical copy? I can only have a subset of schemas
> cloned.
> Thanks!
> Rich
> --

Received on Thu Feb 06 2014 - 21:36:36 CET

Original text of this message