Thread 1 cannot allocate new log, sequence NNN 错误

-- 错误代码举例:(from alert_DBSID.log)

Tue Mar 15 18:35:21 2011
+188791 Thread 1 advanced to log sequence 783 (LGWR switch)
+188792 Current log# 3 seq# 783 mem# 0: /opt/app/oracle/oradata/Homelink/redo03.log
+188793 Thread 1 cannot allocate new log, sequence 784
+188794 Checkpoint not complete
+188795 Current log# 3 seq# 783 mem# 0: /opt/app/oracle/oradata/Homelink/redo03.log
+188796 Thread 1 advanced to log sequence 784 (LGWR switch)
+188797 Current log# 1 seq# 784 mem# 0: /opt/app/oracle/oradata/Homelink/redo01.log
+188798 Thread 1 cannot allocate new log, sequence 785

--原因, REDOLOG 太小.

--解决,新建较大的REDOLOG,删除旧的REDOLOG.

--REFERENCE LINK:

http://hi.baidu.com/itoracle/blog/item/0e15068a8861c7739e2fb4be.html
SQL>alter system switch logfile;

SQL>alter database drop logfile group 1;

SQL>alter database drop logfile group 2;

SQL>alter database drop logfile group 3;

SQL>alter database drop logfile group 4;

3.重建重做日志组1,2,3,4，大小设置为200M

SQL>alter database add logfile thread 1 group 1 size 200m;

SQL>alter database add logfile thread 2 group 2 size 200m;

SQL>alter database add logfile thread 1 group 3 size 200m;

SQL>alter database add logfile thread 2 group 4 size 200m;

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/350519/viewspace-1047597/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/350519/viewspace-1047597/