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

From: Glen A Stromquist <glen_stromquist_at_nospam.yahoo.com>
Date: Thu, 28 Mar 2002 21:50:31 GMT
Message-ID: <HeMo8.6466$tI2.212048@news2.telusplanet.net>

I had already looked up the ORA error on OTN, and for some reason there is no LGWR.trc file. The DBWR and PMON trc files say basically the same thing, the "error 470 detected in background process" and not a lot else.

The text from these trc files is as follows:

Dump file C:\ORACLE\admin\EIRT\bdump\eirtPMON.TRC Thu Mar 28 08:41:35 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 1, CPU type 586 Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 1, CPU type 586 Instance name: eirt

Redo thread mounted by this instance: 1

Oracle process number: 2

Windows thread id: 1328, image: ORACLE.EXE

2002-03-28 08:41:35.180
SESSION ID:(1.1) 2002-03-28 08:41:35.180 error 470 detected in background process Dump file C:\ORACLE\admin\EIRT\bdump\eirtPMON.TRC Thu Mar 28 10:30:19 2002 ORACLE V8.1.7.0.0 - Production vsnsta=0 vsnsql=e vsnxtr=3 Windows 2000 Version 5.0 Service Pack 1, CPU type 586 Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Windows 2000 Version 5.0 Service Pack 1, CPU type 586 Instance name: eirt

Redo thread mounted by this instance: 1

Oracle process number: 2

Windows thread id: 2920, image: ORACLE.EXE

2002-03-28 10:30:19.496
SESSION ID:(1.1) 2002-03-28 10:30:19.486 error 470 detected in background process

Dump file C:\ORACLE\admin\EIRT\bdump\eirtDBW0.TRC Thu Mar 28 08:41:35 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 1, CPU type 586 Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 1, CPU type 586 Instance name: eirt

Redo thread mounted by this instance: 1

Oracle process number: 3

Windows thread id: 1564, image: ORACLE.EXE

2002-03-28 08:41:35.640
SESSION ID:(2.1) 2002-03-28 08:41:35.270 error 470 detected in background process Dump file C:\ORACLE\admin\EIRT\bdump\eirtDBW0.TRC Thu Mar 28 10:30:19 2002 ORACLE V8.1.7.0.0 - Production vsnsta=0 vsnsql=e vsnxtr=3 Windows 2000 Version 5.0 Service Pack 1, CPU type 586 Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Windows 2000 Version 5.0 Service Pack 1, CPU type 586 Instance name: eirt

Redo thread mounted by this instance: 1

Oracle process number: 3

Windows thread id: 840, image: ORACLE.EXE

2002-03-28 10:30:19.977
SESSION ID:(2.1) 2002-03-28 10:30:19.777 error 470 detected in background process

Received on Thu Mar 28 2002 - 15:50:31 CST