SQL> alter system switch logfile; System altered. SQL> select * from v$Log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- 1 1 12 2147483648 1 NO ACTIVE 203704 2009-09-17 19:04:23 2 1 11 52428800 1 NO ACTIVE 203206 2009-09-17 18:56:08 3 1 13 2147483648 1 NO CURRENT 203710 2009-09-17 19:04:38 SQL>alter system checkpoint; System altered. SQL> select * from v$Log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- 1 1 12 2147483648 1 NO INACTIVE 203704 2009-09-17 19:04:23 2 1 11 52428800 1 NO INACTIVE 203206 2009-09-17 18:56:08 3 1 13 2147483648 1 NO CURRENT 203710 2009-09-17 19:04:38 SQL> alter database drop logfile group 2; Database altered.