RE: Data Guard to Logical Standby

From: Ben Wittmeier <>
Date: Thu, 1 May 2008 15:54:16 -0600
Message-ID: <>

You may also want to look into Oracle Streams. It is more flexible than dataguard. For example, you can choose to capture only a specific table's changes downstream.....

[] On Behalf Of April Wells Sent: Thursday, May 01, 2008 9:48 AM
Subject: Data Guard to Logical Standby

We are trying to create a logical standby database (solaris) using data guard so we can use downstream data capture to populate a reporting database (Linux) for historical reporting.  

Any chance anyone has done this and can give me some pointers on what I'm probably going to do wrong?  

Can I set rules up stream on the source database on what tables I don't want to have included in the data guard log apply or will it just apply everything? I'm trying to tough my way through the documentation, and am stuck at the "uniquely identify rows" part. It seems that EVERYONE on the source system has a plan table and that doesn't have a primary key. Do I care? Will it complain?  

Should I create a primary key rely disabled on ALL of those plan tables?  

Thanks for any advice


Confidentiality Notice!
This electronic transmission and any attached documents or other writings are confidential and are for the sole use of the intended recipient(s) identified above. This message may contain information that is privileged, confidential or otherwise protected from disclosure under applicable law. If the receiver of this information is not the intended recipient, or the employee, or agent responsible for delivering the information to the intended recipient, you are hereby notified that any use, reading, dissemination, distribution, copying or storage of this information is strictly prohibited. If you have received this information in error, please notify the sender by return email and delete the electronic transmission, including all attachments from your system.

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.

Received on Thu May 01 2008 - 16:54:16 CDT

Original text of this message