Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is my Oracle instance still running?

Re: Is my Oracle instance still running?

From: Jim Cheng <jim_pku_at_yahoo.com>
Date: 24 Oct 2004 23:00:06 -0700
Message-ID: <6028007c.0410242200.39f75bd8@posting.google.com>


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! Received on Mon Oct 25 2004 - 01:00:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US