Standby redo logs status on primary
Hi there,
I have Setup a dataguard and am checking it with ORACHK (that wonderful tool!). I am confused with an error message about the standby redo logs. I have configured standby redo logs on the Primary.
I have 16 redo logs members,
two members per Group. So I have 8 redo log Groups.
This is single instance, so only one thread.
Therefore I need 8 + 1 = 9 standby redo logs.
What am I missing here?
SQL>
SQL> -- how many redo log Groups do I have?
select count(distinct group#) "Number redo log groups"
from v$logfile
where type = 'ONLINE';
SQL> 2 3
Number redo log groups