Change size of Redo Log files and drop the old files.

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.

Category: DatabaseTuning

Tags:

Leave a Reply

Article by: Shadab Mohammad