| Instance terminate by lgwr process - error 470 [message #276186] |
Wed, 24 October 2007 05:42  |
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 #276199 is a reply to message #276198] |
Wed, 24 October 2007 06:19  |
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 #276261 is a reply to message #276245] |
Wed, 24 October 2007 09:54 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
