-- Archived and redo logs - Resize redos
-- Current Redo Logs
column group# format 99999;
column status format a10;
column mb format 99999;
select group#, status, bytes/1024/1024 MB, status, con_id from v$log;

-- Current logfiles
set lines 200
select group#, substrb(member, 1, 90), con_id from v$logfile;


Add 3 Groups with New Size (1GB)
alter database add logfile group 4 ('D:\ORACLE\ORADATA\CxxPRDS\REDO04.LOG') size 1g, group 5 ('D:\ORACLE\ORADATA\CxxPRDS\REDO05.LOG') size 1g, group 6 ('D:\ORACLE\ORADATA\CxxPRDS\REDO06.LOG') size 1g;

select group#, status, bytes/1024/1024 MB, status, con_id from v$log;

alter system checkpoint;

-- drop inactive logs
alter database drop logfile group 2;
alter database drop logfile group 3;

-- switch current log:
alter system switch logfile;
alter system checkpoint;

-- drop inactive logs
select group#, status, bytes/1024/1024 MB, status, con_id from v$log;
alter database drop logfile group 1;

-- new sizing should now be in place:
select group#, status, bytes/1024/1024 MB, status, con_id from v$log;

-- remove old redo logs files