6 Replies Latest reply: Mar 5, 2013 8:22 AM by $phinx19 RSS

    Datagaurd Log_archive_config

      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.

        • 1. Re: Datagaurd Log_archive_config

          Its recommended to set to this parameter
          • 2. Re: Datagaurd Log_archive_config

            No. ( the short simple answer )

            It has a default like many other parameters :


            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


            Edited by: mseberg on Mar 4, 2013 2:55 PM
            • 3. Re: Datagaurd Log_archive_config
              why ?
              * 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.


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

                • 5. Re: Datagaurd Log_archive_config
                  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

                  • 6. Re: Datagaurd Log_archive_config
                    Hi Msberg,

                    Thanks, It is clear now.