标签云
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,670)
- DB2 (22)
- MySQL (73)
- Oracle (1,532)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (21)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (14)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (65)
- Oracle Bug (8)
- Oracle RAC (52)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (560)
- Oracle安装升级 (91)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (78)
- 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)
-
最近发表
- 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-27102 OSD-00026 O/S-Error: (OS 1455)
- .[metro777@cock.li].Elbie勒索病毒加密数据库恢复
- 应用连接错误,初始化mysql数据库恢复
- RAC默认服务配置优先节点
- Oracle 19c RAC 替换私网操作
- 监听报TNS-12541 TNS-12560 TNS-00511错误
- drop tablespace xxx including contents恢复
- Linux 8 修改网卡名称
标签归档:ktbsdp2
ORA-600 ktbsdp2 处理
客户反馈数据库异常:两个节点rac,两个节点都启动,其中一个节点无法正常open,另外一个节点一段时间后也会挂。以下是无法正常open节点报错信息(正常open节点最终挂掉报错信息也是类似)
2022-03-30T19:19:12.870813+08:00 [84321] Successfully onlined Undo Tablespace 4. Undo initialization finished serial:0 start:1728252021 end:1728256302 diff:4281 ms (4.3 seconds) Verifying minimum file header compatibility for tablespace encryption.. Verifying file header compatibility for tablespace encryption completed for pdb 0 2022-03-30T19:19:13.953252+08:00 Database Characterset is ZHS16GBK 2022-03-30T19:19:14.538155+08:00 Errors in file /oracle/app/oracle/diag/rdbms/xff/xff2/trace/xff2_p02o_85718.trc (incident=1093927): ORA-00600: internal error code, arguments: [ktbsdp2], [18446744073709551615], [], [], [], [], [], [], [], [], [], [] Incident details in: /oracle/app/oracle/diag/rdbms/xff/xff2/incident/incdir_1093927/xff2_p02o_85718_i1093927.trc 2022-03-30T19:19:15.536582+08:00 ORACLE Instance xff2 (pid = 57) - Error 607 encountered while recovering transaction (73, 12) on object 112841. 2022-03-30T19:19:33.699944+08:00 Errors in file /oracle/app/oracle/diag/rdbms/xff/xff2/trace/xff2_smon_84007.trc: ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [ktbsdp2], [18446744073709551615], [], [], [], [], [], [], [], [], [], [] 2022-03-30T19:19:34.673840+08:00 Errors in file /oracle/app/oracle/diag/rdbms/xff/xff2/trace/xff2_smon_84007.trc: ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [ktbsdp2], [18446744073709551615], [], [], [], [], [], [], [], [], [], [] 2022-03-30T19:19:34.673954+08:00 Errors in file /oracle/app/oracle/diag/rdbms/xff/xff2/trace/xff2_smon_84007.trc: ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [ktbsdp2], [18446744073709551615], [], [], [], [], [], [], [], [], [], [] Errors in file /oracle/app/oracle/diag/rdbms/xff/xff2/trace/xff2_smon_84007.trc (incident=1092704): ORA-607 [] [] [] [] [] [] [] [] [] [] [] [] Incident details in: /oracle/app/oracle/diag/rdbms/xff/xff2/incident/incdir_1092704/xff2_smon_84007_i1092704.trc 2022-03-30T19:19:35.422779+08:00 ***************************************************************** An internal routine has requested a dump of selected redo. This usually happens following a specific internal error, when analysis of the redo logs will help Oracle Support with the diagnosis. It is recommended that you retain all the redo logs generated (by all the instances) during the past 12 hours, in case additional redo dumps are required to help with the diagnosis. ***************************************************************** 2022-03-30T19:19:36.154689+08:00 Starting background process GTX0 2022-03-30T19:19:36.169007+08:00 GTX0 started with pid=370, OS id=87409 2022-03-30T19:19:36.645876+08:00 USER (ospid: 84007): terminating the instance due to error 607 2022-03-30T19:19:36.680109+08:00 opiodr aborting process unknown ospid (87439) as a result of ORA-1092 2022-03-30T19:19:36.681091+08:00 ORA-1092 : opitsk aborting process 2022-03-30T19:19:36.740357+08:00 System state dump requested by (instance=2, osid=84007 (SMON)), summary=[abnormal instance termination]. System State dumped to trace file /oracle/app/oracle/diag/rdbms/xff/xff2/trace/xff2_diag_83895_20220330191936.trc 2022-03-30T19:19:40.135579+08:00 Instance terminated by USER, pid = 84007
对于上述报错信息分析,初步判断是由于事务异常导致,查询mos发现类似报错Bug 32208691 – After upgrade from 12.1 to 19.3 drop columns fails ORA-600[ktbsdp2] ORA-600[4512] (Doc ID 32208691.8),通过咨询客户,确认他们这边是通过plsql dev工具对id为112841表进行增加列的时候网络中断导致增加失败,后续我尝试对该表进行查询发现也报该错误,基本上可以确认由于该表事务异常导致,通过dul把该表数据恢复,然后drop 该表,数据库启动正常,未见其他报错,通过hcheck检查,数据库字典基本一致(除一些统计信息异常,原则上不影响数据库运行)
[oracle@xifenfei2 ~]$ sqlplus / as sysdba @hcheck.sql SQL*Plus: Release 12.2.0.1.0 Production on Thu Mar 31 00:38:32 2022 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production HCheck Version 07MAY18 on 31-MAR-2022 00:38:34 ---------------------------------------------- Catalog Version 12.2.0.1.0 (1202000100) db_name: xff Is CDB?: NO Catalog Fixed Procedure Name Version Vs Release Timestamp Result ------------------------------ ... ---------- -- ---------- -------------- ------ .- LobNotInObj ... 1202000100 <= *All Rel* 03/31 00:38:34 PASS .- MissingOIDOnObjCol ... 1202000100 <= *All Rel* 03/31 00:38:34 PASS .- SourceNotInObj ... 1202000100 <= *All Rel* 03/31 00:38:34 PASS .- OversizedFiles ... 1202000100 <= *All Rel* 03/31 00:38:38 PASS .- PoorDefaultStorage ... 1202000100 <= *All Rel* 03/31 00:38:38 PASS .- PoorStorage ... 1202000100 <= *All Rel* 03/31 00:38:38 PASS .- TabPartCountMismatch ... 1202000100 <= *All Rel* 03/31 00:38:38 PASS .- OrphanedTabComPart ... 1202000100 <= *All Rel* 03/31 00:38:38 PASS .- MissingSum$ ... 1202000100 <= *All Rel* 03/31 00:38:38 PASS .- MissingDir$ ... 1202000100 <= *All Rel* 03/31 00:38:38 PASS .- DuplicateDataobj ... 1202000100 <= *All Rel* 03/31 00:38:40 PASS .- ObjSynMissing ... 1202000100 <= *All Rel* 03/31 00:38:42 PASS .- ObjSeqMissing ... 1202000100 <= *All Rel* 03/31 00:38:42 PASS .- OrphanedUndo ... 1202000100 <= *All Rel* 03/31 00:38:44 PASS .- OrphanedIndex ... 1202000100 <= *All Rel* 03/31 00:38:44 PASS .- OrphanedIndexPartition ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- OrphanedIndexSubPartition ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- OrphanedTable ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- OrphanedTablePartition ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- OrphanedTableSubPartition ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- MissingPartCol ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- OrphanedSeg$ ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- OrphanedIndPartObj# ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- DuplicateBlockUse ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- FetUet ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- Uet0Check ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- SeglessUET ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- BadInd$ ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- BadTab$ ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- BadIcolDepCnt ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- ObjIndDobj ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- TrgAfterUpgrade ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- ObjType0 ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- BadOwner ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- StmtAuditOnCommit ... 1202000100 <= *All Rel* 03/31 00:38:45 PASS .- BadPublicObjects ... 1202000100 <= *All Rel* 03/31 00:38:46 PASS .- BadSegFreelist ... 1202000100 <= *All Rel* 03/31 00:38:50 PASS .- BadDepends ... 1202000100 <= *All Rel* 03/31 00:38:50 PASS .- CheckDual ... 1202000100 <= *All Rel* 03/31 00:38:57 PASS .- ObjectNames ... 1202000100 <= *All Rel* 03/31 00:38:57 WARN HCKW-0018: OBJECT name clashes with SCHEMA name (Doc ID 2363142.1) Schema=MHWZ PACKAGE=MHWZ.MHWZ Schema=MHWZ PACKAGE BODY=MHWZ.MHWZ .- BadCboHiLo ... 1202000100 <= *All Rel* 03/31 00:39:01 WARN HCKW-0019: HIST_HEAD$.LOWVAL > HIVAL (Doc ID 1361047.1) OBJ# 324163 INTCOL#=22 OBJ# 482668 INTCOL#=4 OBJ# 442865 INTCOL#=31 OBJ# 436924 INTCOL#=31 OBJ# 580529 INTCOL#=8 OBJ# 459432 INTCOL#=31 OBJ# 451260 INTCOL#=31 OBJ# 530980 INTCOL#=21 OBJ# 498442 INTCOL#=5 OBJ# 652114 INTCOL#=8 OBJ# 701695 INTCOL#=21 OBJ# 831961 INTCOL#=31 OBJ# 831962 INTCOL#=31 OBJ# 831963 INTCOL#=31 .- ChkIotTs ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS .- NoSegmentIndex ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS .- BadNextObject ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS .- DroppedROTS ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS .- FilBlkZero ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS .- DbmsSchemaCopy ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS .- OrphanedIdnseqObj ... 1202000100 > 1201000000 03/31 00:39:09 PASS .- OrphanedIdnseqSeq ... 1202000100 > 1201000000 03/31 00:39:09 PASS .- OrphanedObjError ... 1202000100 > 1102000000 03/31 00:39:09 PASS .- ObjNotLob ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS .- MaxControlfSeq ... 1202000100 <= *All Rel* 03/31 00:39:09 PASS .- SegNotInDeferredStg ... 1202000100 > 1102000000 03/31 00:39:13 PASS .- SystemNotRfile1 ... 1202000100 > 902000000 03/31 00:39:13 PASS .- DictOwnNonDefaultSYSTEM ... 1202000100 <= *All Rel* 03/31 00:39:13 PASS .- OrphanTrigger ... 1202000100 <= *All Rel* 03/31 00:39:13 PASS .- ObjNotTrigger ... 1202000100 <= *All Rel* 03/31 00:39:13 PASS --------------------------------------- 31-MAR-2022 00:39:13 Elapsed: 39 secs --------------------------------------- Found 0 potential problem(s) and 16 warning(s) Contact Oracle Support with the output and trace file to check if the above needs attention or not PL/SQL procedure successfully completed. Statement processed. Complete output is in trace file: /oracle/app/oracle/diag/rdbms/xff/xff2/trace/xff2_ora_26887_HCHECK.trc