Resize redo log files

/* Check logs and log groups */
set linesize 100
col member format a35
SELECT a.group#, a.member, b.bytes
FROM v$logfile a, v$log b WHERE a.group# = b.group#;

/* Check for active log group */
select group#, status, bytes from v$log order by group#;

/* If group 1 is not active from the query above, it's safe to drop it */
alter database drop logfile group 1;
alter database add logfile group 1 (‘/data/ises/01/oradata/redo01.log’) size 450m reuse;

alter system switch logfile;

/* If group 2 is not active from the query above */
alter database drop logfile group 2;
alter database add logfile group 2 (‘/data/ises/02/oradata/redo02.log’) size 450m reuse;

alter database drop logfile group 3;