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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s