Warning: standby redo logs not configured for thread <n> on <db_unique_name> (Doc ID 1956103.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

o With broker configuration of a RAC primary, to a RAC or non-RAC standby database. In this example, the primary is a two nodes RAC - lc5db2, and the standby is a single instance DB - LS6DB2

o This environment has two online redo log groups, and three standby redo log groups configured for each thread.

o found this warning message from the broker configuration command:

DGMGRL> VALIDATE DATABASE VERBOSE ls6db2;

  Database Role:     Physical standby database
  Primary Database:  lc5db2

  Ready for Switchover:  Yes
  Ready for Failover:    Yes (Primary Running)

  Capacity Information:
    Database  Instances        Threads        
    lc5db2    2                2              
    ls6db2    1                2              
    Warning: the target standby has fewer instances than the
    primary database, this may impact application performance

  Temporary Tablespace File Information:
    lc5db2 TEMP Files:  1
    ls6db2 TEMP Files:  1

  Flashback Database Status:
    lc5db2:  On
    ls6db2:  Off

  Data file Online Move in Progress:
    lc5db2:  No
    ls6db2:  No

  Standby Apply-Related Information:
    Apply State:      Running
    Apply Lag:        0 seconds (computed 1 second ago)
    Apply Delay:      0 minutes

  Transport-Related Information:
    Transport On:      Yes
    Gap Status:        No Gap
    Transport Lag:     0 seconds (computed 1 second ago)
    Transport Status:  Success

  Log Files Cleared:
    lc5db2 Standby Redo Log Files:  Cleared
    ls6db2 Online Redo Log Files:   Cleared
    ls6db2 Standby Redo Log Files:  Available

  Current Log File Groups Configuration:
    Thread #  Online Redo Log Groups  Standby Redo Log Groups Status       
                       (lc5db2)                                (ls6db2)                             
    1                2                                             2                                               Insufficient SRLs
    2                2                                             2                                               Insufficient SRLs

  Future Log File Groups Configuration:
    Thread #  Online Redo Log Groups  Standby Redo Log Groups Status       
                      (ls6db2)                                 (lc5db2)                             
    1               2                                              0                                                Insufficient SRLs
    Warning: standby redo logs not configured for thread 1 on lc5db2
    2               2                                              0                                                Insufficient SRLs
    Warning: standby redo logs not configured for thread 2 on lc5db2

 

Changes

o The warning messages only return from the new 12c broker command - VALIDATE DATABASE

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms