Re: Standby databases

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 2 Feb 2012 09:41:50 -0600
Message-ID: <CAJvnOJZmF53x11Sn_XiJeThiFPoat7QvgbzMPyP54kZ8zEBX1A_at_mail.gmail.com>



I'm not sure it will work. The scn's will be different, and the dbid's will be different. Off the top of my head, I would say that the logical will have to be completely rebuilt to convert it to a physical standby.. On Thu, Feb 2, 2012 at 9:27 AM, Goulet, Richard <Richard.Goulet_at_parexel.com>wrote:

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

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 02 2012 - 09:41:50 CST

Original text of this message