MIME-Version: 1.0
In-Reply-To: <CADo_RaOGzCxPV+Apm0jH89x29ZA6=dxb2wvMsxnxF0rJcuuUZA@mail.gmail.com>
References: <7642C3D639A75E4284658CAA38BF60A40DE5F7@US-BOS-VEX001.eu.pxl.int>
 <CAJvnOJZmF53x11Sn_XiJeThiFPoat7QvgbzMPyP54kZ8zEBX1A@mail.gmail.com>
 <CADo_RaOGzCxPV+Apm0jH89x29ZA6=dxb2wvMsxnxF0rJcuuUZA@mail.gmail.com>
Date: Thu, 2 Feb 2012 11:04:54 -0600
Message-ID: <CAJvnOJaJ3Ej7mCrW9hsscchoyLMc6_pdg+6to9=c=+_3Vkc1Hg@mail.gmail.com>
Subject: Re: Standby databases
From: Andrew Kerber <andrew.kerber@gmail.com>
To: Andy Klock <andy@oracledepot.com>
Cc: Richard.Goulet@parexel.com, 
 "ORACLE-L (oracle-l@freelists.org)" <oracle-l@freelists.org>
Content-type: text/plain
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: andrew.kerber@gmail.com

Ok, I didnt read this quite right.  I think he has a logical standby in
use, and he wants to make a physical standby of the logical.  I have never
done that, but I dont see how it would be a problem.
On Thu, Feb 2, 2012 at 9:48 AM, Andy Klock <andy@oracledepot.com> wrote:

> I think the question was, can a logical standby also play the role of the
> primary?  My gut un-researched answer is most likely no.
>
> On Thu, Feb 2, 2012 at 10:41 AM, Andrew Kerber <andrew.kerber@gmail.com>wrote:
>
>> 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@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
>>
>>
>>
>


-- 
Andrew W. Kerber

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


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