标签云
asm恢复 bbed bootstrap$ dul kcbzib_kcrsds_1 kccpb_sanity_check_2 kcratr_nab_less_than_odr MySQL恢复 ORA-00312 ORA-00704 ORA-00742 ORA-01110 ORA-01200 ORA-01555 ORA-01578 ORA-01595 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-600 kcratr_nab_less_than_odr ORA-600 kdsgrp1 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)
- 操作系统 (112)
- 数据库 (1,841)
- DB2 (22)
- MySQL (81)
- Oracle (1,669)
- Data Guard (53)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (168)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (69)
- Oracle Bug (8)
- Oracle RAC (55)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (29)
- Oracle备份恢复 (632)
- Oracle安装升级 (103)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (89)
- PostgreSQL (37)
- pdu工具 (7)
- PostgreSQL恢复 (13)
- SQL Server (34)
- SQL Server恢复 (14)
- TimesTen (7)
- 达梦数据库 (4)
- 达梦恢复 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (47)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (30)
-
最近发表
- aix环境rac 私网直连导致haip启动异常
- 又一例TRIM导致asm磁盘数据丢失的故障
- 一次运气好的ORA-600 kcratr_nab_less_than_odr故障处理
- OraFHR快速open被勒索加密破坏的Oracle数据库
- obet一键恢复offline数据文件
- 记录一次win删除数据文件完美恢复案例
- Oracle典型故障:The controlfile header block returned by the OS has a sequence number that is too old
- 国产信创库fio破坏主备库以及备份故障处理
- .wman扩展名勒索mysql数据库恢复
- Oracle数据库被勒索加密一键open工具–OraFHR
- 通过alert日志回顾其他dba oracle异常恢复故障处理以及后续open数据库操作
- 年前几例Oracle数据库被加密为.wman的数据库故障恢复
- 文件系统损坏导致数据库异常故障处理
- expdp导出xml列报ORA-22924故障处理
- obet处理ORA-704 ORA-604 ORA-1578故障
- obet修复csc higher than block scn类型坏块
- ORA-600 kcratr_nab_less_than_odr和ORA-600 4193故障处理
- aix环境10g由于控制器异常导致ORA-600 4000故障处理
- ORA-600 3716故障处理
- 不当恢复truncate数据导致数据库不能open处理
标签归档:ORA-600 6856
通过alert日志回顾其他dba oracle异常恢复故障处理以及后续open数据库操作
客户有一个数据库故障,是其他工程师进行恢复操作,最后搞不定通过朋友介绍找到我的.我通过分析alert日志,大概追述故障经过
1. 数据库断电之后启动报ORA-01172 ORA-01151错误,直接启动数据库失败,从报错看是由于数据库在open过程中前滚redo日志异常导致
Thu Feb 26 06:48:35 2026 alter database open Beginning crash recovery of 1 threads parallel recovery started with 23 processes Started redo scan Completed redo scan read 73194 KB redo, 37226 data blocks need recovery Thu Feb 26 06:48:49 2026 Started redo application at Thread 1: logseq 869366, block 3 Recovery of Online Redo Log: Thread 1 Group 2 Seq 869366 Reading mem 0 Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG Thu Feb 26 06:48:50 2026 RECOVERY OF THREAD 1 STUCK AT BLOCK 16938 OF FILE 3 Slave exiting with ORA-1172 exception Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_p016_4672.trc: ORA-01172: recovery of thread 1 stuck at block 16938 of file 3 ORA-01151: use media recovery to recover block, restore backup if needed Aborting crash recovery due to slave death, attempting serial crash recovery Beginning crash recovery of 1 threads Started redo scan Thu Feb 26 06:49:00 2026 Completed redo scan read 73194 KB redo, 37226 data blocks need recovery Started redo application at Thread 1: logseq 869366, block 3 Thu Feb 26 06:49:10 2026 Recovery of Online Redo Log: Thread 1 Group 2 Seq 869366 Reading mem 0 Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG RECOVERY OF THREAD 1 STUCK AT BLOCK 16938 OF FILE 3 Aborting crash recovery due to error 1172 Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_9260.trc: ORA-01172: recovery of thread 1 stuck at block 16938 of file 3 ORA-01151: use media recovery to recover block, restore backup if needed Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_9260.trc: ORA-01172: recovery of thread 1 stuck at block 16938 of file 3 ORA-01151: use media recovery to recover block, restore backup if needed ORA-1172 signalled during: alter database open...
2. 尝试recover database报ORA-600 3020、ORA-600 17147、ORA-600 17114、ORA-600 17182等错误,这个报错比较明确是由于redo的block信息和datafile的block不一致,导致实例recover database失败
Thu Feb 26 06:50:54 2026 ALTER DATABASE RECOVER database Media Recovery Start started logmerger process Parallel Media Recovery started with 24 slaves Thu Feb 26 06:50:57 2026 Recovery of Online Redo Log: Thread 1 Group 2 Seq 869366 Reading mem 0 Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG Thu Feb 26 06:50:59 2026 Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_pr0i_9232.trc (incident=79538): ORA-00600: internal error code, arguments: [3020], [3], [16934], [12599846], [], [], [], [], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 3, block# 16934, file offset is 138723328 bytes) ORA-10564: tablespace UNDOTBS1 ORA-01110: data file 3: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF' ORA-10560: block type 'KTU UNDO BLOCK' Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_79538\orcl_pr0i_9232_i79538.trc Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_pr0i_9232.trc (incident=79539): ORA-00600: internal error code, arguments: [17114], [0x0381C4C60], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [17182], [0x0381C6948], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [17147], [0x0381C4C60], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [3020], [3], [16934], [12599846], [], [], [], [], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 3, block# 16934, file offset is 138723328 bytes) ORA-10564: tablespace UNDOTBS1 ORA-01110: data file 3: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF' ORA-10560: block type 'KTU UNDO BLOCK'
3. 使用隐含参数尝试强制拉库,报ORA-600 2662错误,导致强制拉库没有成功,这个错误相对比较简单,一般修改数据库scn即可
Thu Feb 26 07:04:39 2026 alter database open resetlogs RESETLOGS is being done without consistancy checks. This may result in a corrupted database. The database should be recreated. RESETLOGS after incomplete recovery UNTIL CHANGE 16794964253372 Resetting resetlogs activation ID 1548038913 (0x5c453301) Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_8712.trc: ORA-00367: checksum error in log file header ORA-00322: log 1 of thread 1 is not current copy ORA-00312: online log 1 thread 1: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG' Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_8712.trc: ORA-00367: checksum error in log file header ORA-00322: log 2 of thread 1 is not current copy ORA-00312: online log 2 thread 1: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG' Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_8712.trc: ORA-00367: checksum error in log file header ORA-00322: log 3 of thread 1 is not current copy ORA-00312: online log 3 thread 1: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG' Thu Feb 26 07:04:49 2026 Setting recovery target incarnation to 3 Thu Feb 26 07:04:50 2026 Assigning activation ID 1753992092 (0x688bcb9c) Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG Successful open of redo thread 1 Thu Feb 26 07:04:50 2026 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Thu Feb 26 07:04:50 2026 SMON: enabling cache recovery Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_8712.trc (incident=82031): ORA-00600: internal error code, arguments: [2662], [3910], [1642126020], [3910], [1642126047], [4194432] Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_8712.trc: ORA-00600: internal error code, arguments: [2662], [3910], [1642126020], [3910], [1642126047], [4194432] Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_8712.trc: ORA-00600: internal error code, arguments: [2662], [3910], [1642126020], [3910], [1642126047], [4194432] Error 600 happened during db open, shutting down database USER (ospid: 8712): terminating the instance due to error 600 Thu Feb 26 07:05:00 2026 Instance terminated by USER, pid = 8712 ORA-1092 signalled during: alter database open resetlogs... opiodr aborting process unknown ospid (8712) as a result of ORA-1092
4. 尝试重新open库,数据库open成功但是报ORA-600 kturbleurec1、ORA-600 kcbgtcr_13错误,数据库运行一会就直接crash,这个错误一般是由于undo异常导致
Thu Feb 26 07:09:10 2026 alter database open Beginning crash recovery of 1 threads parallel recovery started with 23 processes Started redo scan Completed redo scan read 0 KB redo, 0 data blocks need recovery Started redo application at Thread 1: logseq 1, block 3, scn 16794964253378 Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0 Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG Completed redo application of 0.00MB Completed crash recovery at Thread 1: logseq 1, block 3, scn 16794964273379 0 data blocks read, 0 data blocks written, 0 redo k-bytes read Thu Feb 26 07:09:14 2026 Thread 1 advanced to log sequence 2 (thread open) Thread 1 opened at log sequence 2 Current log# 2 seq# 2 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Thu Feb 26 07:09:14 2026 SMON: enabling cache recovery Successfully onlined Undo Tablespace 2. Dictionary check beginning Dictionary check complete 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 Thu Feb 26 07:09:21 2026 Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_p002_10096.trc (incident=84847): ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_84847\orcl_p002_10096_i84847.trc Thu Feb 26 07:09:21 2026 Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_4600.trc (incident=84831): ORA-00600: internal error code, arguments: [kcbgtcr_13], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_84831\orcl_ora_4600_i84831.trc Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_4600.trc (incident=84832): ORA-00600: internal error code, arguments: [kcbgtcr_13], [], [], [], [], [], [], [], [], [], [], [] Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_84832\orcl_ora_4600_i84832.trc
客户那边还做了各种恢复尝试,最终依旧无法正常open库,让我这边进行恢复支持.由于客户库不大,而且可以提供数据进行恢复,我让客户发生我数据之后,在本地电脑上进行恢复,下载文件之后,重命名相关路径然后尝试open库
SQL> recover database; ORA-00283: 恢复会话因错误而取消 ORA-16433: 必须以读/写模式打开数据库。
重建控制文件
C:\Users\XFF>sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on 星期五 2月 27 14:36:57 2026 Copyright (c) 1982, 2010, Oracle. All rights reserved. 已连接到空闲例程。 SQL> startup nomount pfile='d:/pfile.txt' ORACLE 例程已经启动。 Total System Global Area 4275781632 bytes Fixed Size 2182592 bytes Variable Size 973079104 bytes Database Buffers 3288334336 bytes Redo Buffers 12185600 bytes SQL> @rectl.sql 控制文件已创建。 SQL> recover database; 完成介质恢复。
尝试open库报ORA-600 2663错误
SQL> alter database open; alter database open * 第 1 行出现错误: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [2663], [3910], [1642323772], [3910], [1642327019], [], [], [], [], [], [], [] 进程 ID: 27296 会话 ID: 14 序列号: 3
使用Patch_SCN工具修改数据库scn

