Resize redo log files

There is no direct way to resize the redo log files. Basically we have to drop and recreate with new size.

Here is an example. My existing redo size is 10 MB and want to increase to 100MB.
I have thread 1,2 and 3 because I have 3 nodes RAC clusters.

alter database drop logfile '/u01/oradata/$DBNAME/redo11.log';
alter database add logfile thread 1 group 1 '/u01/oradata/$DBNAME/redo11.log' size 100M resize;

alter database drop logfile '/u02/oradata/$DBNAME/redo12.log';
alter database add logfile thread 1 group 2 '/u02/oradata/$DBNAME/redo12.log' size 100M resize;

alter database drop logfile '/u03/oradata/$DBNAME/redo13.log';
alter database add logfile thread 1 group 3 '/u03/oradata/$DBNAME/redo13.log' size 100M resize;



alter database drop logfile '/u01/oradata/$DBNAME/redo21.log';
alter database add logfile thread 2 group 4 '/u01/oradata/$DBNAME/redo21.log' size 100M resize;

alter database drop logfile '/u02/oradata/$DBNAME/redo22.log';
alter database add logfile thread 2 group 5 '/u02/oradata/$DBNAME/redo22.log' size 100M resize;

alter database drop logfile '/u03/oradata/$DBNAME/redo23.log';
alter database add logfile thread 2 group 6 '/u03/oradata/$DBNAME/redo23.log' size 100M resize;



alter database drop logfile '/u01/oradata/$DBNAME/redo31.log';
alter database add logfile thread 3 group 7 '/u01/oradata/$DBNAME/redo31.log' size 100M resize;

alter database drop logfile '/u02/oradata/$DBNAME/redo32.log';
alter database add logfile thread 3 group 8 '/u02/oradata/$DBNAME/redo32.log' size 100M resize;

alter database drop logfile '/u03/oradata/$DBNAME/redo33.log';
alter database add logfile thread 3 group 9 '/u03/oradata/$DBNAME/redo33.log' size 100M resize;