資料庫報ORA-01110錯誤

日誌中顯示：
ORACLE Instance tonykorn (pid = 8) - Error 1578 encountered while recovering transaction (3, 28) on object 66529.
Mon Dec 3 14:47:06 2007
Errors in file /oracle/app/oracle/admin/tonykorn/bdump/tonykorn_smon_5787.trc:
ORA-01578: Message 1578 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [2770385]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [/oracle/oradata/tonykorn/NNC_DATA01.dbf]

exp匯出的時候報：
. . exporting table TMP_GL_TMPDETAILPKKCC0
EXP-00056: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 2, block # 22697)
ORA-01110: data file 2: '/oracle/oradata/orcl/undotbs01.dbf'

刪除這兩個表：
SQL> connect user01/user01
Connected.
SQL> show user;
USER is "user01"
SQL> select * from TMP_GL_TMPDETAILPKKCC0
2 ;
select * from TMP_GL_TMPDETAILPKKCC0
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 2, block # 22697)
ORA-01110: data file 2: '/oracle/oradata/tonykorn/undotbs01.dbf'

SQL> drop table TMP_GL_TMPDETAILPKKCC0;

Table dropped.

SQL> drop table TMP_GL_VOUCHERPKKD6B;

Table dropped.

SQL> exit

重新匯出時不報錯了！

切換日誌
SQL> alter system switch logfile;

System altered.

切換日誌後從alter裡面檢視還是有壞塊
Completed: ALTER DATABASE OPEN
Mon Dec 3 20:49:00 2007
Thread 1 advanced to log sequence 754
Current log# 3 seq# 754 mem# 0: /oracle/oradata/tonykorn/redo03.log
Mon Dec 3 20:49:07 2007
SMON: Restarting fast_start parallel rollback
SMON: ignoring slave err,downgrading to serial rollback
ORACLE Instance tonykorn (pid = 8) - Error 1578 encountered while recovering transaction (1, 22) on object 67951.
Mon Dec 3 20:49:07 2007
Errors in file /oracle/app/oracle/admin/tonykorn/bdump/tonykorn_smon_19048.trc:
ORA-01578: Message 1578 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [2934737]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [/oracle/oradata/tonykorn/NNC_DATA01.dbf]
ORACLE Instance tonykorn (pid = 8) - Error 1578 encountered while recovering transaction (3, 28) on object 66529.
Mon Dec 3 20:49:08 2007
Errors in file /oracle/app/oracle/admin/tonykorn/bdump/tonykorn_smon_19048.trc:
ORA-01578: Message 1578 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [2770385]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [/oracle/oradata/tonykorn/NNC_DATA01.dbf]
ORACLE Instance tonykorn (pid = 8) - Error 1578 encountered while recovering transaction (4, 25) on object 66621.
Mon Dec 3 20:49:08 2007
Errors in file /oracle/app/oracle/admin/tonykorn/bdump/tonykorn_smon_19048.trc:
ORA-01578: Message 1578 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [2866970]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [5] [/oracle/oradata/tonykorn/NNC_DATA01.dbf]
Mon Dec 3 20:50:03 2007
Shutting down archive processes
Mon Dec 3 20:50:08 2007
ARCH shutting down
ARC2: Archival stopped

dbca刪除後重建，然後用exp匯出的檔案重新匯入.沒有辦法，oracle水平不行只能用最簡單的方法了。