Alter/Add Redo Log Files

ALTER DATABASE ADD LOGFILE GROUP 6 ( '/home/oracle/10.2.0/product/oradata/db/redo06.log') SIZE 400M;
ALTER DATABASE ADD LOGFILE GROUP 7 ( '/home/oracle/10.2.0/product/oradata/db/redo07.log') SIZE 400M;
ALTER DATABASE ADD LOGFILE GROUP 8 ( '/home/oracle/10.2.0/product/oradata/db/redo08.log') SIZE 400M;
ALTER DATABASE ADD LOGFILE GROUP 9 ( '/home/oracle/10.2.0/product/oradata/db/redo09.log') SIZE 400M;
ALTER DATABASE ADD LOGFILE GROUP 10 ( '/home/oracle/10.2.0/product/oradata/db/redo10.log') SIZE 400M;

ALTER DATABASE DROP LOGFILE GROUP 2;

ALTER DATABASE DROP LOGFILE GROUP 4;

ALTER SYSTEM SWITCH LOGFILE;

ALTER SYSTEM SWITCH LOGFILE;
ALTER SYSTEM SWITCH LOGFILE;

ALTER DATABASE DROP LOGFILE GROUP 1;

ALTER DATABASE DROP LOGFILE GROUP 3;
ALTER DATABASE DROP LOGFILE GROUP 5;