CODE EXAMPLE FOR SQL

oracle logfile switch

-- If you ar running RAC, it is the best way to switch redologfile.
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;