3 Replies Latest reply: Oct 24, 2012 4:04 PM by mseberg RSS

    log_archive_format parameter in data guard

    User447797-OC
      Oracle RDBMS : 11.2.0.2 RAC on RHEL 5.6 and we are using ASM,OMF

      Is it mandatory to set log_archive_format to "arc" i.e., log_archive_format='%t_%s_%r.arc' . My primary has log_archive_format='%t_%s_%r.dbf' and for data guard physical standby the parameter is changed to '%t_%s_%r.arc'.

      1)The default is in "dbf" and to change the parameter we need to shutdown the database.
      We don't want our production to be shutdown, and so what happens if i don't change the parameter and leave it as "dbf".

      2)What is the difference between .arc and .dbf for log_archive_format?

      3)Can we have primary in .dbf and standby in .arc, and we are planning to have our backups on standby so are standby backups can be used at primary with different log_archive_format if needed?if no why?
        • 1. Re: log_archive_format parameter in data guard
          mseberg
          Hello;
          1)The default is in "dbf" and to change the parameter we need to shutdown the database.
          We don't want our production to be shutdown, and so what happens if i don't change the parameter and leave it as "dbf".
          Have not tested, but I cannot see where anything negative or anything would happen to impact you.

          2)What is the difference between .arc and .dbf for log_archive_format?
          Beside the letters nothing. Its just the extension you give to the file name.


          3)Can we have primary in .dbf and standby in .arc, and we are planning to have our backups on standby so are standby backups can be used at primary with different log_archive_format if needed?if no why?
          You can. I like to keep things the same if possible myself.


          Best Regards

          mseberg
          • 2. Re: log_archive_format parameter in data guard
            User447797-OC
            Hi

            Is log_archive_format parameter required? Then why it is we needed to set log_archive_format parameter while building physical standby.
            • 3. Re: log_archive_format parameter in data guard
              mseberg
              Hello;

              No it is not.

              I don't have it set on any of mine.

              Complete INIT from my test system
              PRIMARY.__db_cache_size=318767104
              PRIMARY.__java_pool_size=4194304
              PRIMARY.__large_pool_size=4194304
              PRIMARY.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
              PRIMARY.__pga_aggregate_target=281018368
              PRIMARY.__sga_target=834666496
              PRIMARY.__shared_io_pool_size=0
              PRIMARY.__shared_pool_size=490733568
              PRIMARY.__streams_pool_size=4194304
              *.audit_file_dest='/u01/app/oracle/admin/PRIMARY/adump'
              *.audit_trail='db'
              *.compatible='11.2.0.0.0'
              *.control_files='/u01/app/oracle/oradata/PRIMARY/control01.ctl','/u01/app/oracle/oradata/PRIMARY/control02.ctl'
              *.db_block_size=8192
              *.db_flashback_retention_target=2880
              *.db_name='PRIMARY'
              *.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
              *.db_recovery_file_dest_size=23622320128
              *.DB_UNIQUE_NAME='PRIMARY'
              *.diagnostic_dest='/u01/app/oracle'
              *.dispatchers='(PROTOCOL=TCP) (SERVICE=PRIMARYXDB)'
              *.FAL_SERVER='STANDBY'
              *.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER)))'
              *.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRIMARY'
              *.log_archive_dest_2='SERVICE=STANDBY LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STANDBY'
              *.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
              *.log_archive_dest_state_2='ENABLE'
              *.LOG_ARCHIVE_MAX_PROCESSES=30
              *.open_cursors=300
              *.pga_aggregate_target=277872640
              *.processes=150
              *.remote_login_passwordfile='EXCLUSIVE'
              *.sec_case_sensitive_logon=FALSE
              *.sga_target=833617920
              *.STANDBY_FILE_MANAGEMENT='AUTO'
              *.undo_tablespace='UNDOTBS1'
              Best Regards

              mseberg

              Edited by: mseberg on Oct 24, 2012 4:03 PM