坏块案例一个，求指导？
版本：11.1.0.6.0
1.告警日志
Thu Sep 05 22:00:28 2013
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Thu Sep 05 22:00:32 2013
Errors in file /oracle/app/diag/rdbms/ora11g/ora11g/trace/ora11g_j004_9250.trc (incident=190976):
ORA-01578: ORACLE data block corrupted (file # 70, block # 67255)
ORA-01110: data file 70: '/oracle/app/oradata/TBS_xxx.dbf'
Incident details in: /oracle/app/diag/rdbms/ora11g/ora11g/incident/incdir_190976/ora11g_j004_9250_i190976.trc
Thu Sep 05 22:00:34 2013
Trace dumping is performing id=
GATHER_STATS_JOB encountered errors. Check the trace file.
Errors in file /oracle/app/diag/rdbms/ora11g/ora11g/trace/ora11g_j004_9250.trc:
ORA-20011: Approximate NDV failed: ORA-01578: ORACLE data block corrupted (file # 70, block # 67255)
ORA-01110: data file 70: '/oracle/app/oradata/TBS_xxx.dbf'
Thu Sep 05 22:00:34 2013
2.dbv检查三个坏块，但是从结果来看 DBA 293668535，看不懂,不知道如何计算是那个块？
oracle@lbi230-linux:dbv file='/oracle/app/oradata/TBS_xxx.dbf' blocksize=8192
DBVERIFY: Release 11.1.0.6.0 - Production on Fri Sep 6 11:29:59 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = /oracle/app/oradata/TBS_xxx.dbf
DBV-00200: Block, DBA 293668535, already marked corrupt
DBV-00200: Block, DBA 293668549, already marked corrupt
DBV-00200: Block, DBA 293668576, already marked corrupt
DBVERIFY - Verification complete
Total Pages Examined : 89136
Total Pages Processed (Data) : 44712
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 21075
Total Pages Failing (Index): 0
Total Pages Processed (Other): 8955
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 14394
Total Pages Marked Corrupt : 3
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 3999635048 (28.3999635048)
oracle@lbi230-linux:
3.根据告警日志，查看是哪个对象出现坏块，
Select tablespace_name,segment_type,owner,segment_name From dba_extents Where file_id=70 and block_id<=67255 and block_id+blocks-1>=67255;---定位出是表，但是 select count(*) from owner.table; 一切正常不报错对该表进行分析exec dbms_stats.gather_table_stats('XX','BI_ALARM_LOG',cascade=>true);
begin dbms_stats.gather_table_stats('XX','BI_ALARM_LOG',cascade=>true); end;
ORA-20011: Approximate NDV failed: ORA-01578: ORACLE 数据块损坏 (文件号 70, 块号 67255)ORA-01110: 数据文件 70: '/oracle/app/oradata/TBS_XXX.dbf'ORA-06512: 在 "SYS.DBMS_STATS", line 17806既然该表数据全部都在而且可以正常访问，但是确不能进行统计分析，改表上有主键。
----求分析思路？
这个我查了 坏块出现在表上，但是又可以count(*)改表。
ctas是什么意思？
另外dbv 出现的“DBV-00200: Block, DBA 293668535, already marked corrupt” 如何解析这句话，怎么看出几号文件 几号块？
页:
[1]