Data Guard from Solaris Single Node database to a RAC logical standby through streams to a linux cluster

From: April Wells <awells_at_netspend.com>
Date: Tue, 27 May 2008 15:28:43 -0500
Message-ID: <BBD07BC523CBB0408182AD21A22EFD5C023F4251@corp-exchange01.corp.netspend.com>

Has anyone done anything with a single node database through data guard
to a logical standby that is a RAC?

 

What is the largest number of tables that anyone has done streams with
to get from one configuration to another (as in downstream data
capture)?

 

How complex is it to set up and maintain downstream data capture with
all of the rules that would keep a huge delete from upwards of 700
tables from going down through the logical standby and into a reporting
database?

 

Anyone have an OLTP setup that feeds an ODS on a different platform and
how is it set up?  I have a Solaris database that I really want to be
able to run as an ultimate source for a linux data warehouse and a linux
reporting database.... And the volume is pretty hefty (over 2 million
transactions a day)

 

Thanks in advance

April




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


--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 27 2008 - 15:28:43 CDT

Original text of this message