My Oracle Support Banner

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

Last updated on JANUARY 15, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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