扩大online redo增加日志组

来源：互联网发布：移动网络共享热点设置编辑：程序博客网时间：2024/06/11 10:46

现在的大小为50M，改为300M

切换也比较频繁

添加比较简单：

alter database add logfile group 4 '/u01/oracle/oradata/appserv/redo04.log' size 300m

alter database add logfile group 5 '/u01/oracle/oradata/appserv/redo05.log' size 300m

前三个要先删再添加：

alter database drop logfile group 2;
rm –rf redo02.log
alter database add logfile group 2 '/u01/oracle/oradata/appserv/redo02.log' size 300m

alter database drop logfile group 3;
[root@appserv172 appserv]# mv redo03.log redo03.log.bak
alter database add logfile group 3 '/u01/oracle/oradata/appserv/redo03.log' size 300m

alter database drop logfile group 1;
[root@appserv172 appserv]# mv redo01.log redo01.log.bak
alter database add logfile group 1 '/u01/oracle/oradata/appserv/redo01.log' size 300m

搞完了我发现，居然没有用归档：（PS我还半夜担心归档爆了呢！！！）

0 0