标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (102)
- 数据库 (1,679)
- DB2 (22)
- MySQL (73)
- Oracle (1,541)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (14)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (67)
- Oracle Bug (8)
- Oracle RAC (52)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (563)
- Oracle安装升级 (92)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (79)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- 解决oracle数据文件路径有回车故障
- .wstop扩展名勒索数据库恢复
- Oracle Recovery Tools工具一键解决ORA-00376 ORA-01110故障(文件offline)
- OGG-02771 Input trail file format RELEASE 19.1 is different from previous trail file form at RELEASE 11.2.
- OGG-02246 Source redo compatibility level 19.0.0 requires trail FORMAT 12.2 or higher
- GoldenGate 19安装和打patch
- dd破坏asm磁盘头恢复
- 删除asmlib磁盘导致磁盘组故障恢复
- Kylin Linux 安装19c
- ORA-600 krse_arc_complete.4
- Oracle 19c 202410补丁(RUs+OJVM)
- ntfs MFT损坏(ntfs文件系统故障)导致oracle异常恢复
- .mkp扩展名oracle数据文件加密恢复
- 清空redo,导致ORA-27048: skgfifi: file header information is invalid
- A_H_README_TO_RECOVER勒索恢复
- 通过alert日志分析客户自行对一个数据库恢复的来龙去脉和点评
- ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME
- ORA-01092 ORA-00604 ORA-01558故障处理
- ORA-65088: database open should be retried
- Oracle 19c异常恢复—ORA-01209/ORA-65088
标签归档:ksuapc2
win强制修改盘符导致oracle异常恢复
有客户反馈,他们在系统没有关闭数据库的情况下,强制修改了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,逻辑导出数据,完成恢复工作,完美帮忙客户恢复数据.
发表在 Oracle备份恢复
标签为 ksuapc2, ORA-00081, ORA-00472, ORA-600 2037, ORA-600 4194, _kews_idle_wait, _kmcgms, _kslwlmod, _ksuitm
评论关闭