This discussion is archived
2 Replies Latest reply: Mar 19, 2013 3:24 AM by 951839 RSS

Slow apply on logical standby

Santosh Pradhan Explorer
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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
    951839 Newbie
    Currently Being Moderated
    Buy faster disks to speed up apply process on logical standby.

Legend

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