My Oracle Support Banner

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

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.