Re: Is my Oracle instance still running?

"Jim Cheng" <jim_pku_at_yahoo.com> wrote in message news:6028007c.0410242200.39f75bd8_at_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!

Well that ORA-00476 is a definate clue. If the recovery process (RECO) is killed, then PMON must
shutdown the database, otherwise you will be into a no-recovery possible situation.

Now, why did RECO die? Check for problem in /var/adm/messages (or the linux equivalent),
also check the 25903.trc file in strace. Do you have archivelog mode enabled? Is it automatically
archiving logs? It does not look like it? It might be in some kind of half archiving mode? Received on Tue Oct 26 2004 - 18:30:47 CDT