REDUCE the REDOLOG FILES SIZE

REDUCE the REDOLOG FILES SIZE


Add a new logfile to to database
------------------------------------------------
ALTER DATABASE ADD LOGFILE GROUP 4 ('/oradata/xyz/redo04.log') SIZE 30M;
ALTER DATABASE ADD LOGFILE GROUP 1 '/oradata/xyz/redo04.log' SIZE 30M;



Switch logfile to newly created logfile
---------------------------------------------------
alter system switch logfile;


check the group name of logfile
-----------------------------------
select group#, status from v$log;

    GROUP# STATUS
---------- ----------------
         1 INACTIVE
         2 INACTIVE
         3 CURRENT



drop inactive log files
-------------------------------
alter database drop logfile group 1;
delete the logfile at OS LEVEL also



if u get the errors(ORA-01624 & ORA-00312) follow below and DROP again

ALTER SYSTEM CHECKPOINT GLOBAL;




if you get any error like this-------delete the logfile at OS level also

ORA-00301: error in adding log file 'C:\app\neerajs\oradata\orcl\redo01.log' - file cannot be created
ORA-27038: created file already exists
OSD-04010: <create> option specified, file already exists