紧急求助!!!!

erldy 2006-11-02 11:16:09
数据库连接不了,internal帐户登陆不了,普通帐户登陆出现
ERROR:
ORA-00470: LGWR process terminated with error

查看alert_webdb.log 日志文件最后10行:
10/26/06 10:10:37
Thread=1 Seq#=7311791 Link-Recid=7311790
Low
scn: 0x0000.38c50527
10/26/06 10:10:34
Next
scn: 0x0000.38c50568
Thread 1 advanced to log sequence 7377327
Current log# 3 seq# 7377327 mem# 0: /oracle/oradata/webdb/redo03.log
kccrsz: denied expansion of controlfile section 9 by 6481 record(s)
the number of records is already at maximum value (65535)
krcpwnc: following controlfile record written over:
RECID #7311792 Recno 37407 Record timestamp
10/26/06 10:10:41
Thread=1 Seq#=7311792 Link-Recid=7311791
Low
scn: 0x0000.38c50568
10/26/06 10:10:37
Next
scn: 0x0000.38c505a3
Thread 1 advanced to log sequence 7377328
Current log# 1 seq# 7377328 mem# 0: /oracle/oradata/webdb/redo01.log
kccrsz: denied expansion of controlfile section 9 by 6481 record(s)
the number of records is already at maximum value (65535)
krcpwnc: following controlfile record written over:
RECID #7311793 Recno 37408 Record timestamp
10/26/06 10:10:41
Thread=1 Seq#=7311793 Link-Recid=7311792
Low
scn: 0x0000.38c505a3
10/26/06 10:10:41
Next
scn: 0x0000.38c505bb
Thread 1 advanced to log sequence 7377329
Current log# 2 seq# 7377329 mem# 0: /oracle/oradata/webdb/redo02.log
kccrsz: denied expansion of controlfile section 9 by 6481 record(s)
the number of records is already at maximum value (65535)
krcpwnc: following controlfile record written over:
RECID #7311794 Recno 37409 Record timestamp
10/26/06 10:10:42
Thread=1 Seq#=7311794 Link-Recid=7311793
Low
scn: 0x0000.38c505bb
10/26/06 10:10:41
Next
scn: 0x0000.38c50608
Thread 1 advanced to log sequence 7377330
Current log# 3 seq# 7377330 mem# 0: /oracle/oradata/webdb/reThu Nov 2 10:59:35 2006
USER: terminating instance due to error 1092
Instance terminated by USER, pid = 10943

查看数据库最后down掉的.trc文件如下:
/oracle/admin/webdb/bdump/smon_14647.trc
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
ORACLE_HOME = /oracle/product/8.1.7
System name: Linux
Node name: unidb
Release: 2.4.7-10smp
Version: #1 SMP Thu Sep 6 17:09:31 EDT 2001
Machine: i686
Instance name: webdb
Redo thread mounted by this instance: 1
Oracle process number: 6
Unix process pid: 14647, image: oracle@unidb (SMON)

*** 2006-10-23 09:56:15.828
*** SESSION ID:(5.1) 2006-10-23 09:56:15.788
Using 4 slaves for 1 dead transactions
Recovered xid: 0x0002.00c.0008a50d in 0 milliseconds; nchk=0, size=1400
*** 2006-11-01 19:09:22.950
error 470 detected in background process
*** 2006-11-01 19:14:23.566
Exception signal: 25 (SIGXFSZ)
*** 2006-11-01 19:14:23.669
ksedmp: internal or fatal error
ORA-00470: LGWR process terminated with error
Exception signal: 25 (SIGXFSZ)
*** 2006-11-01 19:14:23.771
ksedmp: internal or fatal error
ORA-00470: LGWR process terminated with error
Exception signal: 25 (SIGXFSZ)
*** 2006-11-01 19:14:23.873
ksedmp: internal or fatal error
ORA-00470: LGWR process terminated with error
Background_Core_Dump = PARTIAL

本人对ORACLE不熟悉,请高手帮忙看看是怎么回事,谢谢!!
...全文
174 点赞 收藏 6
写回复
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
aweihz 2006-11-02
sqlplus internal;
startup mount;
alter database backup controlfile to trace;
找到生成的trace文件贴内容上来,然后告诉你怎么办。
回复
erldy 2006-11-02
管理员帐户都登陆不了,怎样做哪些操作?
回复
aweihz 2006-11-02
增大MAXLOGHISTORY的值,重建控制文件。
回复
erldy 2006-11-02
重启不了
回复
fuxia 2006-11-02
重启数据库试试吧
回复
erldy 2006-11-02
多谢楼上的。已经恢复正常了。
其实sqlplus internal;是登陆不了的,我是先清理alert_webdb.log 文件后,一会才可以登陆的,然后重启数据库就可以了
所以是不是日志文件满的原因造成这种情况的呢 因为alert_webdb.log 文件已经2G了
回复
发动态
发帖子
基础和管理
创建于2007-09-28

1.7w+

社区成员

Oracle 基础和管理
申请成为版主
社区公告
暂无公告