Database - RAC/Scalability (MOSC)

MOSC Banner

Standby DB only use 2 of 5 of standby redolog groups

edited Mar 29, 2017 10:38AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered ✓

Hi,

DB only use 2 of 5 of standby redolog groups

 

Only group name 15 and 16 are used:

 

select group#, thread#, sequence#, used, archived, status, first_change#, first_time from v$standby_log order by 1,2,3,4;

 

  GROUP# THREAD# SEQUENCE# USED ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME

---------- ---------- ---------- ---------- ------------ ---------------------------------------- ------------- ------------------

  15 1 14052 438902272 YES ACTIVE 8.2675E+12 23-MAR-17

  16 1 0 0 NO UNASSIGNED <----- the next loop use it

  17 1 0 0 NO UNASSIGNED <----- never used

  18 1 0 0 YES UNASSIGNED <----- never used

  19 1 0 0 YES UNASSIGNED <----- never used

 

real time apply is used:

 

SQL> select DEST_ID,type,status,database_mode,recovery_mode,database_mode,srl from v$archive_dest_status where recovery_mode!='IDLE';

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