Re: DATAGUARD and RAC

From: steve montgomerie <stmontgo_at_gmail.com>
Date: Tue, 23 Sep 2008 07:54:30 -0400
Message-ID: <5d4504220809230454k1cf761adg9ebbaa9dfb0f3573@mail.gmail.com>


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_at_gmail.com> 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_at_gmail.com>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
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 23 2008 - 06:54:30 CDT

Original text of this message