--Create a new temporary log file
ALTER DATABASE add logfile Group 4 ('/u01/app/oracle/oradata/orcl/redo04.log ') size 10m;
ALTER DATABASE Add logfile Group 5 ('/u01/app/oracle/oradata/orcl/redo05.log ') size 10m;
ALTER DATABASE Add logfile Group 6 ('/u01/app/oracle/oradata/orcl/redo06.log ') size 100m;
--Toggle log file
alter system switch logfile;
alter system switch logfile;
--delete old file
ALTER DATABASE drop logfile Group 1;
ALTER DATABASE drop logfile Group 2;
ALTER DATABASE drop logfile Group 3;
--The operating system deleted three-in-one
--new 3
ALTER DATABASE add logfile Group 1 ('/u01/app/oracle/oradata/orcl/redo01.log ') size 200m;
ALTER DATABASE Add logfile Group 2 ('/u01/app/oracle/oradata/orcl/redo02.log ') size 200m;
ALTER DATABASE Add logfile Group 3 ('/u01/app/oracle/oradata/orcl/redo03.log ') size 200m;
--Toggle log file
alter system switch logfile;
alter system switch logfile;
--delete old log group
ALTER DATABASE drop logfile Group 4;
--os Delete 4,5
--backup control file
sql> connect/as sysdba
sql> ALTER DATABASE backup Controlfile to trace Resetlogs
ORACLE Increased log files