Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> database won't open - ORA-470 error?
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