This discussion is archived
2 Replies Latest reply: Mar 26, 2013 2:33 AM by Lonion RSS

STANDBY_ARCHIVE_DEST & LOG_ARCHIVE_DEST_1

993880 Newbie
Currently Being Moderated
Hello,

My Oracle DB Version 10.2.0.4


It is recommended to set the values of STANDBY_ARCHIVE_DEST and LOG_ARCHIVE_DEST_1 to the same values in most cases.

If both STANDBY_ARCHIVE_DEST & LOG_ARCHIVE_DEST_1 point to different directory, what will be the effect?

With regards
  • 1. Re: STANDBY_ARCHIVE_DEST & LOG_ARCHIVE_DEST_1
    mseberg Guru
    Currently Being Moderated
    Hello;

    For Data Guard :

    If both parameters are specified, the STANDBY_ARCHIVE_DEST initialization parameter overrides the directory location specified with the LOG_ARCHIVE_DEST_n parameter.

    Source : 5.7.1 Specifying Alternate Directory Locations for Archived Redo Log Files - Data Guard Concepts and Administration 10g Release 2 (10.2) B14239-05

    Best Regards

    mseberg
  • 2. Re: STANDBY_ARCHIVE_DEST & LOG_ARCHIVE_DEST_1
    Lonion Newbie
    Currently Being Moderated
    If both parameters are specified, the STANDBY_ARCHIVE_DEST initialization parameter overrides the directory location specified with the LOG_ARCHIVE_DEST_n parameter.
    take a example and post it . in my test , it can't override .

    thank u advance .

Legend

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