设置oracle数据库redo日志大小

1、查看当前日志组成员
sql> select member from v$logfile;
2、查看当前日志组状态

sql> select group#,members,bytes/1024/1024.status from v$log;

3、增加日志组

sql> alter database add logfile group 4 ('/opt/oracle/oradata/oral/redo04.log') size 200M;
sql> alter database add logfile group 5 ('/opt/oracle/oradata/oral/redo05.log') size 200M;
sql