1.增加过渡日志组

? ? alter database add logfile '/home/oracle/oradata/ora11g/redo04.log' size 100M;

? ? alter database add logfile '/home/oracle/oradata/ora11g/redo05.log' size 100M;

? ? alter database add logfile '/home/oracle/oradata/ora11g/redo06.log' size 100M;

?

?

2.切换日志组

? ? alter system switch logfile;

? ? alter system switch logfile;

? ? alter system switch logfile;

?

?

3.手动发生检查点

? ? alter system checkpoint;

?

?

4.删除旧日志组

? ? alter database drop logfile group 1;

? ? alter database drop logfile group 2;

? ? alter database drop logfile group 3;

?

5、增加日志组

? ? alter database add logfile '/home/oracle/oradata/ora11g/redo01.log' size 100m reuse;

? ? alter database add logfile '/home/oracle/oradata/ora11g/redo02.log' size 100m reuse;

? ? alter database add logfile '/home/oracle/oradata/ora11g/redo03.log' size 100m reuse;

?

6、切换日志组

? ? alter system switch logfile;

? ? alter system switch logfile;

? ? alter system switch logfile;

?

7、手工检查点

? ? alter system checkpoint;

?

8、删除过渡日志组

? ? alter database drop logfile group 4;

? ? alter database drop logfile group 5;

? ? alter database drop logfile group 6;

?

9、删除操作系统文件

? ? rm /home/oracle/oradata/ora11g/redo04.log;

? ? rm /home/oracle/oradata/ora11g/redo05.log;

? ? rm /home/oracle/oradata/ora11g/redo06.log;

?

10、查看日志组文件修改

? ? select * from v$logfile;

? ? select * from v$log;