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

On 31 Jul, 10:24, mc...@xxxxxxxxxxx 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
.

Relevant Pages

  • Re: How do you change log_archive_dest_X when using the DG Broker...?
    ... 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: ... Did you look at the oracle documentation yet? ...
    (comp.databases.oracle.server)
  • How do you change log_archive_dest_X when using the DG Broker...?
    ... 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: ...
    (comp.databases.oracle.server)
  • Re: DataGuard vs Hardware mirroring for DR
    ... We currently use Data Guard for our DR site using 9.2.0.8. ... window in which the database is writing redo at its fastest rate. ... I do nearly all of my full and incremental backups on the standby site ... which takes the load off production as our database is nearly 1TB. ...
    (comp.databases.oracle.server)
  • Re: San-Based replication VS DataGuard replication
    ... I have been using Data Guard as the primary DR solution. ... database stuff that is needed on the recovery site also. ... This all makes the whole switchover experience a very time consuming, ... With standby you can still failover. ...
    (comp.databases.oracle.server)
  • Re: Data Guard and Oracle 11g
    ... But is it still free for Oracle 11g? ... *Oracle Active Data Guard* ... Is a separately licensed Database Option for Oracle Database Enterprise ... require a separate license ...
    (comp.databases.oracle.server)