2 Replies Latest reply: Mar 19, 2013 5:24 AM by Mark willium RSS

    Slow apply on logical standby

    Santosh Pradhan
      Hi ,

      oracle 10.2.0.3 enterprise edition logical standby

      We performed heavy updates on our production database due to which logical standby gone lots of logs behind with primary database and log are getting apply on logical standby very slowly.

      Kindly suggest how to speed up apply process on logical standby ....
        • 1. Re: Slow apply on logical standby
          CKPT
          Santosh Pradhan wrote:
          Hi ,

          oracle 10.2.0.3 enterprise edition logical standby

          We performed heavy updates on our production database due to which logical standby gone lots of logs behind with primary database and log are getting apply on logical standby very slowly.

          Kindly suggest how to speed up apply process on logical standby ....
          Hope you are using "ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;" command
          Here please check the below note for Adjusting the Number of APPLIER Processes , also if redo transport is slow check the settings for "LOG_ARCHIVE_MAX_PROCESSES"

          http://docs.oracle.com/cd/B28359_01/server.111/b28294/manage_ls.htm#CHDBGBFC
          • 2. Re: Slow apply on logical standby
            Mark willium
            Buy faster disks to speed up apply process on logical standby.