7 Replies Latest reply: Feb 19, 2013 11:52 AM by Rob_J RSS

    Dg Parameters

    user13809017
      Hi,

      What is the difference between log_Archive_dest_2 and log_Archive_config in oracle 11g?

      Log_Archive_dest_2 : send a log to standby by service.

      I read the below document,
      http://docs.oracle.com/cd/B12037_01/server.101/b10755/initparams099.htm.


      If not specify log_Archive_config,what happened? Is shipping stopped to standby?

      LOG_ARCHIVE_DEST_STATE_n is enabling archive to local/remote.So why we need to set log_Archive_config again?

      Thanks

      Edited by: user13809017 on 19 Feb, 2013 4:13 AM
        • 1. Re: Dg Parameters
          Sunny kichloo
          Refer this

          http://oraclestore.blogspot.in/2008/09/logarchiveconfig-and-validfor.html


          http://www.orafaq.com/parms/parm1139.htm
          • 2. Re: Dg Parameters
            Osama_Mustafa
            Did you read oracle documentation
            http://docs.oracle.com/cd/B12037_01/server.101/b10823/scenarios.htm
            • 3. Re: Dg Parameters
              mseberg
              Hello;

              LOG_ARCHIVE_DEST_n - where the redo data is to be archived on the primary and standby systems.

              LOG_ARCHIVE_CONFIG - enables the database to send and receive redo.


              If not specify log_Archive_config,what happened? The default value should handle it. ( SEND, RECEIVE, NODG_CONFIG ).
              By default, the LOG_ARCHIVE_CONFIG parameter enables the database to send and receive redo.

              Is shipping stopped to standby? No.


              So why we need to set log_Archive_config again?

              Recommended, but not required for Data Guard. To identify the DB_UNIQUE_NAME for the primary
              database and each standby database in the Data Guard configuration.


              Best Regards

              mseberg
              • 4. Re: Dg Parameters
                user13809017
                Hi,
                By default, the LOG_ARCHIVE_CONFIG parameter enables the database to send and receive redo.
                For Ex :
                Primary unique name : db1
                First standby unique name : stby1
                Second standby unique name : stby2

                Could i set parameter like below

                Primary : LOG_ARCHIVE_CONFIG='DG_CONFIG=(stby1,stby2)

                First Stby:LOG_ARCHIVE_CONFIG='DG_CONFIG=(db1)

                Second Stby:LOG_ARCHIVE_CONFIG='DG_CONFIG=(db1)


                Thanks
                • 5. Re: Dg Parameters
                  mseberg
                  Hello;

                  I won't set it like that, I would do this :


                  Primary
                  LOG_ARCHIVE_CONFIG= 'DG_CONFIG=(db1,stby1,stby2)'

                  First Standby

                  LOG_ARCHIVE_CONFIG= 'DG_CONFIG=(db1,stby1,stby2)'

                  Second Standby

                  LOG_ARCHIVE_CONFIG= 'DG_CONFIG=(db1,stby1,stby2)'

                  Best Regards

                  mseberg
                  • 6. Re: Dg Parameters
                    user13809017
                    Hi,
                    By default, the LOG_ARCHIVE_CONFIG parameter enables the database to send and receive redo
                    Send : sending redo from primary to stand by
                    Receive : Receiving redo to stand by from primary

                    Why don't we set the parameter like below? am i wrong?

                    Primary
                    LOG_ARCHIVE_CONFIG=(send, 'DG_CONFIG= (stby1,stby2)')

                    First Standby

                    LOG_ARCHIVE_CONFIG=(receive, 'DG_CONFIG=(db1)')

                    Second Standby

                    LOG_ARCHIVE_CONFIG= (recieve,'DG_CONFIG=(db1)')

                    Thanks
                    • 7. Re: Dg Parameters
                      Rob_J
                      Hi,

                      I have mine set the same way the mseberg says. I think that's how it is in the documentation and I believe it's so that if you switch the primary and the standby then then can both be the primary and standby without you having to change the config. I could be wrong on that though...

                      Rob