AHF - Autonomous Health Framework (TFA - ORACHK) (MOSC)

MOSC Banner

Standby redo logs status on primary

edited Sep 9, 2020 2:19PM in AHF - Autonomous Health Framework (TFA - ORACHK) (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center