Home » RDBMS Server » Server Administration » Instance terminate by lgwr process - error 470 (Oracle 10.1.0.5)
Instance terminate by lgwr process - error 470 [message #276186] Wed, 24 October 2007 05:42 Go to next message
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
Member
Errors in file c:\oracle\product\admin\galileo\bdump\galileo_smon_3780.trc:
ORA-00470: LGWR process terminated with error

Wed Oct 24 10:10:17 2007
Instance terminated by PMON, pid = 3720

process id 3270 is

** 2007-10-24 10:09:42.994
*** SERVICE NAME:(SYS$BACKGROUND) 2007-10-24 10:09:42.941
*** SESSION ID:(665.1) 2007-10-24 10:09:42.941
error 470 detected in background process
ORA-00470: LGWR process terminated with error

--
Is this due to a bug or is there any solution for this.
Re: Instance terminate by lgwr process - error 470 [message #276198 is a reply to message #276186] Wed, 24 October 2007 06:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have toknow why the process terminates.
Is there something else in the trace file?
Is there any other traces with about the same timestamp?
Is there any message in alert.log?
Is there any version of your Oracle installation?

Regards
Michel
Re: Instance terminate by lgwr process - error 470 [message #276199 is a reply to message #276198] Wed, 24 October 2007 06:19 Go to previous messageGo to next message
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
Member
There are no other errors. All the trace file errors indicate the same error.

it start with this
---
Errors in file c:\oracle\product\admin\bdump\pieo_pmon_3720.trc:
ORA-00470: LGWR process terminated with error

and pieo_pmon_3720.trc has this

RACLE V10.1.0.5.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2
CPU : 2 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:937M/3583M, Ph+PgF:4963M/7560M, VA:553M/3071M
Instance name: lieo

Redo thread mounted by this instance: 1

Oracle process number: 2

Windows thread id: 3720, image: ORACLE.EXE (PMON)


*** 2007-10-24 10:09:42.994
*** SERVICE NAME:(SYS$BACKGROUND) 2007-10-24 10:09:42.941
*** SESSION ID:(665.1) 2007-10-24 10:09:42.941
error 470 detected in background process
ORA-00470: LGWR process terminated with error
---

all the processes indicate the same error. I susppect it to be log switch waits or something to do with the configurations of the log files and standby.
Re: Instance terminate by lgwr process - error 470 [message #276245 is a reply to message #276199] Wed, 24 October 2007 08:49 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Did you check Alert<sid>.log file on both side " primary db or standby db"

did your try to startup after clean shutdown.


Regards
MOhammed Taj
Re: Instance terminate by lgwr process - error 470 [message #276261 is a reply to message #276245] Wed, 24 October 2007 09:54 Go to previous message
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
Member
No errors related in the standby alert log;

----
FS[205]: Assigned to RFS process 5420
RFS[205]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
RFS[205]: Archivelog thread 1 sequence 78801 cannot be reused
Wed Oct 24 10:08:36 2007
Errors in file c:\oracle\product\admin\udump\lieo_rfs_5420.trc:
ORA-16401: archivelog rejected by RFS

Wed Oct 24 10:08:36 2007
RFS[122]: No standby redo logfiles created
RFS[122]: Archived Log: 'E:\ORACLE\FLASH_RECOVERY_AREA\ARCHIVELOG\2007_10_24\O1_MF_1_78802_3KY2WNMC_.ARC'
Committing creation of archivelog 'E:\ORACLE\FLASH_RECOVERY_AREA\ARCHIVELOG\2007_10_24\O1_MF_1_78802_3KY2WNMC_.ARC'
Created Oracle managed file
-----


The performance statistics on the database before the instance crash show log file wait event top 5.


Top 5 Timed Events

Event
Waits
Time(s)
Percent Total DB Time
Wait Class

log file switch (archiving needed)
8,009
7,763
17.33
Configuration

ARCH wait on SENDREQ
7,844
7,478
16.70
Network

db file sequential read
3,002,001
7,202
16.08
User I/O

enq: TM - contention
2,067
6,121
13.67
Application

db file scattered read
1,613,532
5,900
13.17
User I/O






Previous Topic: AWR and statspack usage on Oracle 10g Database
Next Topic: Character set
Goto Forum:
  


Current Time: Sat Dec 03 18:23:39 CST 2016

Total time taken to generate the page: 0.20226 seconds