2 Replies Latest reply: Mar 26, 2013 4:33 AM by Lonion RSS

    STANDBY_ARCHIVE_DEST & LOG_ARCHIVE_DEST_1

    993880
      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
          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
            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 .