前言：今天程序后臺(tái)告警如下夹抗，初步判斷就是數(shù)據(jù)所在的硬盤有壞塊，下面簡(jiǎn)單記錄下處理流程纵竖。
一、程序告警
1.png
二杏愤、dev檢測(cè)
從程序上告警可以看到文件號(hào)4靡砌，塊號(hào)2858634所在的數(shù)據(jù)庫(kù)損壞，我們查看文件號(hào)4所在的文件名珊楼。
SQL> select file_id,file_name from dba_data_files where file_id=4;
FILE_ID FILE_NAME
---------- ----------------------------------------
4 /u01/oracle/oradata/wxdb/users01.dbf
使用dev檢測(cè)
[oracle@weixindb ~]$ dbv file='/u01/oracle/oradata/wxdb/users01.dbf'
DBVERIFY: Release 11.2.0.3.0 - Production on Mon Apr 9 09:40:44 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
DBVERIFY - Verification starting : FILE = /u01/oracle/oradata/wxdb/users01.dbf
DBV-00200: Block, DBA 19635850, already marked corrupt
csc(0x0000.1de576e3) higher than block scn(0x0000.00000000)
Page 2858634 failed with check code 6054
DBVERIFY - Verification complete
Total Pages Examined : 4193600
Total Pages Processed (Data) : 1223652
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 2890057
Total Pages Failing (Index): 1
Total Pages Processed (Other): 57814
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 22077
Total Pages Marked Corrupt : 1
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 2094114815 (0.2094114815)
從上面可以看到確實(shí)存在一個(gè)壞塊
三通殃、查看壞塊所在的對(duì)象
SQL> SELECT tablespace_name, segment_type, owner,segment_name, partition_name FROM dba_extents WHERE file_id=6 and 2858634 between block_id AND block_id+blocks-1;
TABLESPACE_NAME SEGMENT_TYPE OWNER SEGMENT_NAME PARTITION_NAME
------------------------------ ------------------ ------------------------------ --------------------------------------------------------------------------------- ------------------------------
USERS INDEX WEIXIN RECORD_ID
因?yàn)槲疫@里壞塊問(wèn)題已經(jīng)解決了，所以另外指定了一個(gè)file_id，可以看到壞塊所在的對(duì)象是一個(gè)索引画舌，那么這個(gè)問(wèn)題就比較好解決了堕担，通過(guò)重建索引即可解決。
四曲聂、在線重建索引
查看索引所在的表
SQL> select table_name,index_name from dba_indexes where index_name = 'RECORD_ID';
TABLE_NAME INDEX_NAME
------------------------------ ------------------------------
ZJOL_WINNING_RECORD RECORD_ID
重建索引
alter index idx_xxx rebuild online;
