ORA-00600: 内部错误代码, 参数: [2663], [2522]
环境：
OS: RHEL 5.8 X86
DB：11.2.0.3.7
数据库在运行的过程中报错：
ORA-00600: 内部错误代码, 参数: , , , , , [], [], [], [], [], [], []
ORA-00600: 内部错误代码, 参数: , , , , , [], [], [], [], [], [], []
我的理解是：根据错误好像和scn有关系，当前scn是344764007，错误scn是3947366721，scn变成了344784609，错误还是没变3947366721，日志在附件中，看trace文件，记录的是某个sql，实际中也的确是这个sql的功能报错。 这个错误应该和ora-600一个性质的，block的scn>datafile header scn Format: ORA-600
A data block SCN is ahead of the current SCN.
The ORA-600 occurs when an SCN is compared to the dependent SCN
stored in a UGA variable.
If the SCN is less than the dependent SCN then we signal the ORA-600
internal error.
ARGUMENTS:
Arg Current SCN WRAP
Arg Current SCN BASE
Arg dependent SCN WRAP
Arg dependent SCN BASE
FUNCTIONALITY:
Kernel Cache Redo File Redo Generation
IMPACT:
INSTANCE FAILURE
POSSIBLE PHYSICAL CORRUPTION
SUGGESTIONS:
There are different situations where ORA-600 can be raised.
It can be raised on startup or duing database operation.
If not using RAC, Real Application Clusters,, check that 2 instances
have not mounted the same database.
Check for SMON traces and have the alert.log and trace files ready
to send to support.
Check the SCN difference -.
If the SCNs in the error are very close, then try to shutdown and startup
the instance several times.
In some situations, the SCN increment during startup may permit the
database to open. Keep track of the number of times you attempted a
startup. 手动递增SCN号的几种方法：How to increase System Change Number by manual
http://www.askmaclean.com/archives/how-to-increase-system-change-number-by-manual.html 非常感谢2位的恢复，按照方法已经解决了，多谢！！
页:
[1]