This discussion is archived
3 Replies Latest reply: Mar 18, 2013 3:53 AM by 951839 RSS

Standby and log_archive_format

995804 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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
    951839 Newbie
    Currently Being Moderated
    Physical database should be in archive mode otherwise Oracle Data Guard would not work properly if you perform a switchover or failover.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points