联系：手机/微信(+86 17813235971) QQ(107644445)
标题：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,导出数据导入新库完成恢复
加我QQ
