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

On Thu, 28 Mar 2002 17:54:49 GMT, "Glen A Stromquist" <gstromquist_at_nospamyahoo.com> wrote:

>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
>
>
>

according to tahiti.oracle.com

referring to
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76999/e0.htm#1002456

ora-470 means
ORA-00470 LGWR process terminated with error

Cause: The Log Writer process terminated abnormally.

Action: Check the accompanying messages, and the background process trace file. Correct the problem mentioned in the messages. Then shut down and restart the instance. If the trace file mentions any other background process messages, check the trace file for the mentioned process until the root message is found.

Please always try to search the error messages either in the Oracle Server Messages or tahiti.oracle.com and include the text in your post.

Now it's up to you to look at the LGWR.trc file, we would have been more up to speed, if you didn't start to 'wade through documents'

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Mar 28 2002 - 15:01:59 CST