oracle cannot allocate new log,【~~请教各位高手Thread 1 cannot allocate new log】-Oracle论坛-ZOL中关村在线...

Wed Aug  1 09:41:09 2007

Thread 1 advanced to log sequence 3536

Current log# 3 seq# 3536 mem# 0: /u01/app/oracle/oradata/d3main/redo3_1.log

Current log# 3 seq# 3536 mem# 1: /u01/app/oracle/oradata/d3main/redo3_2.log

Wed Aug  1 10:11:18 2007

Thread 1 advanced to log sequence 3537

Current log# 2 seq# 3537 mem# 0: /u01/app/oracle/oradata/d3main/redo2_1.log

Current log# 2 seq# 3537 mem# 1: /u01/app/oracle/oradata/d3main/redo2_2.log

Wed Aug  1 10:21:47 2007

Thread 1 advanced to log sequence 3538

Current log# 4 seq# 3538 mem# 0: /u01/app/oracle/oradata/d3main/redo4_1.log

Current log# 4 seq# 3538 mem# 1: /u01/app/oracle/oradata/d3main/redo4_2.log

Wed Aug  1 10:26:19 2007

Thread 1 advanced to log sequence 3539

Current log# 1 seq# 3539 mem# 0: /u01/app/oracle/oradata/d3main/redo1_1.log

Current log# 1 seq# 3539 mem# 1: /u01/app/oracle/oradata/d3main/redo1_2.log

Wed Aug  1 10:31:46 2007

Thread 1 advanced to log sequence 3540

Current log# 3 seq# 3540 mem# 0: /u01/app/oracle/oradata/d3main/redo3_1.log

Current log# 3 seq# 3540 mem# 1: /u01/app/oracle/oradata/d3main/redo3_2.log

Wed Aug  1 10:36:59 2007

Thread 1 advanced to log sequence 3541

Current log# 2 seq# 3541 mem# 0: /u01/app/oracle/oradata/d3main/redo2_1.log

Current log# 2 seq# 3541 mem# 1: /u01/app/oracle/oradata/d3main/redo2_2.log

Wed Aug  1 10:43:27 2007

Thread 1 advanced to log sequence 3542

Current log# 4 seq# 3542 mem# 0: /u01/app/oracle/oradata/d3main/redo4_1.log

Current log# 4 seq# 3542 mem# 1: /u01/app/oracle/oradata/d3main/redo4_2.log

Wed Aug  1 10:50:33 2007

Thread 1 cannot allocate new log, sequence 3543

Private strand flush not complete

Current log# 4 seq# 3542 mem# 0: /u01/app/oracle/oradata/d3main/redo4_1.log

Current log# 4 seq# 3542 mem# 1: /u01/app/oracle/oradata/d3main/redo4_2.log

Wed Aug  1 10:50:44 2007

Thread 1 advanced to log sequence 3543

Current log# 1 seq# 3543 mem# 0: /u01/app/oracle/oradata/d3main/redo1_1.log

Current log# 1 seq# 3543 mem# 1: /u01/app/oracle/oradata/d3main/redo1_2.log

Wed Aug  1 10:58:46 2007

Thread 1 cannot allocate new log, sequence 3544

Private strand flush not complete

Current log# 1 seq# 3543 mem# 0: /u01/app/oracle/oradata/d3main/redo1_1.log

Current log# 1 seq# 3543 mem# 1: /u01/app/oracle/oradata/d3main/redo1_2.log

Thread 1 advanced to log sequence 3544

Current log# 3 seq# 3544 mem# 0: /u01/app/oracle/oradata/d3main/redo3_1.log

Current log# 3 seq# 3544 mem# 1: /u01/app/oracle/oradata/d3main/redo3_2.log

Wed Aug  1 11:06:50 2007

Thread 1 cannot allocate new log, sequence 3545

Private strand flush not complete

Current log# 3 seq# 3544 mem# 0: /u01/app/oracle/oradata/d3main/redo3_1.log

Current log# 3 seq# 3544 mem# 1: /u01/app/oracle/oradata/d3main/redo3_2.log

Wed Aug  1 11:07:05 2007

Thread 1 advanced to log sequence 3545

Current log# 2 seq# 3545 mem# 0: /u01/app/oracle/oradata/d3main/redo2_1.log

Current log# 2 seq# 3545 mem# 1: /u01/app/oracle/oradata/d3main/redo2_2.log

Wed Aug  1 11:14:11 2007

Thread 1 cannot allocate new log, sequence 3546

Private strand flush not complete

Current log# 2 seq# 3545 mem# 0: /u01/app/oracle/oradata/d3main/redo2_1.log

Current log# 2 seq# 3545 mem# 1: /u01/app/oracle/oradata/d3main/redo2_2.log

Wed Aug  1 11:14:23 2007

Thread 1 advanced to log sequence 3546

Current log# 4 seq# 3546 mem# 0: /u01/app/oracle/oradata/d3main/redo4_1.log

Current log# 4 seq# 3546 mem# 1: /u01/app/oracle/oradata/d3main/redo4_2.log

Wed Aug  1 11:26:47 2007

Thread 1 advanced to log sequence 3547

Current log# 1 seq# 3547 mem# 0: /u01/app/oracle/oradata/d3main/redo1_1.log

Current log# 1 seq# 3547 mem# 1: /u01/app/oracle/oradata/d3main/redo1_2.log