Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

27

积分

0

好友

0

主题
1#
发表于 2012-3-23 11:57:47 | 查看: 7705| 回复: 4
dmesg
0, channel 1, label "": (Branch=0 DRAM-Bank=5 RDWR=Read RAS=12370 CAS=2960, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 0, channel 1, label "": (Branch=0 DRAM-Bank=6 RDWR=Read RAS=10940 CAS=2936, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 0, channel 1, label "": (Branch=0 DRAM-Bank=6 RDWR=Read RAS=10940 CAS=2936, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 0, channel 1, label "": (Branch=0 DRAM-Bank=7 RDWR=Read RAS=12378 CAS=2960, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 0, channel 1, label "": (Branch=0 DRAM-Bank=4 RDWR=Read RAS=12381 CAS=2962, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 0, channel 1, label "": (Branch=0 DRAM-Bank=7 RDWR=Read RAS=12377 CAS=2960, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=2 RDWR=Read RAS=5195 CAS=0, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=0 RDWR=Read RAS=3428 CAS=0, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 0, channel 1, label "": (Branch=0 DRAM-Bank=6 RDWR=Read RAS=12380 CAS=2960, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 0, channel 1, label "": (Branch=0 DRAM-Bank=7 RDWR=Read RAS=12378 CAS=2960, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 0, channel 1, label "": (Branch=0 DRAM-Bank=6 RDWR=Read RAS=10940 CAS=2936, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=0 RDWR=Read RAS=3428 CAS=0, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))
EDAC MC0: CE row 1, channel 1, label "": (Branch=0 DRAM-Bank=1 RDWR=Read RAS=4692 CAS=2, CE Err=0x2000 (Correctable Non-Mirrored Demand Data ECC))

同仁们给点建议

dmesg.txt

126.38 KB, 下载次数: 930

2#
发表于 2012-3-23 13:00:04
ODM FINDING:

2 down vote accepted
       

The error message basically means that the memory you install is faulty. The system has found that the memory was corrupt and the ECC was able to correct the single bit error and alerted the OS to the fact that the memory is unhappy.

The DRAM in question is the DRAM in Bank 6 (most probably dual channel memory) so look at that location for the faulty ram.


1. 是否最近动过 内存 ? 增加过内存类的硬件?

2. 建议SA 和 HW vendor 检查 DRAM设备
0, channel 1, label "": (Branch=0 DRAM-Bank=5 RDWR=Read RAS=12370 CAS=2960, CE Err=0x2000

回复 只看该作者 道具 举报

3#
发表于 2012-3-23 14:16:36
才装一周的数据库服务器,装的第二天就查看了好像也有这个问题,只是当时很很忙没有仔细分析,今天运行dmesg命令发现有错误,所以在坛子里来发个帖子问问,我让机房的检查一下内存的情况

回复 只看该作者 道具 举报

4#
发表于 2012-3-30 15:11:22
让IDC机房的运维把内存条更换后没有报错信息了。

回复 只看该作者 道具 举报

5#
发表于 2012-3-30 17:12:54
现在服务器的硬件质量比以前差多了。
我单位上个月新加的硬盘,这个月坏了两块,幸好有冗余。

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-24 03:25 , Processed in 0.050469 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569