联系:手机/微信(+86 17813235971) QQ(107644445)
标题:ORA-600 2663
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
在大家熟悉的ORA-600 2662错误中还有一个类似的ORA-600 2663的错误,以下是对该2663的解释说明
ERROR: Format: ORA-600 [2663] [a] [b] {c} [d] VERSIONS: versions 10.1 to 11.1 DESCRIPTION: A data block SCN is ahead of the current SCN. The ORA-600 [2663] 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 [2663] internal error. ARGUMENTS: Arg [a] Current SCN WRAP Arg [b] Current SCN BASE Arg {c} dependent SCN WRAP Arg [d] dependent SCN BASE FUNCTIONALITY: Kernel Cache Redo File Redo Generation IMPACT: INSTANCE FAILURE POSSIBLE PHYSICAL CORRUPTION SUGGESTIONS: There are different situations where ORA-600 [2663] 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 [argument d]-[argument b]. 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.