7 Replies Latest reply: Mar 22, 2013 2:22 AM by user11982706 RSS

    LOG_ARCHIVE_DEST_2

    983130
      Hello all,

      Why is it recommended to have the value as (ONLINE_LOGS,PRIMARY) for LOG_ARCHIVE_DEST_2?
      What will happen if the value is set as (ALL_LOGIFLES,ALL_ROLES)for LOG_ARCHIVE_DEST_2?

      With regards
        • 1. Re: LOG_ARCHIVE_DEST_2
          Seberg
          Did you try the Oracle documentation?

          http://docs.oracle.com/cd/B19306_01/server.102/b14239/log_arch_dest_param.htm#SBYDB01116

          http://docs.oracle.com/cd/B19306_01/server.102/b14239/log_transport.htm#i1258878

          It is explained well.
          • 2. Re: LOG_ARCHIVE_DEST_2
            CKPT
            Why is it recommended to have the value as (ONLINE_LOGS,PRIMARY) for LOG_ARCHIVE_DEST_2?
            It is not recommended, It has to be changed according to the destination type and role.
            If you set above value the destination of the archives redo log types and database role. It means the destination database redo log files is type of Online redo logs and the
            database_role will be Primary database. You cannot set even as (ONLINE_LOGS, STANDBY) because in standby database environment only the standby redo log files applicable.

            From primary database you usually have to set (STANDBY_LOGFILE, STANDBY_ROLE), Because the redo will send and they will be written in standby redo logfiles. recently on the same topic i have written short note in my blog, please check http://www.oracle-ckpt.com/ora-16014-no-available-destinations-on-standby/
            What will happen if the value is set as (ALL_LOGIFLES,ALL_ROLES)for LOG_ARCHIVE_DEST_2?
            If you choose above attributes, then it can applicable for any logfile type either online or standby (and) and any database role Either physical or logical.
            • 3. Re: LOG_ARCHIVE_DEST_2
              983130
              Hello,

              I have gone through Oracle 11gR2 data guard concept and administration docs.

              As per the Oracle documentation, init file of the primary database is as follows:

              Example 3-1 Primary Database: Primary Role Initialization Parameters

              DB_NAME=chicago
              DB_UNIQUE_NAME=chicago
              LOG_ARCHIVE_CONFIG=’DG_CONFIG=(chicago,boston)’
              CONTROL_FILES=’/arch1/chicago/control1.ctl’, ‘/arch2/chicago/control2.ctl’
              LOG_ARCHIVE_DEST_1=
              ‘LOCATION=/arch1/chicago/
              VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
              DB_UNIQUE_NAME=chicago’
              LOG_ARCHIVE_DEST_2=
              ‘SERVICE=boston ASYNC
              VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
              DB_UNIQUE_NAME=boston’
              LOG_ARCHIVE_DEST_STATE_1=ENABLE
              LOG_ARCHIVE_DEST_STATE_2=ENABLE
              REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
              LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
              LOG_ARCHIVE_MAX_PROCESSES=30


              LOG_ARCHIVE_DEST_2: Directs transmission of the redo data to the remote physical standby database boston.

              My question is why the value is set as (ONLINE_LOGS,PRIMARY) for LOG_ARCHIVE_DEST_2? Why not (STANDBY_LOGFILE, STANDBY_ROLE) as CKPT mentioned

              Thanks
              • 4. Re: LOG_ARCHIVE_DEST_2
                Seberg
                Did you miss the "Usage Notes" sections where VALID_FOR and every combination of Attribute Values is covered including your question?

                Table 14-2 VALID_FOR Attribute Values covers all of this.

                http://docs.oracle.com/cd/B19306_01/server.102/b14239/log_arch_dest_param.htm#SBYDB01116
                • 5. Re: LOG_ARCHIVE_DEST_2
                  user11982706
                  if i set VALID_FOR=(standby_logfile,standby_role) for log_archive_dest_2 then the standby redo logfiles will be filled and archived instead of online redo log files on standby ?

                  am i right my understanding ?




                  Thanks

                  Yogesh
                  http://orasteps.wordpress.com/
                  • 6. Re: LOG_ARCHIVE_DEST_2
                    Lonion
                    If your standby database is physical , then you're right .
                    If your standby database is logical ,then you're wrong . why ? because the logical standby database has its own online redo log files.
                    • 7. Re: LOG_ARCHIVE_DEST_2
                      user11982706
                      Yes, i am talking about physical standby only. Thanks for confirmation...


                      Thanks

                      Yogesh
                      http://orasteps.wordpress.com/