Re: DATAGUARD and RAC
- From: "steve montgomerie" <stmontgo@xxxxxxxxx>
- To: "Bradd Piontek" <piontekdd@xxxxxxxxx>
- Date: Wed, 24 Sep 2008 22:07:14 -0400
Just one more follow up.
You can use ASM for the broker files
http://download.oracle.com/docs/cd/B19306_01/server.102/b14230/configure.htm#CFHEABFJ
I was successul in my switchover /switchback test so thanks again for
pointing me in the right direction.
steve
On Tue, Sep 23, 2008 at 7:54 AM, steve montgomerie <stmontgo@xxxxxxxxx>wrote:
> Thanks, you nailed it. From the SR this *UNPUBLISHED* note details the
> problem
>
> Note 733625.1: Title: Configuration of DG using EM Grid Does not Provide
> Option to Create in Shared Location
> in RAC Environment
>
> On Mon, Sep 22, 2008 at 4:23 PM, Bradd Piontek <piontekdd@xxxxxxxxx>wrote:
>
>> I"m fairly positive it assumes the broker files are in a shared location.
>>
>> You could try disabling the DG Broker (alter system set dg_broker_start =
>> false) and the copying the two dataguard broker files
>> ($ORACLE_HOME/dbs/dr1<dbname>.dat and dr2<dbname>.dat and then enabling the
>> dataguard broker again.
>>
>> Bradd Piontek
>> Oracle Blog: http://piontekdd.blogspot.com
>> Linked In: http://www.linkedin.com/in/piontekdd
>>
>>
>> On Mon, Sep 22, 2008 at 3:15 PM, steve montgomerie <stmontgo@xxxxxxxxx>wrote:
>>
>>> Hello,
>>> We're using OEL 4.5 with 10.2.0.4 in a 4 node primary / single node
>>> standby config.
>>>
>>> I'm trying to place nice with GRID control but it's not working! I create
>>> a copy of the db
>>> using the DG interface in GRID, FTP to the new location and then use the
>>> GRID to
>>> add a physical standby using the backup copy I just took. It rolls right
>>> along, restoring files
>>> and when gets close to the end it fails on 'create standby' throwing
>>>
>>> ~~~~~~~~~~~~~~~~
>>> Error: ORA-16532 (ORA-16532)
>>> Text: Data Guard broker configuration does not exist
>>>
>>> it looks to me that it creates the dg config on one node and does
>>> not for the the remaining three nodes on the primary.
>>>
>>>
>>>
>>> I have a SR open - just holding out hope that someone might have run in
>>> to this before.
>>>
>>> steve
>>>
>>>
>>
>
Other related posts:
