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

    ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], []

    惜分飞发表于 2024-01-12 05:07:36
    love 0

    联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

    标题:ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], []

    作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

    再来一例客户由于断电强制拉库之后,报ORA-600 4194错误的case

    Wed Jan 10 22:21:01 2024
    ARC3 started with pid=39, OS id=4672 
    ARC1: Archival started
    ARC2: Archival started
    ARC2: Becoming the 'no FAL' ARCH
    ARC2: Becoming the 'no SRL' ARCH
    ARC1: Becoming the heartbeat ARCH
    SMON: enabling cache recovery
    Archived Log entry 4517 added for thread 1 sequence 23 ID 0xad378582 dest 1:
    [4796] Successfully onlined Undo Tablespace 8.
    Undo initialization finished serial:0 start:3480640 end:3480843 diff:203 (2 seconds)
    Verifying file header compatibility for 11g tablespace encryption..
    Verifying 11g file header compatibility for tablespace encryption completed
    SMON: enabling tx recovery
    Database Characterset is ZHS16GBK
    No Resource Manager plan active
    Errors in file E:\APP\ADMINISTRATOR\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_smon_4508.trc 
    ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    replication_dependency_tracking turned off (no async multimaster replication found)
    Wed Jan 10 22:21:03 2024
    Block recovery from logseq 24, block 63 to scn 42269588
    Recovery of Online Redo Log: Thread 1 Group 3 Seq 24 Reading mem 0
      Mem# 0: E:\ORADATA\xifenfei\REDO03.LOG
    Block recovery completed at rba 24.64.16, scn 0.42269589
    Block recovery from logseq 24, block 63 to scn 42269587
    Recovery of Online Redo Log: Thread 1 Group 3 Seq 24 Reading mem 0
      Mem# 0: E:\ORADATA\xifenfei\REDO03.LOG
    Block recovery completed at rba 24.63.16, scn 0.42269588
    Errors in file E:\APP\ADMINISTRATOR\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_smon_4508.trc:
    ORA-01595: error freeing extent (2) of rollback segment (2))
    ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
    Starting background process QMNC
    Wed Jan 10 22:21:03 2024
    QMNC started with pid=40, OS id=6576 
    ARC3: Archival started
    ARC0: STARTING ARCH PROCESSES COMPLETE
    Wed Jan 10 22:21:04 2024
    Errors in file E:\APP\ADMINISTRATOR\diag\rdbms\xifenfei\xifenfei\trace\xifenfei_mmon_6584.trc
    ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Starting background process SMCO
    Wed Jan 10 22:21:04 2024
    SMCO started with pid=41, OS id=6292 
    Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x675E484A] [PC:0xCBBC18, kgegpa()+38]
    Wed Jan 10 22:21:06 2024
    Errors in file E:\app\Administrator\diag\rdbms\xifenfei\xifenfei\cdump\xifenfeicore.log
    ORA-07445: caught exception [ACCESS_VIOLATION] at [kgegpa()+38] [0x0000000000CBBC18]
    Wed Jan 10 22:21:08 2024
    PMON (ospid: 3212): terminating the instance due to error 397
    

    这个比较简单屏蔽undo,启动库,然后重建undo,导出数据导入新库完成恢复

    • Patch SCN工具快速解决ORA-600 2662问题
    • ORA-600 17182导致oracle异常
    • 又一例ORA-600 kcratr_nab_less_than_odr
    • ORA-600 999 异常恢复
    • ORA-00322 ORA-00312恢复
    • ORA-00600 [2662]和ORA-00600 [4194]恢复
    • 记录一次200T的数据库恢复经历
    • ORA-00600[17182],ORA-00600[25027],ORA-00600[kghfrempty:ds]故障处理
    • ORA-600 kkdlcob-objn-exist 40
    • ORA-00600[4194]故障解决
    • 数据库启动报ORA-600 kcbgtcr_13处理
    • Oracle 启动后一会儿就挂掉故障处理—ORA-600 17182


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