How to change the Size of the Redo Log files to improve the log switch frequency in Oracle database.
select * from v$logfile;
select * from v$log;
alter database add logfile group 4 (‘/u1/oradata/TEST/redo4a.log’,’/u1/oradata/TEST/redo4b.log’) size 100M reuse;
alter database add logfile group 5 (‘/u2/oradata/TEST/redo5a.log’,’/u2/oradata/TEST/redo5b.log’) size 100M reuse;
alter database add logfile group 6 (‘/u3/oradata/TEST/redo6a.log’,’/u3/oradata/TEST/redo6b.log’) size 100M reuse;
Alter system switch logfile;
Alter system switch logfile;
Alter system switch logfile;
Alter system checkpoint;
Before proceeding to drop the old log files. Just do a “select * from v$log” to be sure that the old redo log group have their status as “inactive”.
Alter database drop logfile group 1;
Alter database drop logfile group 2;
Alter database drop logfile group 3;
#Now go to the physical location and delete the files from there.