昨天晚上Oracle停止了....帮忙看下log

显示全部楼层 · 2006-4-17 13:46:34

Current log# 5 seq# 151586 mem# 0: /up04/oradata/FWPDB/redo05a.log
Current log# 5 seq# 151586 mem# 1: /up07/oradata/FWPDB/redo05b.log
Thu May 27 03:32:01 2004
ARC0: Beginning to archive log# 2 seq# 151585
ARC0: Completed archiving log# 2 seq# 151585
Thu May 27 03:32:06 2004
Thread 1 advanced to log sequence 151587
Current log# 1 seq# 151587 mem# 0: /up03/oradata/FWPDB/redo01a.log
Current log# 1 seq# 151587 mem# 1: /up08/oradata/FWPDB/redo01b.log
Thu May 27 03:32:06 2004
ARC0: Beginning to archive log# 5 seq# 151586
Thu May 27 03:32:06 2004
ARC0: Beginning to archive log# 5 seq# 151586
Thu May 27 03:32:07 2004
Errors in file /up01/app/oracle/admin/FWPDB/bdump/lgwr_25167_fwpdb.trc:
ORA-07445: exception encountered: core dump [11] [3782948424] [205729360] [0] [] []
ARC0: Completed archiving log# 5 seq# 151586
Thu May 27 03:32:24 2004
Errors in file /up01/app/oracle/admin/FWPDB/bdump/pmon_25157_fwpdb.trc:
ORA-00470: LGWR process terminated with error
Thu May 27 03:32:24 2004
PMON: terminating instance due to error 470
Instance terminated by PMON, pid = 25157
Thu May 27 03:34:32 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.4.0.
System parameters with non-default values:
processes
= 521
shared_pool_size = 1024000000
dbwr_io_slaves = 0
control_files
= /up01/oradata/FWPDB/ctrlFWPDB_01.ctl, /up06/oradata/FWPDB/ctrlFWPDB_02.
ctl, /up11/oradata/FWPDB/ctrlFWPDB_03.ctl
db_block_buffers = 125000
db_block_size
= 8192
db_block_lru_latches = 4
db_writer_processes= 4
compatible
= 8.1.7.0.0
log_archive_start= TRUE
log_archive_dest = /up04/oradata/FWPDB/arch
log_archive_format = fwpdb_%s.arc
log_buffer
= 524288
log_checkpoint_interval= 35000000
log_checkpoint_timeout = 0
db_files
= 400
db_file_multiblock_read_count= 32
transactions_per_rollback_segment= 70
max_rollback_segments= 100
rollback_segments= rbs0, rbs1, rbs2, rbs3, rbs4, rbs5, rbs6
remote_login_passwordfile= EXCLUSIVE
global_names
= FALSE
sort_area_size = 32000000
db_name
= FWPDB

千问 · 2006-4-17 13:46:34

先把 /up01/app/oracle/admin/FWPDB/bdump/pmon_25157_fwpdb.trc 和 /up01/app/oracle/admin/FWPDB/bdump/lgwr_25167_fwpdb.trc 这两个文件的信息贴出来看看。

千问 · 2006-4-17 13:46:34

trace file 如下：
/up01/app/oracle/admin/FWPDB/bdump/pmon_25157_fwpdb.trc
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production
ORACLE_HOME = /apps/oracle
System name:HP-UX
Node name:szx021
Release:B.11.11
Version:U
Machine:9000/800
Instance name: FWPDB
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 25157, image: oracle@szx021 (PMON)
*** 2004-05-27 03:32:24.120
*** SESSION ID

1.1) 2004-05-27 03:32:24.119
error 470 detected in background process
ORA-00470: LGWR process terminated with error

千问 · 2006-4-17 13:46:34

/up01/app/oracle/admin/FWPDB/bdump/lgwr_25167_fwpdb.trc
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production
ORACLE_HOME = /apps/oracle
System name:HP-UX
Node name:szx021
Release:B.11.11
Version:U
Machine:9000/800
Instance name: FWPDB
Redo thread mounted by this instance: 1
Oracle process number: 7
Unix process pid: 25167, image: oracle@szx021 (LGWR)
*** SESSION ID

6.1) 2004-05-27 03:32:07.593
Exception signal: 11, code = 800003ffe17b3648
sc_onstack: 000000000c432e50, sc_mask 0000000000000000
ORA-07445: exception encountered: core dump [11] [3782948424] [205729360] [0] [] []
----- Call Stack Trace -----
calling
call entry
argument values in hex
location
type point
(? means dubious value)
-------------------- -------- -------------------- ----------------------------
ssexhd()+344 ?ksedst()
000000000 ?

800003FFE17B07E0 ?

800003FFE17B2EC8 ?

0009FE0F0 ?
_sigreturn()+0 ?ssexhd()
0009FE0D0 ? 000000000 ?

04BDF3E39 ?

800003FFE17B3100 ?
kgklookup()+252?_sigreturn() 800003FFE17B2C90 ?

000000001 ?

800000010006A140 ?

C000000081B33260 ?
kgfddsa()+140?kgklookup()
8000000100003D50 ?

800000010000468C ?

4000000000BC0F7B ?

0000000EC ?

千问 · 2006-4-17 13:46:34

看你的log文件，是提示log writer可能出了问题，检查下你的方log文件的硬盘，database是否能mount？能mount看下你的log文件状态，是否有redo log文件不正常？

千问 · 2006-4-17 13:46:34

查一下 syslog.log

千问 · 2006-4-17 13:46:34

在metalink中找一下，居然没有说明什么原因。

千问 · 2006-4-17 13:46:34

如果数据库在terminate后能够再startup起来，可能要看一下你的操作系统方面的内核参数设定了，可以把kmtune的输出结果贴出来看一下吗？我怀疑可能跟你的操作系统的最大文件打开数有关。

千问 · 2006-4-17 13:46:34

http://www.experts-exchange.com/Databases/Oracle/Q_20973239.html
不知道对你有没有帮助，有很多留言，关于这个错误

千问 · 2006-4-17 13:46:34

最初由 bluesky007 发布
[B]看你的log文件，是提示log writer可能出了问题，检查下你的方log文件的硬盘，database是否能mount？能mount看下你的log文件状态，是否有redo log文件不正常？ [/B]
现在都在running,是昨天晚上3：30出现的问题，然后就自动failover到另一个node了。
redolog和mount没有问题。