标签云
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,678)
- DB2 (22)
- MySQL (73)
- Oracle (1,540)
- 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)
-
最近发表
- .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
- ORA-600 16703故障再现
标签归档:ORA-600 6856
记录一次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错误