再次尝试open数据库
SQL> recover database; 完成介质恢复。 SQL> alter database open ; 数据库已更改。
alert日志报ORA-600 6856错误
Fri Feb 27 14:40:03 2026 QMNC started with pid=62, OS id=18360 LOGSTDBY: Validating controlfile with logical metadata LOGSTDBY: Validation complete Completed: alter database open Fri Feb 27 14:40:03 2026 Errors in file c:\app\xff\diag\rdbms\orcl\orcl\trace\orcl_p001_21540.trc (incident=15787): ORA-00600: 内部错误代码, 参数: [6856], [0], [479], [], [], [], [], [], [], [], [], [] Incident details in: c:\app\xff\diag\rdbms\orcl\orcl\incident\incdir_15787\orcl_p001_21540_i15787.trc Fri Feb 27 14:40:04 2026 Starting background process CJQ0 Fri Feb 27 14:40:04 2026 CJQ0 started with pid=63, OS id=15592 Doing block recovery for file 8 block 1541549 Resuming block recovery (PMON) for file 8 block 1541549 Block recovery from logseq 3, block 108 to scn 16794965431265 Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0 Mem# 0: H:\BAIDUNETDISK\20260227\REDO03.LOG Block recovery completed at rba 3.16415.16, scn 3910.1643303906 Fri Feb 27 14:40:04 2026 Trace dumping is performing id=[cdmp_20260227144004] SMON: ignoring slave err,downgrading to serial rollback Errors in file c:\app\xff\diag\rdbms\orcl\orcl\trace\orcl_smon_21696.trc (incident=15723): ORA-00600: 内部错误代码, 参数: [6856], [0], [479], [], [], [], [], [], [], [], [], [] Incident details in: c:\app\xff\diag\rdbms\orcl\orcl\incident\incdir_15723\orcl_smon_21696_i15723.trc ……………… ORACLE Instance orcl (pid = 15) - Error 607 encountered while recovering transaction (3, 10) on object 81310. Errors in file c:\app\xff\diag\rdbms\orcl\orcl\trace\orcl_smon_21696.trc: ORA-00607: 当更改数据块时出现内部错误 ORA-00600: 内部错误代码, 参数: [6856], [0], [479], [], [], [], [], [], [], [], [], [] Process debug not enabled via parameter _debug_enable Trace dumping is performing id=[cdmp_20260227144011] PMON (ospid: 23760): terminating the instance due to error 474
该错误是undo异常引起,屏蔽掉异常undo之后,正常open,并顺利导出所有数据,完成本次恢复任务

