IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    ORA-600 2663分析

    惜分飞发表于 2016-09-28 14:18:22
    love 0

    联系:手机(13429648788) QQ(107644445)

    链接:http://www.orasos.com/ora-600-2663%e5%88%86%e6%9e%90.html

    标题: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.
    
    • ORA-600 2662分析
    • ORA-00600 [2662]
    • ORA-600 [4193]
    • 记录一次 ORA-600 2663 故障恢复
    • 记录一次由于坏块和不恰当恢复引起各种ORA-600案例
    • ORA-600 [12235]
    • ORA-600 4194/ORA-600 4193/ORA-600 4137 恢复思路
    • ORACLE最大可以存储多少数据量
    • ORA-600 kdsgrp1
    • dbca创建数据库报ORA-00443
    • ORA-00600[17182],ORA-00600[25027],ORA-00600[kghfrempty:ds]故障处理
    • rac redo log file被意外覆盖数据库恢复
    • ora-01092:ORACLE 实例终止 —access$表丢失恢复
    • 处理smon清理临时段导致数据库异常案例
    • 9i库遇到ORA-01595/ORA-01594


沪ICP备19023445号-2号
友情链接