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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mccmx@hotmail.com - 31 Jul 2008 10:24 GMT

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

Reply to this Message

gazzag - 31 Jul 2008 10:36 GMT

On 31 Jul, 10:24, mc...@hotmail.com wrote:

> 10.2.0.3 EE on Red Hat EL 4
>
[quoted text clipped - 14 lines]
>
> Thanks in advance.......

What syntax did you use in SQL*Plus?

-g

Reply to this Message

mccmx@hotmail.com - 31 Jul 2008 10:48 GMT

> On 31 Jul, 10:24, mc...@hotmail.com wrote:
>
[quoted text clipped - 22 lines]
>
> - 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

Reply to this Message

hpuxrac - 31 Jul 2008 17:55 GMT

On Jul 31, 5:24 am, mc...@hotmail.com wrote:

> 10.2.0.3 EE on Red Hat EL 4
>
[quoted text clipped - 14 lines]
>
> Thanks in advance.......

Did you look at the oracle documentation yet?

Reply to this Message

mccmx@hotmail.com - 31 Jul 2008 23:51 GMT

> Did you look at the oracle documentation yet?- Hide quoted text -

Yes,

as far as I can tell there is no section in the Broker guide about
where to change the log_arc_dest parms.

The one section that is related to this states that the dest_X
parameters are built up dynamically as a combination of local listener
address, SID, and DB_UNIQUE name for each database. But there is no
explanation about how to correctly update the value.

Matt

Reply to this Message