DGMGRL> connect jwong
Password:
Connected as SYSDBA
DGMGRL> show database 'PROD'

Database - PROD

  Role:               PRIMARY
  Intended State:     TRANSPORT-ON
  Instance(s):
    PROD

Database Status:
SUCCESS

DGMGRL> show database verbose 'PROD'

Database - PROD

  Role:               PRIMARY
  Intended State:     TRANSPORT-ON
  Instance(s):
    PROD

  Properties:
    DGConnectIdentifier             = 'PROD_PC'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    RedoRoutes                      = ''
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyLagThreshold               = '0'
    TransportLagThreshold           = '0'
    TransportDisconnectedThreshold  = '30'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = ''
    LogFileNameConvert              = ''
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST
=s626164dc3sw01.CL.CALUMETLUBRICANTS.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME
=PROD_DGMGRL)(INSTANCE_NAME=PROD)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = 'USE_DB_RECOVERY_FILE_DEST'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = 'ARC%S_%R.%T'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS

DGMGRL> show database verbose 'PRODR'

Database - PRODR

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 1 second ago)
  Apply Lag:          0 seconds (computed 1 second ago)
  Average Apply Rate: 3.00 KByte/s
  Active Apply Rate:  463.00 KByte/s
  Maximum Apply Rate: 2.28 MByte/s
  Real Time Query:    OFF
  Instance(s):
    PRODr

  Properties:
    DGConnectIdentifier             = 'PROD_SC'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    RedoRoutes                      = ''
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyLagThreshold               = '0'
    TransportLagThreshold           = '0'
    TransportDisconnectedThreshold  = '30'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = ''
    LogFileNameConvert              = ''
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST
=10.24.105.67)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=PRODR_DGMGRL)(INSTANCE_
NAME=PRODr)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = 'F:\PROD\archiveslog\'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = 'PRODR_ARC%S_%R_%T.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS

DGMGRL> show database 'PRODR'

Database - PRODR

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 1 second ago)
  Apply Lag:          0 seconds (computed 1 second ago)
  Average Apply Rate: 3.00 KByte/s
  Real Time Query:    OFF
  Instance(s):
    PRODr

Database Status:
SUCCESS

DGMGRL> show configuration

Configuration - PROD_DG_CONFIG

  Protection Mode: MaxPerformance
  Members:
  PROD  - Primary database
    PRODR - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 12 seconds ago)


DGMGRL> show configuration verbose

Configuration - PROD_DG_CONFIG

  Protection Mode: MaxPerformance
  Members:
  PROD  - Primary database
    PRODR - Physical standby database

  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    TraceLevel                      = 'USER'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    ObserverReconnect               = '0'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'
    ObserverOverride                = 'FALSE'
    ExternalDestination1            = ''
    ExternalDestination2            = ''
    PrimaryLostWriteAction          = 'CONTINUE'

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

DGMGRL> validate database 'PROD'

  Database Role:    Primary database

  Ready for Switchover:  Yes

  DGMGRL> validate database verbose 'PROD'

  Database Role:    Primary database

  Ready for Switchover:  Yes

  Capacity Information:
    Database  Instances        Threads
    PROD   1                1

  Temporary Tablespace File Information:
    PROD TEMP Files:  1

  Flashback Database Status:
    PROD:  On

  Data file Online Move in Progress:
    PROD:  No

  Transport-Related Information:
    Transport On:  Yes

  Log Files Cleared:
    PROD Standby Redo Log Files:  Cleared

  Automatic Diagnostic Repository Errors:
    Error                       PROD
    No logging operation        NO
    Control file corruptions    NO
    System data file missing    NO
    System data file corrupted  NO
    System data file offline    NO
    User data file missing      NO
    User data file corrupted    NO
    User data file offline      NO
    Block Corruptions found     NO
	
DGMGRL> validate database 'PRODR'

  Database Role:     Physical standby database
  Primary Database:  PROD

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

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

