Received: (qmail 16506 invoked from network); 11 Nov 2009 19:37:28 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 11 Nov 2009 19:37:24 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C28F1CB9334; Wed, 11 Nov 2009 20:37:22 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 6pvmxc33N0Wx; Wed, 11 Nov 2009 20:37:22 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 13109CB88C0; Wed, 11 Nov 2009 20:36:44 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 11 Nov 2009 20:36:03 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AD512BE606B for ; Wed, 11 Nov 2009 20:36:02 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id WW07IcTzIzBK for ; Wed, 11 Nov 2009 20:36:02 -0500 (EST) Received: from sidik.uaf.edu (sidik.uaf.edu [137.229.5.242]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9302534BC for ; Wed, 11 Nov 2009 20:36:00 -0500 (EST) Received: from [127.0.0.1] (sxmte-1.swits.alaska.edu [137.229.7.131]) by sidik.uaf.edu (8.13.8/8.13.8/uaf3) with ESMTP id nAC1Zuvf001564 for ; Wed, 11 Nov 2009 16:35:57 -0900 Message-ID: <4AFB6677.7000708@alaska.edu> Date: Wed, 11 Nov 2009 16:35:51 -0900 From: Maureen English User-Agent: Thunderbird 2.0.0.23 (Windows/20090812) MIME-Version: 1.0 To: oracle-l@freelists.org Subject: Database won't startup after system crash References: <7877ab4b0911090601r75516326ib0776f16c728fe3c@mail.gmail.com> <72C98B7E93B844408CAB9C90FB766739@rsiz.com> <7877ab4b0911090847m12df9a8ej400aabaf294ee7be@mail.gmail.com> <7877ab4b0911090943o6b9b8c79l611fb310d3359483@mail.gmail.com> <56211FD5795F8346A0719FEBC0DB0675054FC777@mds3aex08.USIEXCHANGE.COM> <8CC2F7F25C3E57A-A94-E696@web-mmc-d04.sysops.aol.com> <69eafc3f0911091020v4f5eac09q3dfc0317cac4e55f@mail.gmail.com> <01a001ca624b$f090c850$d1b258f0$@com> In-Reply-To: <01a001ca624b$f090c850$d1b258f0$@com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-archive-position: 22580 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: maureen.english@alaska.edu Precedence: normal Reply-to: maureen.english@alaska.edu List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l One of our systems crashed yesterday and now one of the databases that was running on it won't start up. When I try to startup the database, it looks like everything is fine until it tries to open the database. It does the crash recovery, but then terminates when opening the database. The messages in the trace file are the same as in the alert log. Per Oracle Support, I tried setting an init parameter to offline the rollback segment, but that didn't make any difference. I did a dbv on all of the datafiles and got no errors. Any comments/suggestions? I do have an open SR...My Oracle Support seems to be functioning better today. I'm getting the following message in the alert log: ... Wed Nov 11 10:15:33 2009 ALTER DATABASE OPEN Wed Nov 11 10:15:34 2009 Beginning crash recovery of 1 threads parallel recovery started with 7 processes Wed Nov 11 10:15:35 2009 Started redo scan Wed Nov 11 10:15:35 2009 Completed redo scan 0 redo blocks read, 0 data blocks need recovery Wed Nov 11 10:15:35 2009 Started redo application at Thread 1: logseq 1160, block 2, scn 8606018842 Wed Nov 11 10:15:35 2009 Recovery of Online Redo Log: Thread 1 Group 5 Seq 1160 Reading mem 0 Mem# 0: /XXXX02/ORACLE/logs/redo05aXXXX.log Mem# 1: /XXXX03/ORACLE/logs/redo05bXXXX.log Wed Nov 11 10:15:35 2009 Completed redo application Wed Nov 11 10:15:35 2009 Completed crash recovery at Thread 1: logseq 1160, block 2, scn 8606038843 0 data blocks read, 0 data blocks written, 0 redo blocks read Wed Nov 11 10:15:36 2009 Thread 1 advanced to log sequence 1161 (thread open) Thread 1 opened at log sequence 1161 Current log# 1 seq# 1161 mem# 0: /XXXX02/ORACLE/logs/redo01aXXXX.log Current log# 1 seq# 1161 mem# 1: /XXXX03/ORACLE/logs/redo01bXXXX.log Successful open of redo thread 1 Wed Nov 11 10:15:36 2009 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Nov 11 10:15:36 2009 SMON: enabling cache recovery Wed Nov 11 10:15:36 2009 ORA-01555 caused by SQL statement below (SQL ID: 4krwuz0ctqxdt, Query Duration=1257966936 sec, SCN: 0x0002.00f5bb40): Wed Nov 11 10:15:36 2009 select ctime, mtime, stime from obj$ where obj# = :1 Wed Nov 11 10:15:36 2009 Errors in file /ORACLE/home/admin/XXXX/udump/xxxx_ora_12746.trc: ORA-00704: bootstrap process failure ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 1 ORA-01555: snapshot too old: rollback segment number 10 with name "_SYSSMU10$" too small Error 704 happened during db open, shutting down database USER: terminating instance due to error 704 Instance terminated by USER, pid = 12746 ORA-1092 signalled during: ALTER DATABASE OPEN... - Maureen -- http://www.freelists.org/webpage/oracle-l