This discussion is archived
6 Replies Latest reply: Mar 5, 2013 6:22 AM by $phinx19 RSS

Datagaurd Log_archive_config

$phinx19 Newbie
Currently Being Moderated
Hi All,

Is log_archive_config parameter mandatory parameter to specify in Dataguard configiration.
I have set up a DR without specifying this parameter and it works fine with no problem whatsoever.


Regards
Sphinx
  • 1. Re: Datagaurd Log_archive_config
    vlethakula Expert
    Currently Being Moderated
    check
    http://docs.oracle.com/cd/B19306_01/server.102/b14239/init_params.htm

    Its recommended to set to this parameter
  • 2. Re: Datagaurd Log_archive_config
    mseberg Guru
    Currently Being Moderated
    Hello;

    No. ( the short simple answer )

    It has a default like many other parameters :

    http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams112.htm

    The default works fine for Data Guard. ( 'SEND, RECEIVE, NODG_CONFIG' )

    Oracle docs say "Highly recommended." See chapter 14 for details - E10700-02

    However if you run in Maximum Availability you will probably be glad you can it set. Add the database unique names of the other databases. By setting it you can avoid many issues in a RAC setup.

    Please consider closing some of your old questions.
    Total Questions:      69 (21 unresolved) 
    Best Regards

    mseberg

    Edited by: mseberg on Mar 4, 2013 2:55 PM
  • 3. Re: Datagaurd Log_archive_config
    timscn Newbie
    Currently Being Moderated
    hi
    why ?
    http://docs.oracle.com/cd/E11882_01/server.112/e25608/manage_ps.htm#i1017111
    *9.2.1.5 Automatic Repair of Corrupt Data Blocks*
    If a corrupt data block is discovered on a physical standby database, the server attempts to automatically repair the corruption by obtaining a copy of the block from the primary database if the following database initialization parameters are configured on the standby database:

    The LOG_ARCHIVE_CONFIG parameter is configured with a DG_CONFIG list and a LOG_ARCHIVE_DEST_n parameter is configured for the primary database.

    or

    The FAL_SERVER parameter is configured and its value contains an Oracle Net service name for the primary database
  • 4. Re: Datagaurd Log_archive_config
    $phinx19 Newbie
    Currently Being Moderated
    Hi Msberg,

    Thanks, I will do that.

    Are you saying, this parameter is not mandatory for datagaurd configuration and if we do not set it it does not have any adverse repercussions.

    Regards,
    Sphinx
  • 5. Re: Datagaurd Log_archive_config
    mseberg Guru
    Currently Being Moderated
    Hello again;

    What I'm trying to say is on RAC it is very important. On Non-RAC, single Primary and Standby you should not see any adverse repercussions if you don't set it.

    It's important on RAC because of the the extra pieces to that setup.

    Best Regards

    mseberg
  • 6. Re: Datagaurd Log_archive_config
    $phinx19 Newbie
    Currently Being Moderated
    Hi Msberg,

    Thanks, It is clear now.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points