突然停電重啟資料庫就出現ORA-00600錯誤的解決方法(轉)

imlihj2007發表於2010-06-09

本人是在資料庫遷移的時候出現00600 【2252】的錯誤

解決辦法一樣!!

解決辦法相同!

突然停電,啟動資料庫就出現ORA-00600錯誤如下:

——————————————————————
Connected to an idle instance.
ORACLE instance started.

Total System Global Area 581506668 bytes
Fixed Size 452204 bytes
Variable Size 402653184 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes
Database mounted.
ORA-00600: internal error code, arguments: [2252], [1903], [579459841], [], [],
[], [], []

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.

解決辦法:檢查一下系統時間,先調整系統時間, 重啟應該就可以了

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9879835/viewspace-1034269/,如需轉載,請註明出處,否則將追究法律責任。

相關文章