重做日志文件太小切换时间太短

解决方案：
1）把日志文件组增多 3 > 5
2）把日志文件加大 50m > 200m

1、创建2个新的日志组
alter database add logfile group 4 ('/oracle/oradata/db01/redo04.log') size 200m;
alter database add logfile group 5 ('/oracle/oradata/db01/redo05.log') size 200m;

2、删除旧的日志组2、3
alter database drop logfile group 3;
alter database drop logfile group 2;

3、操作系统下删除原日志组2、3中的文件
[oracle@db01 db01]$ rm redo03.log
[oracle@db01 db01]$ rm redo02.log

4、重建日志组2、3
alter database add logfile group 2 ('/oracle/oradata/db01/redo02.log') size 200m;
alter database add logfile group 3 ('/oracle/oradata/db01/redo03.log') size 200m;

5、切换日志组
alter system switch logfile;
alter system checkpoint;

6、删除旧的日志组1
alter database drop logfile group 1;

7、操作系统下删除原日志组1中的文件
[oracle@db01 db01]$ rm redo01.log

8、重建日志组1
alter database add logfile group 1 ('/oracle/oradata/db01/redo01.log') size 200m;

9、配置日志组镜像
alter database add standby logfile group 6 ('/oracle/oradata/db01/redo06.log') size 200m;
alter database add standby logfile member '/oracle/oradata/db01/redo061.log' to group 6;