24   20971520          1 NO  INACTIVE                868923 08-AUG-06

         5          1         25   20971520          1 NO  ACTIVE                  951980 10-AUG-06

 

SQL>

SQL> alter system checkpoint;

 

System altered.

 

SQL> select * from v$log;

 

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM

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

         1          1         26   20971520          1 NO  CURRENT                 994126 10-AUG-06

IXDBA.NET技术社区

         2          1         22   20971520          1 NO  INACTIVE                753376 07-AUG-06

         3          1         23   20971520          1 NO  INACTIVE                785843 07-AUG-06

         4          1         24   20971520          1 NO  INACTIVE                868923 08-AUG-06

         5          1         25   20971520          1 NO  INACTIVE                951980 10-AUG-06