3 Replies Latest reply: Mar 18, 2013 5:53 AM by Mark willium RSS

    Standby and log_archive_format

    995804
      Hello,

      1) Does Oracle create standby archivelog file at the standby site based on the format specified with LOG_ARCHIVE_FORMAT?
      If FRA is on, then oracle ignores the format specified with log_archive_format parameter and creates the archive log files on it's own. Right?

      2) Why do we need to put physical standby in Archivelog mode? Is it only because of switchover/failover?

      With regards
        • 1. Re: Standby and log_archive_format
          user11982706
          1) Does Oracle create standby archivelog file at the standby site based on the format specified with LOG_ARCHIVE_FORMAT? 
          If FRA is on, then oracle ignores the format specified with log_archive_format parameter and creates the archive log files on it's own. Right? 
          Yes, oracle create standby archivelog file at standby in LOG_ARCHIVE_FORMAT because by default data is written to standby redo and then archived to standby.
          yes, right, If you implement FRA, then LOG_ARCHIVE_FORMAT is parameter is ignored.
          Why do we need to put physical standby in Archivelog mode? Is it only because of switchover/failover?
          Because as said above, data from primary is written to standby redo and then archived. So, archive log mode is required.


          Thanks

          Yogesh
          http://orasteps.wordpress.com/
          • 2. Re: Standby and log_archive_format
            Hemant K Chitale
            Why do we need to put physical standby in Archivelog mode
            You don't "put" a physical standby in archivelog mode. It uses a standby controlfile that inherits attributes from the primary database -- one of these is the ARCHIVELOG mode.


            Hemant K Chitale
            • 3. Re: Standby and log_archive_format
              Mark willium
              Physical database should be in archive mode otherwise Oracle Data Guard would not work properly if you perform a switchover or failover.