Re: Is my Oracle instance still running?

Jim Cheng wrote:

> Here are the last 80 lines or so of the alert_MYDB.log
>
> Thu Oct 21 16:54:16 2004
> Thread 1 advanced to log sequence 4668
> Current log# 8 seq# 4668 mem# 0: /oracle/MYDB/redo/redoMYDB_08.log
> Thu Oct 21 17:00:35 2004
> Thread 1 advanced to log sequence 4669
> Current log# 9 seq# 4669 mem# 0: /oracle/MYDB/redo/redoMYDB_09.log
> Thu Oct 21 17:07:52 2004
> Thread 1 advanced to log sequence 4670
> Current log# 10 seq# 4670 mem# 0: /oracle/MYDB/redo/redoMYDB_10.log
> Thu Oct 21 18:22:58 2004
> Thread 1 advanced to log sequence 4671
> Current log# 1 seq# 4671 mem# 0: /oracle/MYDB/redo/redoMYDB_01.log
> Thu Oct 21 18:39:03 2004
> Thread 1 advanced to log sequence 4672
> Current log# 2 seq# 4672 mem# 0: /oracle/MYDB/redo/redoMYDB_02.log
> Thu Oct 21 18:54:16 2004
> Thread 1 advanced to log sequence 4673
> Current log# 3 seq# 4673 mem# 0: /oracle/MYDB/redo/redoMYDB_03.log
> Thu Oct 21 19:09:44 2004
> Thread 1 advanced to log sequence 4674
> Current log# 4 seq# 4674 mem# 0: /oracle/MYDB/redo/redoMYDB_04.log
> Fri Oct 22 10:54:06 2004
> Errors in file /oracle/MYDB/strace/MYDB_smon_25911.trc:
> ORA-01595: error freeing extent (2) of rollback segment (3))
> ORA-01594: attempt to wrap into rollback segment (3) extent (2) which is being freed
> Fri Oct 22 13:20:24 2004
> Thread 1 advanced to log sequence 4675
> Current log# 5 seq# 4675 mem# 0: /oracle/MYDB/redo/redoMYDB_05.log
> Fri Oct 22 13:29:14 2004
> Thread 1 advanced to log sequence 4676
> Current log# 6 seq# 4676 mem# 0: /oracle/MYDB/redo/redoMYDB_06.log
> Fri Oct 22 17:58:29 2004
> Thread 1 advanced to log sequence 4677
> Current log# 7 seq# 4677 mem# 0: /oracle/MYDB/redo/redoMYDB_07.log
> Fri Oct 22 18:02:08 2004
> Thread 1 advanced to log sequence 4678
> Current log# 8 seq# 4678 mem# 0: /oracle/MYDB/redo/redoMYDB_08.log
> Fri Oct 22 18:06:01 2004
> Thread 1 advanced to log sequence 4679
> Current log# 9 seq# 4679 mem# 0: /oracle/MYDB/redo/redoMYDB_09.log
> Fri Oct 22 18:10:24 2004
> Thread 1 advanced to log sequence 4680
> Current log# 10 seq# 4680 mem# 0: /oracle/MYDB/redo/redoMYDB_10.log
> Fri Oct 22 18:15:14 2004
> Thread 1 advanced to log sequence 4681
> Current log# 1 seq# 4681 mem# 0: /oracle/MYDB/redo/redoMYDB_01.log
> Fri Oct 22 18:19:16 2004
> Thread 1 advanced to log sequence 4682
> Current log# 2 seq# 4682 mem# 0: /oracle/MYDB/redo/redoMYDB_02.log
> Fri Oct 22 18:25:48 2004
> Thread 1 advanced to log sequence 4683
> Current log# 3 seq# 4683 mem# 0: /oracle/MYDB/redo/redoMYDB_03.log
> Fri Oct 22 18:30:13 2004
> Thread 1 advanced to log sequence 4684
> Current log# 4 seq# 4684 mem# 0: /oracle/MYDB/redo/redoMYDB_04.log
> Fri Oct 22 18:33:29 2004
> Thread 1 advanced to log sequence 4685
> Current log# 5 seq# 4685 mem# 0: /oracle/MYDB/redo/redoMYDB_05.log
> Fri Oct 22 18:48:23 2004
> Thread 1 advanced to log sequence 4686
> Current log# 6 seq# 4686 mem# 0: /oracle/MYDB/redo/redoMYDB_06.log
> Sat Oct 23 00:16:00 2004
> Thread 1 advanced to log sequence 4687
> Current log# 7 seq# 4687 mem# 0: /oracle/MYDB/redo/redoMYDB_07.log
> Sat Oct 23 02:34:36 2004
> Thread 1 advanced to log sequence 4688
> Current log# 8 seq# 4688 mem# 0: /oracle/MYDB/redo/redoMYDB_08.log
> Sat Oct 23 02:47:09 2004
> Thread 1 advanced to log sequence 4689
> Current log# 9 seq# 4689 mem# 0: /oracle/MYDB/redo/redoMYDB_09.log
> Sat Oct 23 03:07:29 2004
> Thread 1 advanced to log sequence 4690
> Current log# 10 seq# 4690 mem# 0: /oracle/MYDB/redo/redoMYDB_10.log
> Sat Oct 23 06:31:45 2004
> Errors in file /oracle/MYDB/strace/MYDB_pmon_25903.trc:
> ORA-00476: RECO process terminated with error
> Sat Oct 23 06:31:45 2004
> PMON: terminating instance due to error 476
> Instance terminated by PMON, pid = 25903
>
>
> Thanks!

Key on:
Errors in file /oracle/MYDB/strace/MYDB_smon_25911.trc: ORA-01595: error freeing extent (2) of rollback segment (3)) ORA-01594: attempt to wrap into rollback segment (3) extent (2) which is being freed

Assuming 8i you need larger rollback segments. But before you do ... go to metalink and look up these error messages for your version.

Assuming 9i or 10g you need to get rid of them and use an UNDO tablespace.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)