RE: ORACLE 11G standby database location setup?

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <mccdba1@xxxxxxxxx>, "Jack van Zanen" <jack@xxxxxxxxxxxx>
  • Date: Mon, 3 May 2010 08:35:31 -0400

That is why there is log_archive_dest_1 thru 10.  Use as many as you
need and specify the valid_for clause to control when they are in use.

Dick Goulet 
Senior Oracle DBA/NA Team Lead 
PAREXEL International 



From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc
Sent: Monday, May 03, 2010 8:26 AM
To: Jack van Zanen
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: ORACLE 11G standby database location setup?

Thank you for answer.  Your example "standbu_dest_location" will use
log_archive_dest_1, but if different location how to do it?


--- On Mon, 5/3/10, Jack van Zanen <jack@xxxxxxxxxxxx> wrote:

        From: Jack van Zanen <jack@xxxxxxxxxxxx>
        Subject: Re: ORACLE 11G standby database location setup?
        To: mccdba1@xxxxxxxxx
        Cc: oracle-l@xxxxxxxxxxxxx
        Date: Monday, May 3, 2010, 1:31 AM
        from my test dataguard on 11G
location="C:\oracle\oradata\archive\DB1",  valid_for=(ALL_LO
        log_archive_dest_2                   service="dg1",    LGWR SYNC
AFFIRM delay=0 OPTIONAL compression=DISABLE max_failure=0
max_connections=1   reopen=300 db_unique_name="standby" net_timeout=30

        Jack van Zanen
        This e-mail and any attachments may contain confidential
material for the sole use of the intended recipient. If you are not the
intended recipient, please be aware that any disclosure, copying,
distribution or use of this e-mail or any attachment is prohibited. If
you have received this e-mail in error, please contact the sender and
delete all copies.
        Thank you for your cooperation 
        On 3 May 2010 11:26, dba1 mcc <mccdba1@xxxxxxxxx> wrote:

                I am doing ORACLE 11G Data Guard testing.  I set up
following entry on init.ora :
                when database startup it show "parameter depresate".
since this parameter is depresate, how to specify "standby_archive_dest"
on 11G?

Other related posts: