Not all Standby Redo Log groups are used on the standby database (Doc ID 2435333.1)

Last updated on JULY 20, 2024

Applies to:

Goal

You created standby redo log groups on the physical standby database, but some of them showUNASSIGNED status all the time.
There are 3 online groups on the primary database and there are four standby redo log groups on the standby database, but only one or two are used.

From Primary:
SQL> select thread#, group#, bytes, status from v$log;

  THREAD#     GROUP#      BYTES STATUS
---------- ---------- ---------- ----------------
        1          4 1073741824 CURRENT
        1          5 1073741824 INACTIVE
        1          6 1073741824 INACTIVE

From Standby:
SQL> select thread#, group#, bytes, status from v$standby_log;

  THREAD#     GROUP#      BYTES STATUS
---------- ---------- ---------- ----------
        1         10 1073741824 UNASSIGNED
        1         11 1073741824 ACTIVE
        1         12 1073741824 UNASSIGNED
        1         13 1073741824 UNASSIGNED
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.