Oracle: How to add more redolog files

Log in as sys

Select * from v$log --- Get max group no

Alter database add logfile group 4 'c:\oracle\oradata\orcldb\redo04.log' size 250M reuse;

Alter database add logfile group 5 'c:\oracle\oradata\orcldb\redo05.log' size 250M reuse;

Alter database add logfile group 6 'g:\oracle\oradata\orcldb\redo06.log' size 250M reuse;

Max log files you can have in your database can be got from

Select * from v$controlfile_record_section
where type ='REDO LOG'

Alter system switch logfile;
Alter system switch logfile;
Alter system switch logfile;

Alter system checkpoint;

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