How to increase apply rate on Standby Database

If your primary has huge load or if there are huge gap on your standby, you may need to increase your apply rate on your standby database.
Do not forget your standby server’s CPU and Disk should be strong enough for this actions.

Here is the steps

  1. First let us check current gap:
NAMEVALUETIME_COMPUTED
transport lag+00 00:00:5303/02/2022 09:54:17
apply lag+07 05:25:5303/02/2022 09:54:17
  1. Check related parameter on Standby database
SQL> show parameter PARALLEL_EXECUTION_MESSAGE_SIZE 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
parallel_execution_message_size      integer     16384

Let us change parameter

SQL> alter system set parallel_execution_message_size=32680 scope=spfile sid='*'; << reboot standby database
  1. Start parallel recovery on stabdby database
SQL> alter database recover managed standby database using current logfile disconnect from session parallel 64;
  1. Check current gap:
NAMEVALUETIME_COMPUTED
transport lag+00 00:00:0003/02/2022 09:54:17
apply lag+03 04:35:0303/02/2022 10:04:57

Reference:

DATA GUARD REDO APPLY AND MEDIA RECOVERY BEST PRACTICES
http://www.oracle.com/technetwork/database/features/availability/maa-wp-10gr2-recoverybestpractices-131010.pdf

Reklam


Bir Cevap Yazın

Aşağıya bilgilerinizi girin veya oturum açmak için bir simgeye tıklayın:

WordPress.com Logosu

WordPress.com hesabınızı kullanarak yorum yapıyorsunuz. Çıkış  Yap /  Değiştir )

Facebook fotoğrafı

Facebook hesabınızı kullanarak yorum yapıyorsunuz. Çıkış  Yap /  Değiştir )

Connecting to %s

%d blogcu bunu beğendi: