5 Replies Latest reply: Mar 22, 2013 1:33 AM by Lonion RSS

    11g STANDBY_ARCHIVE_DEST

    998139
      Hello,

      1)Since STANDBY_ARCHIVE_DEST parameter is depresate, how to specify STANDBY_ARCHIVE_DEST parameter on 11g?
      Which is the replaceable parameter?

      2) Does LNS process reads from Log buffer or Redo Log file?
        • 1. Re: 11g STANDBY_ARCHIVE_DEST
          asahide
          1)Since STANDBY_ARCHIVE_DEST parameter is depresate, how to specify STANDBY_ARCHIVE_DEST parameter on 11g?
          Which is the replaceable parameter?
          LOG_ARCHIVE_DEST_N
          2) Does LNS process reads from Log buffer or Redo Log file?
          Log buffer -> redo log by LGWR and transfer to RFS by LNS.
          11gR2, LNS is changed to NSA or NSS.
          • 2. Re: 11g STANDBY_ARCHIVE_DEST
            CKPT
            1)Since STANDBY_ARCHIVE_DEST parameter is depresate, how to specify STANDBY_ARCHIVE_DEST parameter on 11g?
            Which is the replaceable parameter?
            Deprecated means it is no need required, As said the archive log location will be the default archive destination.
            2) Does LNS process reads from Log buffer or Redo Log file?
            Whenever user commits a transaction which hence creates redo record of log buffer in SGA, From that LGWR reads the redo from the log buffer and writes it to the online redo log file.

            HTH.
            • 3. Re: 11g STANDBY_ARCHIVE_DEST
              Lonion
              Does LNS process reads from Log buffer or Redo Log file?
              the order of LNS process read is Log buffer -> Online log -> Archived log
              • 4. Re: 11g STANDBY_ARCHIVE_DEST
                Lonion
                Does LNS process reads from Log buffer or Redo Log file?
                the order of LNS process read is Log buffer -> Online log -> Archived log
                • 5. Re: 11g STANDBY_ARCHIVE_DEST
                  Lonion
                  Does LNS process reads from Log buffer or Redo Log file?
                  the order of LNS process read is Log buffer -> Online log -> Archived log