修改日志组大小 -电脑资料

    修改日志组大小

    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;