Oracle修改redo日志大小

1、查询默认redo表空间大小：

 select group#,bytes/1024/1024 MB ,status from v$log;

2、查询redo表空间存放位置：

select * from v$logfile;

3、增加redo表空间

alter database add logfile group 4 ('/u01/app/oracle/oradata/ORCL/redo04.log') size 1024M;
alter database add logfile group 5 ('/u01/app/oracle/oradata/ORCL/redo05.log') size 1024M;
alter database add logfile group 6 ('/u01/app/oracle/oradata/ORCL/redo06.log') size 1024M;

4、即时生效。