RE: Streams for one-time single source replication

From: Ruel, Chris <>
Date: Thu, 6 Feb 2014 20:34:28 +0000
Message-ID: <>

Well, I guess I would have to ask about the sizes involved.

How big is the entire database vs. the subset of schemas?

But, to answer your question, yes, DataGuard would work, but, it would get all the data. Now, of course, that is with a physical standby database. From what I understand, you could do a logical standby and only select specific schemas to keep in sync. I don't think I have a enough experience with those to give you too much direction though. The initial set up is very similar, but, the redo-apply process becomes the sql-apply process and leverages LogMiner to replicate only the objects you select. Hopefully, someone else can chime in and provide some insight to a logical standby approach.

Also, I don't want to discourage you from Steams altogether. I had originally assumed you would want the whole database kept in sync which would have made DataGuard the obvious choice for me.


Chris Ruel * Oracle Database Administrator * Desk:317.759.2172 * Cell 317.523.8482

-----Original Message-----
From: [] On Behalf Of Rich Jesse Sent: Thursday, February 06, 2014 3:22 PM To:
Subject: Re: Streams for one-time single source replication

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.



Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged, confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or entity to
which it is addressed. If you are not the intended recipient of this E-mail, you are
hereby notified that any dissemination, distribution, copying, or action taken in
relation to the contents of and attachments to this E-mail is strictly prohibited
and may be unlawful. If you have received this E-mail in error, please notify the
sender immediately and permanently delete the original and any copy of this E-mail
and any printout. Thank You.**

Received on Thu Feb 06 2014 - 21:34:28 CET

Original text of this message