Re: database won't open - ORA-470 error?

Glen,

Did you setup high value for LOG_CHECKPOINT_TIMEOUT?

I have seen such error when this parameter is setup to high.

Check the latest Oracle DBA forums for solutions to your problems: http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

Hope that helps,

Trifon Anguelov
Senior Oracle DBA

http://www.dbaclick.com

"Glen A Stromquist" <gstromquist_at_nospamyahoo.com> wrote in message news:JNIo8.6425$tI2.199369_at_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 Sat Mar 30 2002 - 21:28:11 CST