win强制修改盘符导致oracle异常恢复----惜分飞

标签：25 Feb win 盘符分飞 orcl 2023 ORA Sat

有客户反馈,他们在系统没有关闭数据库的情况下,强制修改了win系统盘符,然后导致数据库异常,启动报错

Sat Feb 25 12:50:40 2023 Recovery of Online Redo Log: Thread 1 Group 2 Seq 10440 Reading mem 0 Mem# 0 errs 0: G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG Sat Feb 25 12:50:40 2023 Completed redo application Sat Feb 25 12:50:40 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p001_5604.trc: ORA-00600: 内部错误代码, 参数: [2037], [25801018], [2973409798], [6], [255], [25], [1198764346], [100796692] Sat Feb 25 12:50:40 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_7648.trc:

ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION][_kslwlmod+166][PC:0x469742][ADDR:0x54F8][UNABLE_TO_WRITE][]

ORA-04096: 触发器 '' 的 WHEN 子句过大, 限量为 2K Sat Feb 25 12:50:40 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_7252.trc: ORA-00600: internal error code, arguments: [ksuapc2], [258], [0], [2], [1], [2], [], [] Sat Feb 25 12:50:43 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p001_5604.trc: ORA-00081: 地址范围 [0x77240440, 0x77240444) 不可读

ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION][_ksl_cleanup+723][PC:0x46E373][ADDR:0x1C][UNABLE_TO_READ][]

ORA-00081: 地址范围 [0x77240440, 0x77240444) 不可读 ORA-00600: 内部错误代码, 参数: [2037], [25801018], [2973409798], [6], [255], [25], [1198764346], [100796692] Sat Feb 25 12:50:45 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_6332.trc: ORA-07445: ??????: ???? [ACCESS_VIOLATION][_kews_idle_wait+378][PC:0x604AE6][ADDR:0xED30C470][UNABLE_TO_WRITE][] Sat Feb 25 12:50:48 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_7648.trc: ORA-00600: 内部错误代码, 参数: [kslwlflux:1], [0xAB805400], [0x549C], [2], [], [], [], [] ORA-00081: 地址范围 [0x74480443, 0x74480447) 不可读 ORA-00600: 内部错误代码, 参数: [kslwlflux:1], [0xAB805400], [0x549C], [2], [], [], [], [] ORA-00081: 地址范围 [0x74480443, 0x74480447) 不可读 ORA-00600: 内部错误代码, 参数: [kslwlflux:1], [0xAB805400], [0x549C], [2], [], [], [], [] ORA-00081: 地址范围 [0x74480443, 0x74480447) 不可读 ORA-00600: 内部错误代码, 参数: [kslwlflux:1], [0xAB805400], [0x549C], [2], [], [], [], [] ORA-00081: 地址范围 [0x74480443, 0x74480447) 不可读 ORA-00600: 内部错误代码, 参数: [kslwlflux:1], [0xAB805400], [0x549C], [2], [], [], [], [] ORA-00081: 地址范围 [0x74480443, 0x74480447) 不可读 ORA-00600: 内部错误代码, 参数: [kslwlflux:1], [0xAB805400], [0x549C], [2], [], [], [], [] ORA-00081: 地址范围 [0x74480443, 0x74480447) 不可读 ORA-00600: 内部错误代码, 参数: [kslwlflux:1], [0xAB805400], [0x549C], [2], [], [], [], [] ORA-00081: 地址范围 [0x74480443, 0x74480447) 不可读 ORA-00600: 内部错误代码, 参 Sat Feb 25 12:51:34 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_d000_8116.trc: ORA-07445: ??????: ???? [ACCESS_VIOLATION][_kmcgms+121][PC:0x5D6C71][ADDR:0x50][UNABLE_TO_WRITE][] Sat Feb 25 12:52:04 2023 USER: terminating instance due to error 472 Sat Feb 25 12:52:48 2023 USER: terminating instance due to error 472 Sat Feb 25 12:52:48 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_6252.trc: ORA-07445: exception encountered: core dump [ACCESS_VIOLATION][_ksuitm+631][PC:0x410C07][ADDR:0x1][UNABLE_TO_READ][] Sat Feb 25 12:55:35 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_7656.trc: ORA-07445: ??????: ???? [ACCESS_VIOLATION][_kews_idle_wait+378][PC:0x604AE6][ADDR:0xE530C470][UNABLE_TO_WRITE][]

通过恢复一些恢复之后,数据库open之后又挂掉

