修改日志组大小
修改日志组大小
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;
www.zzzyk.com
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;
www.zzzyk.com
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;