Oracle 資料庫不一致導致異常的恢復

ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [4197042], [1], [29217],
[76081], [156], [], []
ORA-10567: Redo is inconsistent with data block (file# 1, block# 2738)
ORA-10564: tablespace SYSTEM
ORA-01110: data file 1: '/u01/product/oradata/eslhdb0/system01.dbf'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 389

 

shutdown immediate
然後startup nomount
重新建立控制檔案
shutdown immediate
startup mount
recover database using backup controlfile until cancel;
指定日誌:   選cancel
alter database open resetlogs；

如果不行，那可能是資料庫不一致的問題：
然後 ：
_allow_resetlogs_corruption=true
註釋掉所有的回滾段
_corrupted_rollback_segments=( 所有的回滾段 )
再試驗一下。