ora-600 [2662] && ora-01031 权限不足的解决 (ora-01152)(二)

SQL> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#
------------------

4717118

SQL> select checkpoint_change# from v$datafile;

CHECKPOINT_CHANGE#
------------------

4717118
4717118
4717118
4717118
4717118
4717118
4717118
4717118
4664735

9 rows selected.

SQL> select checkpoint_change# from v$datafile_header;

CHECKPOINT_CHANGE#
------------------

4717118
4717118
4717118
4717118
4717118
4717118
4717118
4717118
0

9 rows selected.

SQL> select last_change# from v$datafile;

LAST_CHANGE#
------------
4664735

9 rows selected.

具体步骤如下:
startup force;
alter system set "_allow_resetlogs_corruption"=true scope=spfile;
recover database using backup controlfile until cancel;
alter databse open resetlogs;

特别声明： 备份很重要，要是没有备份，就recover 不行啦。