From: "Amaral, Rui" <Rui.Amaral@tdsecurities.com>
To: "Amaral, Rui" <Rui.Amaral@tdsecurities.com>,
 "'Richard.Goulet@parexel.com'" <Richard.Goulet@parexel.com>, "ORACLE-L
 (oracle-l@freelists.org)" <oracle-l@freelists.org>
Date: Thu, 2 Feb 2012 15:58:00 -0500
Subject: RE: Standby databases
Thread-Topic: Standby databases
Message-ID: <72F6F4B5FDB6504D90D838DA2F42CE2F128AE553CE@EX7T2-CV07.TDBFG.COM>
References: <7642C3D639A75E4284658CAA38BF60A40DE5F7@US-BOS-VEX001.eu.pxl.int>
 <72F6F4B5FDB6504D90D838DA2F42CE2F128AE553CD@EX7T2-CV07.TDBFG.COM>
In-Reply-To: <72F6F4B5FDB6504D90D838DA2F42CE2F128AE553CD@EX7T2-CV07.TDBFG.COM>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: Rui.Amaral@tdsecurities.com

Of course, this is also assuming that you don't want to stray too far away from the options available you. 

Once GoldenGate became available (not too long after our initial setup that I mentioned) then we pursued a setup like you envisioned with the initial logical actually being fed by GG rather than Dataguard then that one was the primary with a physical standby behind it. But as usual, in this scenario licensing will be a concern for you.

Rui Amaral
Database Administrator


-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Amaral, Rui
Sent: Thursday, February 02, 2012 3:53 PM
To: 'Richard.Goulet@parexel.com'; ORACLE-L (oracle-l@freelists.org)
Subject: RE: Standby databases

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: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Goulet, Richard
Sent: Thursday, February 02, 2012 10:27 AM
To: ORACLE-L (oracle-l@freelists.org)
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


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


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


NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to www.td.com/legal 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 www.td.com/francais/avis_juridique pour des instructions.
--
http://www.freelists.org/webpage/oracle-l