Re: How do you change log_archive_dest_X when using the DG Broker...?

On Jul 31, 7:36 pm, gazzag <gar..._at_jamms.org> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

alter system set log_archive_dest_2='service=tnames_alias' scope=spfile;

but this syntax is irrelevant - because the broker always overwrites it anyway Received on Thu Jul 31 2008 - 04:48:05 CDT