Warning: standby redo logs not configured for thread 0 on DATABASE

When run “Validate Database” DGML command, get  “Warning: standby redo logs not configured for thread 0 ” and “Insufficient SRLs” warnings on 12.1.0.2 database with “Database Patch Set Update : 12.1.0.2.170814 (26609783)”.

DGMGRL> connect sys
Password:
Connected as SYSDG.
DGMGRL> validate database "STBPROD";

Database Role: Physical standby database
 Primary Database: PROD

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

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

Flashback Database Status:
 PROD: Off
 STBPROD: Off

Current Log File Groups Configuration:
 Thread # Online Redo Log Groups Standby Redo Log Groups Status
 (PROD) (STBPROD)
 0      232               0              Insufficient SRLs
 Warning: standby redo logs not configured for thread 0 on STBPROD

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

According to “Bug 20582405 – dgmgrl “validate database” shows warning “standby redo logs not configured for thread 0″ (Doc ID 20582405.8)”, it is fixed:

Fixed:

The fix for 20582405 is first included in

Advertisement

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 )

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: