ORA-01578: ORA-01110:ORA-26040:该怎么处理

doisy

之前因为数据库启动不了，重建过控制文件，可以启动了。
后来日志报error，redo文件块损坏，原来是3组redo文件，每组50m，后来我又加3组公六组，全部改成了300m。
再后来想用expdp导出库，结果发现到不了，原来重建控制文件时忘记reuse temp表空间了（我是个菜鸡  -_-||||），然后给reuse上，就可以正常导出了。
今天又去看了下日志，发现好多undotbs1.dbf的块损坏报错，于是又重建了undo文件，从原来的500m升到1024m。重建完后没有报错了。
今晚回来一看，又提示sysaux01.dbf块损坏报错（不想活了）

Errors in file c:\app\administrator\diag\rdbms\orclcdc\orclcdc\trace\orclcdc_j001_6096.trc:
ORA-20011: Approximate NDV failed: ORA-01578: ORACLE data block corrupted (file # 2, block # 702995)
ORA-01110: data file 2: 'C:\APP\ADMINISTRATOR\ORADATA\ORCLCDC\SYSAUX01.DBF'
ORA-26040: Data block was loaded using the NOLOGGING option

用dbv查了一下发现以下报错

C:\Users\Administrator>dbv file= 'C:\APP\ADMINISTRATOR\ORADATA\ORCLCDC\SYSAUX01.
DBF'

DBVERIFY: Release 11.2.0.1.0 - Production on Sun Jan 1 21:57:58 2017

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

DBVERIFY - Verification starting : FILE = C:\APP\ADMINISTRATOR\ORADATA\ORCLCDC\S
YSAUX01.DBF

DBV-00201: Block, DBA 8454172, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8454267, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8454280, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8454287, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8454291, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8454299, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8454307, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8454335, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8454825, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8454847, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8454852, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8454885, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8456970, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8457027, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8457043, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8459011, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8459022, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8459035, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8459045, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8459056, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8459069, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8460710, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8460718, marked corrupt for invalid redo application

DBV-00201: Block, DBA 8460779, marked corrupt for invalid redo application

DBV-00201: Block, DBA 9091603, marked corrupt for invalid redo application

DBV-00201: Block, DBA 9091604, marked corrupt for invalid redo application

DBV-00201: Block, DBA 9091605, marked corrupt for invalid redo application

DBV-00201: Block, DBA 9091606, marked corrupt for invalid redo application

DBV-00201: Block, DBA 9091607, marked corrupt for invalid redo application

DBV-00201: Block, DBA 9091608, marked corrupt for invalid redo application

DBV-00201: Block, DBA 9091609, marked corrupt for invalid redo application

DBV-00201: Block, DBA 9091610, marked corrupt for invalid redo application

DBV-00201: Block, DBA 9091611, marked corrupt for invalid redo application

DBV-00201: Block, DBA 9091612, marked corrupt for invalid redo application

DBVERIFY - Verification complete

Total Pages Examined       : 852480
Total Pages Processed (Data) : 268499
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 482120
Total Pages Failing (Index): 0
Total Pages Processed (Lob)  : 9595
Total Pages Failing (Lob)  : 0
Total Pages Processed (Other): 25762
Total Pages Processed (Seg)  : 0
Total Pages Failing (Seg)  : 0
Total Pages Empty          : 66504
Total Pages Marked Corrupt : 34
Total Pages Influx          : 0
Total Pages Encrypted       : 0
Highest block SCN          : 551982128 (0.551982128)

SQL> SELECT tablespace_name, segment_type, owner, segment_name
  2  FROM dba_extents
  3  WHERE file_id = 2 and 702995 between block_id AND block_id + blocks - 1;

TABLESPACE_NAME             SEGMENT_TYPE    OWNER
------------------------------ ------------------ ------------------------------

SEGMENT_NAME
--------------------------------------------------------------------------------

SYSAUX                      TABLE PARTITION SYS
WRH$_ACTIVE_SESSION_HISTORY

大家帮帮，我应该怎么做才能修复这个问题。跪谢大家了。。。

图文精华

ORA-01578: ORA-01110:ORA-26040:该怎么处理