Re: Streams for one-time single source replication

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...

Chris

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

> Chris writes:
>
> > You could do a standby 11.2.0.3.x 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
> > 11.2.0.3.8. Although, you might be able to do a standby from 11.2.0.3.x
> to
> > 11.2.0.3.8 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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