(Doc ID 14674237.8)
Bug 14674237  VALIDATE DATABASE from BROKER incorrectly reports on standby redo log files.
Description

DGMGRL> validate database verbose 'PRODR'

  Database Role:     Physical standby database
  Primary Database:  PROD

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

  Capacity Information:
    Database  Instances        Threads
    PROD   1                1
    PRODR  1                1

  Temporary Tablespace File Information:
    PROD TEMP Files:   3
    PRODR TEMP Files:  3

  Flashback Database Status:
    PROD:   On
    PRODR:  On

  Data file Online Move in Progress:
    PROD:   No
    PRODR:  No

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

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

  Log Files Cleared:
    PROD Standby Redo Log Files:   Cleared
    PRODR Online Redo Log Files:   Cleared
    PRODR Standby Redo Log Files:  Available

  Current Log File Groups Configuration:
    Thread #  Online Redo Log Groups  Standby Redo Log Group
              (PROD)               (PRODR)
    1         3                       4

  Future Log File Groups Configuration:
    Thread #  Online Redo Log Groups  Standby Redo Log Group
              (PRODR)              (PROD)
    1         3                       0
    Warning: standby redo logs not configured for thread 1 o

  Current Configuration Log File Sizes:
    Thread #   Smallest Online Redo      Smallest Standby Re
               Log File Size             Log File Size
               (PROD)                 (PRODR)
    1          100 MBytes                100 MBytes

  Apply-Related Property Settings:
    Property                        PROD Value
    DelayMins                       0
    ApplyParallel                   AUTO

  Transport-Related Property Settings:
    Property                        PROD Value
    LogXptMode                      ASYNC
    RedoRoutes                      <empty>
    Dependency                      <empty>
    DelayMins                       0
    Binding                         optional
    MaxFailure                      0
    MaxConnections                  1
    ReopenSecs                      300
    NetTimeout                      30
    RedoCompression                 DISABLE
    LogShipping                     ON

  Automatic Diagnostic Repository Errors:
    Error                       PROD  PRODR
    No logging operation        NO       NO
    Control file corruptions    NO       NO
    SRL Group Unavailable       NO       NO
    System data file missing    NO       NO
    System data file corrupted  NO       NO
    System data file offline    NO       NO
    User data file missing      NO       NO
    User data file corrupted    NO       NO
    User data file offline      NO       NO
    Block Corruptions found     NO       NO
	
	

 Incorrect thread number appears in log file configuration
 
If you run  'VALIDATE DATABASE' from BROKER, you see a warning about SRL on thread# 3 even though there is no such thread configured.
 
Example :
 
DGMGRL> VALIDATE DATABASE boston
 
 Database Role:     Physical standby database
 Primary Database:  chicago
 
 Ready for Switchover:  Yes
 Ready for Failover:    Yes (Primary Running)
 
 Flashback Database Status:
   bed490101cdb:   Off
   bed490101cdb0:  Off
 
 Future Log File Groups Configuration:
   Thread #  Online Redo Log Groups   Standby Redo Log Groups
             (boston)          (chicago)
   1         3                        0
   Warning: standby redo logs not configured for thread 3 on chicago
 
The warning will be reported if there are SRLs without a thread# specified. Check the V$STANDBY_LOG.THREAD# view.
 
SQL> select GROUP#, THREAD#, SEQUENCE# from V$STANDBY_LOG;
 
   GROUP#    THREAD#  SEQUENCE#
---------- ---------- ----------
        4          0          0
        5          0          0
        6          0          0
        7          0          0
 
Drop and recreate the SRL with a valid thread# to avoid the warning.
 
ALTER DATABASE DROP STANDBY LOGFILE GROUP #;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 SIZE <SIZE>;
 

https://mdinh.wordpress.com/2015/05/29/warning-standby-redo-logs-not-configured-for-thread-bug/
Switch-over -- no problem
https://martincarstenbach.wordpress.com/2015/07/27/little-things-worth-knowing-data-guard-broker-setup-changes-in-12c/



