ORA-00600: 内部错误代码2252

545459983

OS Version：win server 2003
DB Version：  10.2.0.1.0
alert与trace
数据库启动的时候发生错误，ORA-00600: 内部错误代码, 参数: [2252], [2804], [704470809], [], [], [], [], []
此前听同事说undo有问题，后面我把undo修改为manual进行管理，出现了这种错误，希望刘大能够给予帮助

545459983

后附数据文件情况

545459983

找到原因了：解决：

Subject:         ORA-600 [2252] Occurs During Alter Database Open
          Doc ID:         Note:253977.1         Type:         PROBLEM
          Last Revision Date:         19-OCT-2004         Status:         PUBLISHED


Symptom(s)
~~~~~~~~~~

After shutdown of the database you receive the following error during
alter database open:  ora-600 [2252]

You did not restore the database before receiving this error.


Cause
~~~~~~~

The system date is lower than the date of the shutdown.

While opening the database, Oracle compares the given SCN value
with the reasonable upper limit value calculated based on the
system date. If Oracle detects the provided scn is too large,
ORA-600[2252] would be raised.

Fix
~~~~
Set the system date equal or higher the date of the shutdown.

Maclean Liu(刘相兵

Known Bugs



    The list below shows bugs affecting any version

    There is 1 bug listed.

    NB        Bug        Fixed        Description
            12371955         11.1.0.7.9, 11.2.0.2.4, 11.2.0.2.BP09, 11.2.0.3, 12.1.0.1         Hot Backup can cause increased SCN growth rate leading to ORA-600 [2252] errors


建议你打开数据库后 导出数据 并重建数据库， 至少升级到10.2.0.5