RE: Standby databases

From: Amaral, Rui <>
Date: Thu, 2 Feb 2012 15:52:30 -0500
Message-ID: <72F6F4B5FDB6504D90D838DA2F42CE2F128AE553CD_at_EX7T2-CV07.TDBFG.COM>

In a previous place we toyed with that idea but ultimately went to two cascaded logical standbys that were several thousand kilometers apart. In doing the research at the time we did find out about cascading from a physical standby to a logical one but could not find anything about going the other way around. We also toyed around with the idea of snapshot standbys but the issue of when to make such databases available to developers and report writers became a little tricky as we could never determine when the db would need to be accessed so logical standbys all the way was the choice.

Rui Amaral
Database Administrator

-----Original Message-----

From: [] On Behalf Of Goulet, Richard Sent: Thursday, February 02, 2012 10:27 AM To: ORACLE-L ( Subject: Standby databases

Has anyone done the following:

                You have a primary database that is heavy into OLTP and has a physical standby in another geographical location.
                You create a logical standby locally for reporting/portal purposes because the developers and business users want up to the minute data and need their own schemas with their own views.
                Since the two databases are different, there is a desire to create a physical standby of the logical in the other geographical location

I'm fine with the archivelog destinations that will be needed. The question has anyone built a physical standby of a logical standby?

Richard Goulet
Senior Oracle DBA/Na Team Leader


NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to for instructions. AVIS : Message confidentiel dont le contenu peut être privilégié. Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière d'aller au pour des instructions.
-- Received on Thu Feb 02 2012 - 14:52:30 CST

Original text of this message