4 Replies Latest reply: Mar 19, 2013 3:31 AM by CKPT RSS

    standby questions

    997695
      Hello everbody,

      1) What is the difference between Real-Time Apply and Non Real-Time Apply?

      2) How Oracle decides whether the archival of the primary database redo logs to remote destination(Standby Database) is permitted?

      Regards
        • 1. Re: standby questions
          Lonion
          1) What is the difference between Real-Time Apply and Non Real-Time Apply?
          Real-Time Apply -- *「apply redo directly from the standby redo log files」* as they are being written by the RFS process.
          Non Real-Time Apply -- apply redo from the archive log , the current standby redo log file to be archived
          • 2. Re: standby questions
            asahide
            1) What is the difference between Real-Time Apply and Non Real-Time Apply?
            Real-Time Apply means that Redo-log is been applied from the Standby Redo-Logs directly without having to wait for them getting archived.
            Non Real-Time, Redo-logs -> Archive logs..
            2) How Oracle decides whether the archival of the primary database redo logs to remote destination(Standby Database) is permitted?
            Could you describe in detail?
            • 3. Re: standby questions
              Sunny kichloo
               How Oracle decides whether the archival of the primary database redo logs to remote destination(Standby Database) is permitted?
              Firstly log_archive_dest_state_n should be enabled.Then based on the location mentioned in log_archive_dest_n of primary database it will sent archives to that location.
              • 4. Re: standby questions
                CKPT
                1) What is the difference between Real-Time Apply and Non Real-Time Apply?
                It depends on transport service you use either LGWR or ARCH for real-time apply LGWR service is applicable and you must have same number & size of standby redo log files as Online redo log files, hence you can reduce lag between both sites.
                2) How Oracle decides whether the archival of the primary database redo logs to remote destination(Standby Database) is permitted?
                It depends on the SCN/sequence what standby need