DB Wiki

This is an old revision of the document!

Redo Logs

Resizing Online

Add New Online Redo Log Groups

If we are using OMF then all that is needed is the below 3 commands.

ALTER DATABASE ADD LOGFILE GROUP 4 SIZE 500M;
ALTER DATABASE ADD LOGFILE GROUP 5 SIZE 500M;
ALTER DATABASE ADD LOGFILE GROUP 6 SIZE 500M;

Without OMF then the following commands will be needed.

ALTER DATABASE ADD LOGFILE GROUP 4 (
  2  '/u02/app/oradata/redo04a.log',  
  3  '/u03/app/oradata/redo04b.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE GROUP 5 (
  2  '/u02/app/oradata/redo05a.log',  
  3  '/u03/app/oradata/redo05b.log') SIZE 500M;
ALTER DATABASE ADD LOGFILE GROUP 6 (
  2  '/u02/app/oradata/redo06a.log',  
  3  '/u03/app/oradata/redo06b.log') SIZE 500M;