Redo Log造成log file switch (checkpoint incomplete)

log file switch (checkpoint incomplete)
    一次生成数据库Redo 不够所造成log file switch (checkpoint incomplete)
    awr报告
        

解決方案：

增加Redo Log組、增加Redo Log成員大小、将redo 独立到I/O较高的盘符

alter database add logfile group 1('/u01/redo/redo01_01.log','/u01/redo01/redo01_02.log') size 256M;

alter database add logfile group 2('/u01/redo01/redo02_01.log','/u01/redo/redo02_02.log') size 256M;

alter database add logfile group 3('/u01/redo/redo03_01.log','/u01/redo01/redo03_02.log') size 256M;

alter database add logfile group 4('/u01/redo/redo04_01.log','/u01/redo01/redo04_02.log') size 256M;

alter database add logfile group 5('/u01/redo/redo05_01.log','/u01/redo01/redo05_02.log') size 256M;

alter database add logfile group 6('/u01/redo/redo06_01.log','/u01/redo01/redo06_02.log') size 256M;

alter database add logfile group 7('/u01/redo/redo07_01.log','/u01/redo01/redo07_02.log') size 256M;

alter database add logfile group 8('/u01/redo/redo08_01.log','/u01/redo01/redo08_02.log') size 256M;

 

 select group#,status from v$log;

  select group#,status from v$standby_log;

 alter system checkpoint;

 alter system switch logfile;

 alter database drop logfile group 1;

 

*.db_writer_processes=6

*.dbwr_io_slaves=0

*.disk_asynch_io=TRUE

其他参考

https://sites.google.com/site/embtdbo/wait-event-documentation/oracle-redo-log-waits

http://www.cnblogs.com/jianggc/articles/2205198.html