Re: How do you change log_archive_dest_X when using the DG Broker...?
From: gazzag <gareth_at_jamms.org>
Date: Thu, 31 Jul 2008 02:36:41 -0700 (PDT)
Message-ID: <015e2a7c-cafb-499a-abbe-7f270da1d1eb@s50g2000hsb.googlegroups.com>
Date: Thu, 31 Jul 2008 02:36:41 -0700 (PDT)
Message-ID: <015e2a7c-cafb-499a-abbe-7f270da1d1eb@s50g2000hsb.googlegroups.com>
On 31 Jul, 10:24, mc..._at_hotmail.com wrote:
> 10.2.0.3 EE on Red Hat EL 4
>
> How can you update the log_arc_dest parameters on a database which is
> managed by the Data Guard Broker...
>
> I've tried using the dgmgrl as follows:
>
> dgmgrl /
>
> DGMGRL> edit database "XXX" set property
> 'initialconnectidentifier'=<new setting>;
>
> but this makes no difference to the parameter.
>
> I've also changed it by hand using sqlplus but the Broker overwrites
> it if i restart the databse or perform a switchover.
>
> Thanks in advance.......
What syntax did you use in SQL*Plus?
-g Received on Thu Jul 31 2008 - 04:36:41 CDT