Failure to extend rollback segment 2 because of 1000 condition

Tue Nov 22 01:58:21 2011
ARC0: Evaluating archive   log 3 thread 1 sequence 3433
ARC0: Beginning to archive log 3 thread 1 sequence 3433
Creating archive destination LOG_ARCHIVE_DEST_1: '/data/imb/arch/1_3433.arc'
ARC0: Completed archiving  log 3 thread 1 sequence 3433
Tue Nov 22 02:23:37 2011
Failure to extend rollback segment 2 because of 1000 condition
FULL status of rollback segment 2 set.
Tue Nov 22 02:28:06 2011
SMON: FULL status of rollback segment 2 cleared.
Tue Nov 22 02:33:23 2011
Thread 1 advanced to log sequence 3435
  Current log# 2 seq# 3435 mem# 0: /u01/product/oradata/imb/redo02a.log
  Current log# 2 seq# 3435 mem# 1: /data/imb/redo02b.log
Tue Nov 22 02:33:23 2011
ARC0: Evaluating archive   log 1 thread 1 sequence 3434
ARC0: Beginning to archive log 1 thread 1 sequence 3434
Creating archive destination LOG_ARCHIVE_DEST_1: '/data/imb/arch/1_3434.arc'
ARC0: Completed archiving  log 1 thread 1 sequence 3434

 

 

Followup   March 14, 2005 - 7pm Central time zone:

well, the 1000 is ora-1000


[tkyte@localhost tkyte]$ oerr ora 1000

01000, 00000, "maximum open cursors exceeded"

so it would seem that you were very close to max cursors --

needed to extend the rollback segment but the recursive SQL

failed (out of cursors) and so we marked the rollback 

segment "FULL" to prevent others from using it, when all 

transactions have committed that are using that RBS, it is 

marked "not full" 

 

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1441804355350 

 

 

 

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

转载于:http://blog.itpub.net/35489/viewspace-711747/