记录一次pdb恢复过程中遇到的大量bug
12C版本使用pdb的Oracle数据库,由于在创建index的过程中强制终止,导致业务大量阻塞,然后重启数据库几次之后直接crash,最后直接无法open成功,报ORA-00600 6856
SQL> alter database open; alter database open * ERROR at line 1: ORA-01578: ORACLE data block corrupted (file # 22, block # 993741) ORA-01110: data file 22: '+DATA/XIFENFEI/96D12F7BA1E2CE57E0532506060A4A2D/DATAFILE/xff01.309.1050943869' ORA-10564: tablespace CWBASEMS01 ORA-01110: data file 22: '+DATA/XIFENFEI/96D12F7BA1E2CE57E0532506060A4A2D/DATAFILE/xff01.309.1050943869' ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 76286 ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [6856], [0], [12], [], [], [], [],[], [], [], [], []
2020-11-14T15:56:50.736722+08:00 Started redo scan 2020-11-14T15:56:50.977023+08:00 Completed redo scan read 82825 KB redo, 10769 data blocks need recovery 2020-11-14T15:56:51.147256+08:00 Started redo application at Thread 1: logseq 120309, block 48, offset 0 Thread 2: logseq 74989, block 2, offset 16, scn 0x00000000f69e1f8d 2020-11-14T15:56:51.151007+08:00 Recovery of Online Redo Log: Thread 1 Group 1 Seq 120309 Reading mem 0 Mem# 0: +DATA/XIFENFEI/ONLINELOG/group_1.262.1023806467 2020-11-14T15:56:51.153989+08:00 Recovery of Online Redo Log: Thread 2 Group 7 Seq 74989 Reading mem 0 Mem# 0: +DATA/XIFENFEI/ONLINELOG/group_7.274.1023806785 Errors in file /u01/app/oracle/……/xifenfei1/trace/xifenfei1_p00d_469777.trc(incident=10079552)(PDBNAME=CDB$ROOT): ORA-00600: internal error code, arguments: [6856], [0], [12], [], [], [], [], [], [], [], [], [] 2020-11-14T15:56:52.089726+08:00 (3):Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details.
这个错误比较明显是由于ORA-600 6856错误导致数据库在启动的时候无法进行实例恢复,出现这个错误原因是由于客户创建index的过程中强制终止引起Bug 17437634 – ORA-1578 or ORA-600 [6856] transient in-memory corruption on TEMP segment during transaction recovery / ROLLBACK (eg: after Ctrl-C) – superseded (Doc ID 17437634.8),屏蔽该文件实例恢复,cdb启动成功,但是pdb无法正常open
SQL> alter session set container=pdb1; Session altered. SQL> alter database open; alter database open * ERROR at line 1: ORA-00603: ORACLE server session terminated by fatal error ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [kcffo_online_pdb_check:fno_system], [3], [], [] Process ID: 224476 Session ID: 13311 Serial number: 59525
这个错误比较明显是由于ORA-600 kcffo_online_pdb_check:fno_system,数据库未正常检测到pdb的system文件导致该问题,通过对pdb的system文件进行操作,让数据库识别到该文件,然后继续open库
SQL> alter database open; alter database open * ERROR at line 1: ORA-00603: ORACLE server session terminated by fatal error ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [kcvfdb_pdb_set_clean_scn: cleanckpt],[3],[4138003978],[4289274940], [2] Process ID: 224476 Session ID: 13311 Serial number: 59525
该错误是由于数据库在恢复的过程中推了scn,触发了oracle 某种bug导致该问题,通过一些操作之后,数据库可以open,尝试temp表空间增加临时数据文件报ORA-00600 [kcffo_add_tmpf-1] 错误(Bug 29379978 – ORA-00600 [kcffo_add_tmpf-1] when trying to add temp file (Doc ID 29379978.8)).由于该文件无法加入,数据库无法导出

最后没有办法换了思路直接bbed修改文件头,open cdb库,然后open pdb,顺利导出数据.这次的恢复中,深刻的体验到pdb在open过程中的各种bug,实在比较厌烦.
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
数据库启动报ORA-00600 6006错误
Tue Sep 29 14:31:31 2020 SMON: enabling tx recovery Tue Sep 29 14:31:31 2020 Database Characterset is AL32UTF8 Opening with internal Resource Manager plan where NUMA PG = 2, CPUs = 4 Tue Sep 29 14:31:34 2020 SMON: Restarting fast_start parallel rollback Tue Sep 29 14:31:34 2020 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=64, OS id=2860 Tue Sep 29 14:31:39 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_p000_1084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:31:44 2020 SMON: Parallel transaction recovery slave got internal error SMON: Downgrading transaction recovery to serial Tue Sep 29 14:31:48 2020 Completed: ALTER DATABASE OPEN Tue Sep 29 14:31:48 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:31:48 2020 db_recovery_file_dest_size of 8192 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. Tue Sep 29 14:31:53 2020 ORACLE Instance orcl (pid = 16) - Error 600 encountered while recovering transaction (1, 8) on object 53228. Tue Sep 29 14:31:54 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:32:03 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:32:07 2020 ORACLE Instance orcl (pid = 16) - Error 600 encountered while recovering transaction (1, 8) on object 53228. Tue Sep 29 14:32:07 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:32:13 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] ORACLE Instance orcl (pid = 16) - Error 600 encountered while recovering transaction (1, 8) on object 53228. Tue Sep 29 14:32:15 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:32:21 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:32:23 2020 ORACLE Instance orcl (pid = 16) - Error 600 encountered while recovering transaction (1, 8) on object 53228. Tue Sep 29 14:32:23 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:32:30 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3084.trc: ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Tue Sep 29 14:32:31 2020 Errors in file g:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_3860.trc: ORA-00474: SMON process terminated with error Tue Sep 29 14:32:31 2020 PMON: terminating instance due to error 474
因为这个错误提示比较明显“ORACLE Instance orcl (pid = 16) – Error 600 encountered while recovering transaction (1, 8) on object 53228.”和以前的文章:ORACLE Instance XFF (pid = 18) – Error 600 encountered while recovering transaction非常相似,由于数据库异常关闭导致事务无法正常回滚.通过屏蔽回滚(event 10513),然后对相关对象进行处理(表导出数据,重新导入;index 进行重建),可以实现数据库的完美恢复
关于ORA-600 6006 ORA-600 6856解释
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [] Oracle is undoing an index leaf key operation. If the key is not found, --oracle 回滚index leaf key操作,如果这个值不存在,报ORA-600 6006错误 ORA-00600: internal error code, arguments: [6856], [0], [60], [], [], [] SMON is trying to recover a dead transaction. But the undo application runs into an internal error (trying to delete a row that is already deleted). --oracle 的回滚操作尝试删除一个已经删除的记录报ORA-600 6856错误

加我微信(17813235971)
加我QQ(107644445)

