现在的大小为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 我还半夜担心归档爆了呢!!!)