oracle錯誤匯總

標籤：esc   database   from   databases   第一個   general   ted   amp   sig   

這是遇見的第一個整個庫正常，但某張表查詢報錯的情況

某張表資料可以查，但一排序查就報錯

select * from acct_daily_bak;

select * from acct_daily_bak order by open_time desc;

ORA-01578: ORACLE data block corrupted (file # 7, block # 27489)
ORA-01110: data file 7: ‘/u01/app/oracle/oradata/TESTDB/datafile/o1_mf_kyc_acc_dlzsz7mt_.dbf‘
ORA-06512: at line 2

 

 

ORA-01578: ORACLE data block corrupted (file # 7, block # 27489)
ORA-01110: data file 7: ‘/u01/app/oracle/oradata/TESTDB/datafile/o1_mf_kyc_acc_dlzsz7mt_.dbf‘
01578. 00000 -  "ORACLE data block corrupted (file # %s, block # %s)"
*Cause:    The data block indicated was corrupt. This was a physical
           corruption, also called a media corruption. The cause is unknown
           but is most likely external to the database. If ORA-26040 is also
           signaled, the corruption is due to NOLOGGING or UNRECOVERABLE
           operations.
*Action:   The general method to repair a media corrupt block is to restore
           a backup and recover the backup. For databases in ARCHIVELOG
           mode, use block media recovery or media recovery. In some situations,
           you can also drop the segment and re-create it. For example, you can
           drop an index and re-create the index.

oracle錯誤匯總