联系:手机/微信(+86 17813235971) QQ(107644445)
标题:Patch SCN工具快速解决ORA-600 2662问题
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
有一个数据库由于redo异常,强制拉库启动的时候报ORA-600 2662
Sun Oct 23 06:51:13 2022 SMON: enabling cache recovery ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\trace\xff01_ora_5016.trc (incident=264609): ORA-00600: ??????, ??: [2662], [9], [1784167754], [9], [1784229886], [12583040], [], [], [], [], [], [] Incident details in: C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\incident\incdir_264609\xff01_ora_5016_i264609.trc Sun Oct 23 06:51:17 2022 Dumping diagnostic data in directory=[cdmp_20221023065117],requested by (instance=1,osid=5016),summary=[incident=264609]. Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\trace\xff01_ora_5016.trc: ORA-00600: ??????, ??: [2662], [9], [1784167754], [9], [1784229886], [12583040], [], [], [], [], [], [] Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\trace\xff01_ora_5016.trc: ORA-00600: ??????, ??: [2662], [9], [1784167754], [9], [1784229886], [12583040], [], [], [], [], [], [] Error 600 happened during db open, shutting down database USER (ospid: 5016): terminating the instance due to error 600 Sun Oct 23 06:51:22 2022 Instance terminated by USER, pid = 5016 ORA-1092 signalled during: alter database open resetlogs...
报错比较明显由于scn问题导致,对于这个问题通过以前研发的Patch_SCN工具一键解决
解决给问题之后,open数据库遭遇ora-600 4194错误
Database Characterset is ZHS16GBK ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\trace\xff01_smon_4388.trc (incident=296569): ORA-00600: 内部错误代码, 参数: [4194], [], [], [], [], [], [], [], [], [], [], [] Incident details in: C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\incident\incdir_296569\xff01_smon_4388_i296569.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. No Resource Manager plan active Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\trace\xff01_ora_1628.trc (incident=296617): ORA-00600: 内部错误代码, 参数: [4193], [], [], [], [], [], [], [], [], [], [], [] Incident details in: C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\incident\incdir_296617\xff01_ora_1628_i296617.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Sun Oct 23 08:23:02 2022 Block recovery from logseq 1, block 568 to scn 41438874500 Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0 Mem# 0: E:\ORADATA\ONLINELOG\GROUP_1.261.840661629 Mem# 1: E:\ORADATA\ONLINELOG\GROUP_1.269.840661631 Block recovery stopped at EOT rba 1.570.16 Block recovery completed at rba 1.570.16, scn 9.2784168835 Block recovery from logseq 1, block 568 to scn 41438874497 Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0 Mem# 0: E:\ORADATA\ONLINELOG\GROUP_1.261.840661629 Mem# 1: E:\ORADATA\ONLINELOG\GROUP_1.269.840661631 Block recovery completed at rba 1.568.16, scn 9.2784168834 Errors in file C:\APP\ADMINISTRATOR\diag\rdbms\dbm\xff01\trace\xff01_smon_4388.trc: ORA-01595: 释放区 (2) 回退段 (1) 时出错 ORA-00600: 内部错误代码, 参数: [4194], [], [], [], [], [], [], [], [], [], [], []
处理异常undo问题,数据库open成功,建议业务安排导出数据导入新库,完成本次恢复
Patch_SCN下载:Patch_SCN下载
Patch_SCN使用说明:Patch_SCN使用说明