Sat Feb 25 15:05:49 2023 SMON: enabling tx recovery Sat Feb 25 15:05:49 2023 Database Characterset is ZHS16GBK Sat Feb 25 15:05:50 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_5308.trc: ORA-00600: 内部错误代码, 参数: [4194], [34], [31], [], [], [], [], [] Sat Feb 25 15:05:50 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_7568.trc: ORA-00600: 内部错误代码, 参数: [kcbgtcr_13], [], [], [], [], [], [], [] Sat Feb 25 15:05:51 2023 Non-fatal internal error happenned while SMON was doing logging scn->time mapping. SMON encountered 1 out of maximum 100 non-fatal internal errors. Sat Feb 25 15:05:51 2023 Doing block recovery for file 2 block 2951 Block recovery from logseq 10441, block 78 to scn 109906860017 Sat Feb 25 15:05:51 2023 Recovery of Online Redo Log: Thread 1 Group 3 Seq 10441 Reading mem 0 Mem# 0 errs 0: G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG Block recovery stopped at EOT rba 10441.81.16 Block recovery completed at rba 10441.81.16, scn 25.2532677517 Doing block recovery for file 2 block 113 Block recovery from logseq 10441, block 78 to scn 109906859718 Sat Feb 25 15:05:52 2023 Recovery of Online Redo Log: Thread 1 Group 3 Seq 10441 Reading mem 0 Mem# 0 errs 0: G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG Block recovery completed at rba 10441.80.16, scn 25.2532677516 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=30, OS id=6904 Sat Feb 25 15:05:53 2023 db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Sat Feb 25 15:05:53 2023 Completed: alter database open Sat Feb 25 15:05:53 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j000_5400.trc: ORA-00600: 内部错误代码, 参数: [4194], [6], [4], [], [], [], [], [] Sat Feb 25 15:05:54 2023 DEBUG: Replaying xcb 0xac458698, pmd 0x8d7e9b9c for failed op 8 Doing block recovery for file 2 block 1515 No block recovery was needed Sat Feb 25 15:05:55 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j000_5400.trc: ORA-00600: 内部错误代码, 参数: [4194], [6], [4], [], [], [], [], [] ORA-00600: 内部错误代码, 参数: [4194], [6], [4], [], [], [], [], [] Sat Feb 25 15:05:56 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j000_5400.trc: ORA-00603: ORACLE server session terminated by fatal error ORA-00600: internal error code, arguments: [4194], [6], [4], [], [], [], [], [] ORA-00600: internal error code, arguments: [4194], [6], [4], [], [], [], [], [] Sat Feb 25 15:05:57 2023 Doing block recovery for file 2 block 2951 Block recovery from logseq 10441, block 78 to scn 109906860017 Sat Feb 25 15:05:57 2023 Recovery of Online Redo Log: Thread 1 Group 3 Seq 10441 Reading mem 0 Mem# 0 errs 0: G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG Block recovery completed at rba 10441.81.16, scn 25.2532677620 Doing block recovery for file 2 block 113 Block recovery from logseq 10441, block 78 to scn 109906860083 Sat Feb 25 15:05:57 2023 Recovery of Online Redo Log: Thread 1 Group 3 Seq 10441 Reading mem 0 Mem# 0 errs 0: G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG Block recovery completed at rba 10441.138.16, scn 25.2532677684 Sat Feb 25 15:05:57 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j003_1716.trc: ORA-12012: 自动执行作业 42568 出错 ORA-00607: 当更改数据块时出现内部错误 ORA-00607: 当更改数据块时出现内部错误 Sat Feb 25 15:05:59 2023 Flush retried for xcb 0xac4c5a80, pmd 0x8c0cec74 Doing block recovery for file 2 block 2951 Block recovery from logseq 10441, block 78 to scn 109906860017 Sat Feb 25 15:05:59 2023 Recovery of Online Redo Log: Thread 1 Group 3 Seq 10441 Reading mem 0 Mem# 0 errs 0: G:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG Sat Feb 25 15:05:59 2023 DEBUG: Replaying xcb 0xac458698, pmd 0x8d7e9b9c for failed op 8 Doing block recovery for file 2 block 1515 No block recovery was needed Sat Feb 25 15:05:59 2023 Block recovery completed at rba 10441.81.16, scn 25.2532677620 Sat Feb 25 15:06:00 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j002_6400.trc: ORA-00600: internal error code, arguments: [4194], [6], [4], [], [], [], [], [] Sat Feb 25 15:06:02 2023 DEBUG: Replaying xcb 0xac458698, pmd 0x8d7e9b9c for failed op 8 Doing block recovery for file 2 block 1515 No block recovery was needed Sat Feb 25 15:06:02 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_1076.trc: ORA-00600: 内部错误代码, 参数: [4194], [6], [4], [], [], [], [], [] Sat Feb 25 15:06:03 2023 PMON: terminating instance due to error 472 Sat Feb 25 15:06:03 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j007_7188.trc: ORA-00472: PMON 进程因错误而终止 Sat Feb 25 15:06:03 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j006_7624.trc: ORA-00472: PMON 进程因错误而终止 Sat Feb 25 15:06:03 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j005_5688.trc: ORA-00472: PMON process terminated with error Sat Feb 25 15:06:10 2023 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_7568.trc: ORA-00472: PMON 进程因错误而终止 Instance terminated by PMON, pid = 1076

这个ORA-600 4194错误主要是由于undo异常,从而引起pmon异常,报ORA-00472错误.对undo进行处理,数据库稳定open,逻辑导出数据,完成恢复工作,完美帮忙客户恢复数据.

标签：25,Feb,win,盘符,分飞,orcl,2023,ORA,Sat
From： https://www.cnblogs.com/xifenfei/p/17155543.html

win强制修改盘符导致oracle异常恢复----惜分飞

相关文章

赞助商

阅读排行