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 -> database won't open - ORA-470 error?

database won't open - ORA-470 error?

From: Glen A Stromquist <gstromquist_at_nospamyahoo.com>
Date: Thu, 28 Mar 2002 17:54:49 GMT
Message-ID: <JNIo8.6425$tI2.199369@news2.telusplanet.net>


I tried opening a test database I seldom use, and can't get past the database mounting. Looking at the alert log shows the following:

Thu Mar 28 10:30:16 2002
alter database open

Thu Mar 28 10:30:16 2002
Beginning crash recovery of 1 threads
Thu Mar 28 10:30:16 2002
Thread recovery: start rolling forward thread 1 Recovery of Online Redo Log: Thread 1 Group 3 Seq 5829 Reading mem 0   Mem# 0 errs 0: C:\ORACLE\ORADATA\EIRT\REDO03EIRT.LOG   Mem# 1 errs 0: C:\ORACLE\ORADATA\EIRT\REDO03AEIRT.LOG Thu Mar 28 10:30:18 2002
Thread recovery: finish rolling forward thread 1 Thread recovery: 0 data blocks read, 0 data blocks written, 1 redo blocks read
Crash recovery completed successfully
Thu Mar 28 10:30:18 2002
Thread 1 advanced to log sequence 5830
Thread 1 opened at log sequence 5830
  Current log# 1 seq# 5830 mem# 0: C:\ORACLE\ORADATA\EIRT\REDO01EIRT.LOG   Current log# 1 seq# 5830 mem# 1: C:\ORACLE\ORADATA\EIRT\REDO01AEIRT.LOG Successful open of redo thread 1.
Thu Mar 28 10:30:19 2002
PMON: terminating instance due to error 470 Thu Mar 28 10:30:19 2002
ORA-470 signalled during: alter database open ...
Thu Mar 28 10:30:20 2002
Instance terminated by PMON, pid = 2920

 I am currently wading through various doc's on OTN, but am finding little in the way of finding out what has happened & why it happened.

I ran DBV on all of the datafiles, and only reported one error :

DBVERIFY - Verification starting : FILE = RBS01.DBF Block Checking: DBA = 8388610, Block Type = Unlimited undo segment header Found block already marked corrupted

DBVERIFY - Verification complete

Total Pages Examined         : 133120
Total Pages Processed (Data) : 0
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 59649
Total Pages Empty            : 73471
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0



Since this is just a test DB it is not critical, but I still want to find out what happened, what caused it and how to recover from it.

Am I missing something here?

thanks Received on Thu Mar 28 2002 - 11:54:49 CST

Original text of this message

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