Oracle Redo Log Boyutunu değiştirme

select * from v$logfile;
select * from v$log;

alter database add logfile group 4 '+DATA' size 1G;
alter database add logfile group 5 '+DATA' size 1G;
alter database add logfile group 6 '+DATA' size 1G;

alter system checkpoint;
select * from v$logfile;
select * from v$log;

alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;