修改日志文件组大小

修改日志组大小
 
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.2cto.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.2cto.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;