Re: ORA-00470: LGWR process terminated with error

From: Mladen Gogala <>
Date: Wed, 10 Mar 2010 13:48:57 +0000 (UTC)
Message-ID: <hn8809$1mc$>

On Wed, 10 Mar 2010 04:07:48 -0800, Johne_uk wrote:

> Essentially something is killing the LGWR process and the instance is
> shutting itself down. I think the way ahead is to try and find out what
> is killing this process but I'm not sure how to go about this and
> worried that any logging may degrade server performance.
> Can anybody offer any suggestions ?

Let me see whether I understood you correctly: Oracle support is trying to fix your issue for weeks, they presumably have all the trace files, core files and RDA output but are unable to determine the exact cause of the problem despite having all this information and you are asking us to guess what the problem is without even knowing the version of the RDBMS and Solaris? No problem, I can do that. The answer to your problem is the number 42.

Received on Wed Mar 10 2010 - 07:48:57 CST

Original text of this message