oracle数据库日志进程,ORACLE数据库db write进程及redo log不足导致minact-scn useg scan erroring out with error e12751错误 ...

今天又遇到了db write进程不足，导致数据库缓慢的问题，同事在搭建这个数据库时，忘了告诉他修改db write进程的个数，测试人员在大量修改和迁入数据时，数据库突然没有响应，程序连接不上数据库。我在本地登录时，将近五分钟才登录到数据库，观察告警日志发现大量的cannot allocate new log提示，这说明redo log不足，导致日志无法切换，但最根本的原因还是db write进程不足导致的。

Thu Apr 21 17:28:41 2016

Thread 1 cannot allocate new log, sequence 132

Checkpoint not complete

Current log# 5 seq# 131 mem# 0: /u01/app/oracle/oradata/ivldb/redo08.log

Thu Apr 21 17:31:33 2016

Thread 1 advanced to log sequence 132 (LGWR switch)

Current log# 6 seq# 132 mem# 0: /u01/app/oracle/oradata/ivldb/redo03.log

Thu Apr 21 17:31:43 2016

Archived Log entry 126919 added for thread 1 sequence 131 ID 0x52f4e8d7 dest 1:

Thu Apr 21 17:32:19 2016

Thread 1 cannot allocate new log, sequence 133

Checkpoint not complete

Current log# 6 seq# 132 mem# 0: /u01/app/orac