1. Create a new log group
1.alter Database Add logfile Group 4 ('/u01/app/oracle/oradata/jian/redo04.log ') size 1024k;
2.alter Database Add logfile Group 5 ('/u01/app/oracle/oradata/jian/redo05.log ') size 1024k;
2. Switch the current log to a new log group
1.alter system switch logfile;
2.alter system switch logfile;
3. Delete the old log group
1.alter database drop logfile Group 1;
2.alter database Drop logfile Group 2;
3.alter database drop logfile Group 3;
4. Delete files from the original log group 1, 2, and 3 under the operating system
5. Rebuilding the Log group 1, 2, 3
1.alter Database Add logfile Group 1 ('/u01/app/oracle/oradata/jian/redo01.log ') size 10M;
2.alter Database Add logfile Group 2 ('/u01/app/oracle/oradata/jian/redo02.log ') size 10M;
3.alter Database Add logfile Group 3 ('/u01/app/oracle/oradata/jian/redo03.log ') size 10M;
6. Toggle Log Group
1.alter system switch logfile;
2.alter system switch logfile;
3.alter system switch logfile;
7. Delete Log Group 4, 5
1.alter database Drop logfile Group 4;
2.alter database Drop logfile Group 5;
8, to the operating system to delete the original log Group 4, 5 files
9. Back up the current control file
sql> ALTER DATABASE backup Controlfile to trace Resetlogs
This article is from the "8671833" blog, be sure to keep this source http://8681833.blog.51cto.com/8671833/1538915