Hi,
The following is the procedure to increase the size of Redo Log File.

1. alter database
add logfile group x
('c:\log\log0101.log','d:\log\log0102.log') size xM;

2. Switch to make it current
alter database switch logfile;

3. Drop the exisiting redo log files
alter database drop logfile group x;

4. Recreate redolog files with desired size in the place of
deleted log files.


In case of any help please be free to ask me at [email protected]


Regards,
ROhit Nirkhe,Oracle DBA,OCP 8i
[email protected]