2 Replies Latest reply: Nov 10, 2012 5:49 PM by teits RSS

    Protection Mode Vs init file settings

    Arun Natarajan-OC
      Dear Friends,

      In 11g databgurad i am setting the Protection mode of Primary to : Maximum protection at the DB level(so that it uses sync)


      But while defining in init file if i say ASYNC for standby DB as mentioned below

      LOG_ARCHIVE_DEST_2= 'SERVICE=boston ASYNC



      Then will setting will take precednce , SYNC from maximum protection mode defined at DB level (or) ASYNC which is defined in init file?


      (or) will it throw error if there is any mismatch?

      Regards,
      DB
        • 1. Re: Protection Mode Vs init file settings
          972755
          hi

          Requirements for Maximum Protection mode:

          Redo Transport mode: SYNC
          Disk Write Option: AFFIRM
          Standby Redo Logs: Yes
          Standby Database Type: Physical

          so use like this

          .log_archive_dest_2='SERVICE=cdssty LGWR SYNC AFFIRM VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=cdssty'


          or read more on :

          http://hemendraoracleblogs.blogspot.in/2012/11/oracle-data-guard-configuration-for.html
          • 2. Re: Protection Mode Vs init file settings
            teits
            839396 wrote:
            Dear Friends,

            In 11g databgurad i am setting the Protection mode of Primary to : Maximum protection at the DB level(so that it uses sync)


            But while defining in init file if i say ASYNC for standby DB as mentioned below

            LOG_ARCHIVE_DEST_2= 'SERVICE=boston ASYNC



            Then will setting will take precednce , SYNC from maximum protection mode defined at DB level (or) ASYNC which is defined in init file?


            (or) will it throw error if there is any mismatch?
            No error will be throw. BUT the Protection Mode is revert back to MAXIMUM PERFORMANCE mode.
            you can confirm this in the alert log and v$database on the standby DB
            SQL> alter database SET STANDBY DATABASE TO MAXIMIZE PROTECTION;
            
            Database altered.
            
            Perform a log switch at the primary DB i.e alter system switch logfile; 
            
            SQL> select PROTECTION_MODE from v$database;
            PROTECTION_MODE
            --------------------
            MAXIMUM PERFORMANCE
            
            SQL> 
            SYNC is a major attributes you need to set, if you want MAXIMUM PROTECTION mode.


            HTH
            Tobi