数据库日志报错问题分析
Thread 1 cannot allocate new log, sequence 466 Private strand flush not complete Current log# 7 seq# 465 mem# 0: /home/app/oracle/oradata/orcl/redo07.log Thread 1 advanced to log sequence 466 (LGWR switch) Current log# 8 seq# 466 mem# 0: /home/app/oracle/oradata/orcl/redo08.log Mon Jul 28 15:27:42 2014 Thread 1 cannot allocate new log, sequence 467 Private strand flush not complete Current log# 8 seq# 466 mem# 0: /home/app/oracle/oradata/orcl/redo08.log Thread 1 advanced to log sequence 467 (LGWR switch) Current log# 9 seq# 467 mem# 0: /home/app/oracle/oradata/orcl/redo09.log Mon Jul 28 15:31:16 2014 Thread 1 cannot allocate new log, sequence 468 Private strand flush not complete Current log# 9 seq# 467 mem# 0: /home/app/oracle/oradata/orcl/redo09.log Thread 1 advanced to log sequence 468 (LGWR switch) Current log# 4 seq# 468 mem# 0: /home/app/oracle/oradata/orcl/redo04.log Mon Jul 28 15:34:53 2014 Thread 1 cannot allocate new log, sequence 469 Private strand flush not complete Current log# 4 seq# 468 mem# 0: /home/app/oracle/oradata/orcl/redo04.log Thread 1 advanced to log sequence 469 (LGWR switch) Current log# 5 seq# 469 mem# 0: /home/app/oracle/oradata/orcl/redo05.log Mon Jul 28 15:38:26 2014 Thread 1 cannot allocate new log, sequence 470 Private strand flush not complete Current log# 5 seq# 469 mem# 0: /home/app/oracle/oradata/orcl/redo05.log Thread 1 advanced to log sequence 470 (LGWR switch) Current log# 6 seq# 470 mem# 0: /home/app/oracle/oradata/orcl/redo06.log