This content has been marked as final. Show 2 replies
Santosh Pradhan wrote:Hope you are using "ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;" command
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 ....
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"
Buy faster disks to speed up apply process on logical standby.