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 LogfileGroup 2 ; Database Altered.