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