邮件,短信收到告警通知:
Fri Nov 30 16:59:19 2018
Sweep [inc][304017]: completed
Sweep [inc2][304017]: completed
Fri Nov 30 16:59:20 2018
Sweep [inc][304041]: completed
Errors in file /p01/app/oracle/diag/rdbms/****/****/trace/****_ora_8493.trc (incident=304018):
ORA-01578: ORACLE 1, 1761790)
ORA-01110: 11: '/database/****/datafile/****_9xolclxb_.dbf'
很明显,数据库坏块。但不知是逻辑还是物理
file_id:11,block number:1761790
查询具体到的对象:
select * from dba_extents where file_id='11' and 1761790between block_id and block_id+blocks-1;
恰巧是一个索引。。
关闭监听
drop index schema.index_name;
create index schema.index_name on table_name(column_name1,column_name2,,,) tablespace tablespace_name;
开始监听
开启应用,OK
ps:
如果对象是表,那就需要create table tmp_table as select * from table_Name;再rename表为原表;
如果是物理损坏,而非逻辑错误,必须更换对应硬盘,再进行该修复操作。