ERROR at line 1:

ORA-08102: index key not found, obj# 577, file 1, block 69410 (2)

直接truncate cluster即可清除數(shù)據(jù):

SQL> truncate cluster smon_scn_to_time;

Cluster truncated.

SQL> select count(*) from smon_scn_time;

  COUNT(*)

----------

         0

SQL> 

重新啟動(dòng)數(shù)據(jù)庫(kù)后,數(shù)據(jù)庫(kù)一切恢復(fù)正常,不存在任何告警和錯(cuò)誤信息了:

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1224736768 bytes

Fixed Size                  2083664 bytes

Variable Size             318768304 bytes

Database Buffers          889192448 bytes

Redo Buffers               14692352 bytes

Database mounted.

Database opened.

SQL> select count(*) from smon_scn_time;

  COUNT(*)

----------

         1

至此這個(gè)數(shù)據(jù)庫(kù)恢復(fù)圓滿解決了.

上一頁(yè)  [1] [2]