Surprise to find the following error for single instance Data Guard environment:
Warning: standby redo logs not configured for thread 3 on boston
This will be fixed with an upcoming patch for the existing issue in Oracle Database 12.1.0.1.0 – good reason to stay up to date on patching?
Also, the number of Standby Redo Log Groups do not match since thread = 1 is being used.
Not *ALL* SRL have thread 1 assigned – not sure if this is a bug as well.
[oracle@host01 trace]$ dgmgrl /
DGMGRL for Linux: Version 12.1.0.1.0 - 64bit Production
Copyright (c) 2000, 2012, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected as SYSDG.
DGMGRL> validate database boston
Database Role: Primary database
Ready for Switchover: Yes
Flashback Database Status:
boston: Off
DGMGRL> validate database london
Database Role: Physical standby database
Primary Database: boston
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Flashback Database Status:
boston: Off
london: Off
Current Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups
(boston) (london)
1 3 2
Future Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups
(london) (boston)
1 3 0
Warning: standby redo logs not configured for thread 3 on boston
DGMGRL> validate database london2
Database Role: Logical standby database
Primary Database: boston
Ready for Switchover: Yes
Ready for Failover: Yes (Primary Running)
Warning: Physical and snapshot standby databases will
be disabled if a role change is performed to this database
Flashback Database Status:
boston: Off
london2: Off
Current Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups
(boston) (london2)
1 3 2
Future Log File Groups Configuration:
Thread # Online Redo Log Groups Standby Redo Log Groups
(london2) (boston)
1 3 0
Warning: standby redo logs not configured for thread 3 on boston
DGMGRL>
HOST01:(SYS@boston):PRIMARY> select group#,thread#,sequence#,bytes,used,status from v$standby_log;
GROUP# THREAD# SEQUENCE# BYTES USED STATUS
---------- ---------- ---------- ---------- ---------- ----------
4 0 0 52428800 0 UNASSIGNED
5 0 0 52428800 0 UNASSIGNED
6 0 0 52428800 0 UNASSIGNED
7 0 0 52428800 0 UNASSIGNED
HOST01:(SYS@boston):PRIMARY> select count(*) from v$standby_log where thread#=1;
COUNT(*)
----------
0
HOST01:(SYS@boston):PRIMARY>
HOST03:(SYS@london2):LOGICAL STANDBY> select group#,thread#,sequence#,bytes,used,status from v$standby_log;
GROUP# THREAD# SEQUENCE# BYTES USED STATUS
---------- ---------- ---------- ---------- ---------- ----------
4 1 67 52428800 4803072 ACTIVE
5 1 0 52428800 0 UNASSIGNED
6 0 0 52428800 0 UNASSIGNED
7 0 0 52428800 0 UNASSIGNED
HOST03:(SYS@london2):LOGICAL STANDBY> select count(*) from v$standby_log where thread#=1;
COUNT(*)
----------
2
HOST03:(SYS@london2):LOGICAL STANDBY>
HOST03:(SYS@london):PHYSICAL STANDBY> select group#,thread#,sequence#,bytes,used,status from v$standby_log;
GROUP# THREAD# SEQUENCE# BYTES USED STATUS
---------- ---------- ---------- ---------- ---------- ----------
4 1 67 52428800 4816896 ACTIVE
5 1 0 52428800 0 UNASSIGNED
6 0 0 52428800 0 UNASSIGNED
7 0 0 52428800 0 UNASSIGNED
HOST03:(SYS@london):PHYSICAL STANDBY> select count(*) from v$standby_log where thread#=1;
COUNT(*)
----------
2
HOST03:(SYS@london):PHYSICAL STANDBY>
Thinking Out Loud 