Re: ORA-00470: LGWR process terminated with error

From: Alberto Frosi <>
Date: Thu, 11 Mar 2010 03:28:14 -0800 (PST)
Message-ID: <>

On 10 Mar, 13:07, Johne_uk <> wrote:
> Hi,
> I am currently running two Oracle 10G instances from a single Solaris
> M4000 server. Every few days one of the instances crashes with the
> following error and has to be restarted.
> ORA-00470: LGWR process terminated with error
> PMON: terminating instance due to error 470
> I have spend weeks running various trace files etc with Oracle support
> and they are basically clueless as to what is the cause. They are
> saying it is a Solaris OS issue but surely this would affect both
> instances and not just one.
> 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 ?
> Thanks in advance
> John

For example for the better analysis i ask, the LGWR process it's always the same for the same instance or is it ramdom? because otherwise could be a hundred of variables for OS for DB. Received on Thu Mar 11 2010 - 05:28:14 CST

Original text of this message