Resize Redolog On RAC Instance

Oracle

Before I Posted “How To Resize redo log ” This was on Single Instance But Now I show you how to do it on Oracle Real Application Cluster

1.First Run this Query To check size, redo On your RAC :

select l.group#, l.thread#, f.member, l.archived, l.status, (bytes/1024/1024) fsize
from v$log l, v$logfile f
where f.group# = l.group#
order by 1,2

  1. Now our purpose is increase redosize from 100Mb to 300 Mb
  2. We are going to add our new redo file by below command:

4.
alter database add logfile group 5 ë+ORADATAí size 300M; << node 2
alter database add logfile group 6 ë+ORADATAí size 300M; << node 2
alter database add logfile group 7 ë+ORADATAí size 300M; << node 1
alter database add logfile group 8 ë+ORADATAí size 300M; << node 1

  1. Switch until we are into log group 5,6,7,8 so we can drop log groups 1, 2,3 and 4 Until you see the new redo log used .