Imeju sledujuschuju situziju. Baza Ruchnula. Smotru b alert.log

Fri Nov 22 15:11:02 2002
ORA-1650: unable to extend rollback segment R02 by 6400 in tablespace RB
S

Failure to extend rollback segment 2 because of 1650 condition
FULL status of rollback segment 2 set.
Fri Nov 22 15:11:05 2002
Thread 1 advanced to log sequence 5207
Current log# 3 seq# 5207 mem# 0: /db/REF3/logs/log_03.dbf
Current log# 3 seq# 5207 mem# 1: /db/REF3/logsB/log_03.dbf
Fri Nov 22 15:11:05 2002
ARC0: Beginning to archive log# 2 seq# 5206
ARC0: Completed archiving log# 2 seq# 5206
Fri Nov 22 15:11:44 2002
Thread 1 advanced to log sequence 5208
Current log# 4 seq# 5208 mem# 0: /db/REF3/logs/log_04.dbf
Current log# 4 seq# 5208 mem# 1: /db/REF3/logsB/log_04.dbf
Fri Nov 22 15:11:44 2002
ARC0: Beginning to archive log# 3 seq# 5207
Fri Nov 22 15:11:55 2002
ARC0: Completed archiving log# 3 seq# 5207
Fri Nov 22 15:17:02 2002
ORA-1650: unable to extend rollback segment R02 by 6400 in tablespace RBS

Failure to extend rollback segment 2 because of 1650 condition
Fri Nov 22 15:18:45 2002
ORA-1650: unable to extend rollback segment R02 by 6400 in tablespace RBS

Failure to extend rollback segment 2 because of 1650 condition
Fri Nov 22 15:19:05 2002
Thread 1 advanced to log sequence 5209
Current log# 1 seq# 5209 mem# 0: /db/REF3/logs/log_01.dbf
Current log# 1 seq# 5209 mem# 1: /db/REF3/logsB/log_01.dbf
Fri Nov 22 15:19:05 2002
ARC0: Beginning to archive log# 4 seq# 5208
Fri Nov 22 15:19:08 2002
ORA-1650: unable to extend rollback segment R01 by 6400 in tablespace RBS

Failure to extend rollback segment 1 because of 1650 condition
FULL status of rollback segment 1 set.
ORA-1650: unable to extend rollback segment R01 by 6400 in tablespace RBS

Failure to extend rollback segment 1 because of 1650 condition
Error 1562 trapped in 2PC on transaction 1.43.21545. Cleaning up.
Error stack returned to user:
ORA-01562: failed to extend rollback segment number 1
ORA-01650: unable to extend rollback segment R01 by 6400 in tablespace RBS
ORA-1650: unable to extend rollback segment R01 by 6400 in tablespace RBS

Failure to extend rollback segment 1 because of 1650 condition
ORA-1650: unable to extend rollback segment R03 by 6400 in tablespace RBS

Failure to extend rollback segment 3 because of 1650 condition
FULL status of rollback segment 3 set.
Fri Nov 22 15:19:13 2002
ARC0: Completed archiving log# 4 seq# 5208
Fri Nov 22 15:19:17 2002
SMON: out of memory, downgrading to serial recovery
Fri Nov 22 15:21:00 2002
ORA-1650: unable to extend rollback segment R01 by 6400 in tablespace RBS

Failure to extend rollback segment 1 because of 1650 condition
Fri Nov 22 15:21:01 2002
ORA-1650: unable to extend rollback segment R03 by 6400 in tablespace RBS

Failure to extend rollback segment 3 because of 1650 condition
Fri Nov 22 15:21:15 2002
ORA-1650: unable to extend rollback segment R01 by 6400 in tablespace RBS

Failure to extend rollback segment 1 because of 1650 condition
Failure to extend rollback segment 1
Failure to extend rollback segment 1 because of 1562 condition
Failure to extend rollback segment 1
Failure to extend rollback segment 1 because of 1562 condition
Fri Nov 22 15:21:28 2002
Failure to extend rollback segment 1
Failure to extend rollback segment 1 because of 1562 condition
Fri Nov 22 15:22:41 2002
ORA-1650: unable to extend rollback segment R02 by 6400 in tablespace RBS

Failure to extend rollback segment 2 because of 1650 condition
Fri Nov 22 15:23:02 2002
ORA-1650: unable to extend rollback segment R03 by 6400 in tablespace RBS

Failure to extend rollback segment 3 because of 1650 condition
Fri Nov 22 15:23:36 2002
ORA-1650: unable to extend rollback segment R03 by 6400 in tablespace RBS

Failure to extend rollback segment 3 because of 1650 condition
Fri Nov 22 15:24:28 2002
Failure to extend rollback segment 1
Failure to extend rollback segment 1 because of 1562 condition
Fri Nov 22 15:35:06 2002
ORA-1650: unable to extend rollback segment R04 by 6400 in tablespace RBS
Failure to extend rollback segment 4 because of 1650 condition
FULL status of rollback segment 4 set.
Fri Nov 22 15:35:06 2002
ARC0: Completed archiving log# 1 seq# 5213
Fri Nov 22 15:36:07 2002
Errors in file /opt/oracle/REF3/admin/bdump/ref3_snp1_26739.trc:
ORA-12012: error on auto execute of job 43
ORA-01552: cannot use system rollback segment for non-system tablespace 'TOOLS'
ORA-06512: at "SYS.CRASH_INFO", line 41
ORA-06512: at line 1
Fri Nov 22 15:36:07 2002
Errors in file /opt/oracle/REF3/admin/bdump/ref3_snp1_26739.trc:
ORA-12012: error on auto execute of job 103
ORA-01552: cannot use system rollback segment for non-system tablespace 'TOOLS'
ORA-06512: at "SYS.CRASH_INFO", line 41
ORA-06512: at line 1
Fri Nov 22 15:38:10 2002
Errors in file /opt/oracle/REF3/admin/bdump/ref3_snp1_26739.trc:
ORA-12012: error on auto execute of job 43
ORA-01552: cannot use system rollback segment for non-system tablespace 'TOOLS'
ORA-06512: at "SYS.CRASH_INFO", line 41
ORA-06512: at line 1
Fri Nov 22 15:38:10 2002
Errors in file /opt/oracle/REF3/admin/bdump/ref3_snp0_26736.trc:
ORA-12012: error on auto execute of job 103
ORA-01552: cannot use system rollback segment for non-system tablespace 'TOOLS'
ORA-06512: at "SYS.CRASH_INFO", line 41
ORA-06512: at line 1
Fri Nov 22 15:38:31 2002
Shutting down instance (abort)
License high water mark = 1839
Instance terminated by USER, pid = 25455

delaju vyvod:

vse RBS FULL, ORACLE pytalsya dlya JOB's 103 i 43 SYSTEM RBS predostavit. SYSTEM RBS-FULL. Instance dolzhna po ideje stojat i zhdat poka Tranzakzii iz FULL RBS'ov otkatyatsya nazad. No v alerte stoit :

Fri Nov 22 15:38:31 2002
Shutting down instance (abort)
License high water mark = 1839
Instance terminated by USER, pid = 25455

kak ja mogu teper vychislit kto instanzu s ABORT opustil?
Ili mozhet byt eto sam ORACLE sdelal?

Danke vsem. Vychislil gada v audite.

Drugoj vopros.

Ili mog ORACLE opustit bazu jesli vse RBS FULL?

a eto potomu chto privatnyje R01- R04 k tomu vremeni FULL byli

bylo r01-04 init 50M next 50M minext=3 optimal 150m
stalo r01-20 init 10m next 10m minext 3 optimal 30m