Redolog Group In ACTIVE State After Redo Log Switch Even If Database Is Idle (Doc ID 1928361.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Sep-2016***

Goal

When switching the current redolog, the redo group stays in ACTIVE state...

After issuing "alter system checkpoint", this redo group changes to INACTIVE. Switching redolog group issues a checkpoint implicitly. If so, why doesn't the old redolog group change to INACTIVE state? what's the reason for the left redogroup to remain in ACTIVE state?

 

SQL> select group#,bytes,status from v$log;
 
   GROUP#      BYTES STATUS
---------- ---------- ----------------
        1  104857600 INACTIVE
        2  104857600 INACTIVE
        3  104857600 CURRENT
 
16:40:06 SQL> alter system switch logfile;
 
System altered.
 
16:40:13 SQL> alter system switch logfile
16:40:15   2  /
 
System altered.
 
16:40:18 SQL> select group#,bytes,status from v$log;
 
   GROUP#      BYTES STATUS
---------- ---------- ----------------
        1  104857600 ACTIVE
        2  104857600 CURRENT
        3  104857600 ACTIVE
 
16:40:22 SQL> alter system checkpoint;
 
System altered.
 
16:40:31 SQL> select group#,bytes,status from v$log;
 
   GROUP#      BYTES STATUS
---------- ---------- ----------------
        1  104857600 INACTIVE
        2  104857600 CURRENT
        3  104857600 INACTIVE
 
16:40:35 SQL> select group#,bytes,status from v$log;
 
   GROUP#      BYTES STATUS
---------- ---------- ----------------
        1  104857600 INACTIVE
        2  104857600 CURRENT
        3  104857600 INACTIVE
 
16:40:48 SQL> alter system switch logfile;
 
System altered.
 
16:40:54 SQL> alter system switch logfile;
 
System altered.
 
16:40:56 SQL> select group#,bytes,status from v$log;
 
   GROUP#      BYTES STATUS
---------- ---------- ----------------
        1  104857600 CURRENT
        2  104857600 INACTIVE
        3  104857600 INACTIVE


 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms