Standby databases
From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Thu, 2 Feb 2012 15:27:06 +0000
Message-ID: <7642C3D639A75E4284658CAA38BF60A40DE5F7_at_US-BOS-VEX001.eu.pxl.int>
Has anyone done the following:
Date: Thu, 2 Feb 2012 15:27:06 +0000
Message-ID: <7642C3D639A75E4284658CAA38BF60A40DE5F7_at_US-BOS-VEX001.eu.pxl.int>
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-lReceived on Thu Feb 02 2012 - 09:27:06 CST