mysql有坏块_数据库出现坏块，如何处理？ - Oracle数据库管理 - Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站 - M...

--alter.log报错

Tue May  5 17:47:44 2015

Hex dump of (file 124, block 8) in trace file /oraclelog/admin/crmdb/udump/crmdb1_ora_659922.trc

Corrupt block relative dba: 0x1f000008 (file 124, block 8)

Bad check value found during backing up datafile

Data in bad block:

type: 30 format: 2 rdba: 0x1f000008

last change scn: 0x0ae8.04e027a0 seq: 0x1 flg: 0x04

spare1: 0x0 spare2: 0x0 spare3: 0x0

consistency value in tail: 0x27a01e01

check value in block header: 0x28f4

computed block checksum: 0x6a0c

Reread of blocknum=8, file=/dev/rcrmvg2_1_vd2. found same corrupt data

Reread of blocknum=8, file=/dev/rcrmvg2_1_vd2. found same corrupt data

Reread of blocknum=8, file=/dev/rcrmvg2_1_vd2. found same corrupt data

Reread of blocknum=8, file=/dev/rcrmvg2_1_vd2. found same corrupt data

Reread of blocknum=8, file=/dev/rcrmvg2_1_vd2. found same corrupt data

Hex dump of (file 162, block 8) in trace file /oraclelog/admin/crmdb/udump/crmdb1_ora_659922.trc

Corrupt block relative dba: 0x28800008 (file 162, block 8)

Bad check value found during backing up datafile

Data in bad block:

type: 30 format: 2 rdba: 0x28800008

last change scn: 0x0ae9.57f4a527 seq: 0x1 flg: 0x04

spare1: 0x0 spare2: 0x0 spare3: 0x0

consistency value in tail: 0xa5271e01

check value in block header: 0x4cbf

computed block checksum: 0x6a0c

Reread of blocknum=8, file=/dev/rcrmvg3_1_vd3. found same corrupt data

Reread of blocknum=8, file=/dev/rcrmvg3_1_vd3. found same corrupt data

Reread of blocknum=8, file=/dev/rcrmvg3_1_vd3. found same corrupt data

Reread of blocknum=8, file=/dev/rcrmvg3_1_vd3. found same corrupt data

Reread of blocknum=8, file=/dev/rcrmvg3_1_vd3. found same corrupt data

Tue May  5 18:01:54 2015

ALTER SYSTEM ARCHIVE LOG

--查看状态

SQL> SELECT a.file_id,a.tablespace_name,a.status,a.online_status

2   FROM dba_data_files a WHERE a.file_id IN(162,124);

FILE_ID TABLESPACE_NAME                STATUS    ONLINE_STATUS

---------- ------------------------------ --------- -------------

124 TBS_ILCU                       AVAILABLE RECOVER

162 TBS_DATE_999                   AVAILABLE RECOVER

--文件状态为可用，online_status处于待恢复状态

这个错误出现有一段时间了，但是数据处于可用状态。请教各位如何处理？还需要提供什么信息？谢谢各位