CALCULATE STANDBY REDOLOG TO BE ADDED IN STANDBY DB

Formula to get the number of standby redologs on standby database.

STANDBY REDOLOGS TO BE ADDED = ( number of redolog group * number of threads in primary ) +1

Count the number of redolog groups on physical standby database

SQL> select count(group#) as NUMBER_OF_GROUPS from v$log;

NUMBER_OF_GROUPS
----------------
               3

Count number of threads on physical standby. If it is RAC ,more than one thread will be present

SQL> select count(thread#) from v$thread;

COUNT(THREAD#)
--------------
             1

Using the above two values ,lets substitute to find the number of standby redologs in formula

SQL> select (3*1)+1 as standbylog_count from dual;

STANDBYLOG_COUNT
----------------
               4

We got value as 4 which means ,we should add 4 redologs on standby database

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s