标签云
asm 恢复 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 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)
- 操作系统 (100)
- 数据库 (1,598)
- DB2 (22)
- MySQL (70)
- Oracle (1,463)
- Data Guard (49)
- EXADATA (7)
- GoldenGate (21)
- ORA-xxxxx (158)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (13)
- ORACLE 21C (3)
- Oracle ASM (65)
- Oracle Bug (7)
- Oracle RAC (47)
- Oracle 安全 (6)
- Oracle 开发 (27)
- Oracle 监听 (27)
- Oracle备份恢复 (530)
- Oracle安装升级 (84)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (75)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (36)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (19)
-
最近发表
- PostgreSQL解析wal日志之—walminer
- Oracle 19c/21c最新patch信息-202404
- PostgreSQL恢复系列:pg_filedump批量处理
- PostgreSQL部分主要字典信息
- PostgreSQL恢复系列:pg_filedump恢复字典构造
- PostgreSQL 16 源码安装
- ORA-00742 ORA-00312 恢复
- 数据库open成功后报ORA-00353 ORA-00354错误引起的一系列问题(本质ntfs文件系统异常)
- ORA-600 ktsiseginfo1故障
- ORA-00600: internal error code, arguments: [16703], [1403], [4] 原因
- 最近遇到几起ORA-600 16703故障(tab$被清空),请引起重视
- ORA-600 2662快速恢复之Patch scn工具
- TNS-12518: TNS:listener could not hand off client connection
- ora.storage无法启动报ORA-12514故障处理
- 断电引起文件scn异常数据库恢复
- ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
- .[hudsonL@cock.li].mkp勒索加密数据库完美恢复
- 模拟带库实现rman远程备份
- 又一例:ORA-600 kclchkblk_4和2662故障
- Oracle误删除数据文件恢复
月归档:九月 2012
ORA-00600[kccpb_sanity_check_2]
alert日志出现如下错误
数据库在mount的时候,因为出现ORA-00600[kccpb_sanity_check_2]错误导致数据库不能正常被mount成功
--sqlplus中报错 SQL> startup nomount; ORACLE instance started. Total System Global Area 4294967296 bytes Fixed Size 2273256 bytes Variable Size 1486573592 bytes Database Buffers 2801795072 bytes Redo Buffers 4325376 bytes SQL> alter database mount; alter database mount * ERROR at line 1: ORA-600: internal error code, arguments: [kccpb_sanity_check_2], [2825], [2824], [0x000000000], [], [], [], [] --alert日志 Mon Sep 24 16:35:37 2012 ALTER DATABASE MOUNT Mon Sep 24 16:35:41 2012 Errors in file /opt/app/oracle/admin/lhgk/udump/lhgk_ora_17034.trc: ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [2825], [2824], [0x000000000], [], [], [], [] Mon Sep 24 16:35:41 2012 ORA-600 signalled during: ALTER DATABASE MOUNT...
错误原因
ORA-600 [kccpb_sanity_check_2] indicates that the seq# of the last read block is higher than the seq# of the control file header block. This is indication of the lost write of the header block during commit of the previous cf transaction.
解决方法
1) restore a backup of a controlfile and recover OR 2) recreate the controlfile OR 3) restore the database from last good backup and recover NOTE: If you do not have any special backup of control file to restore and you are using Multiple Control File copies in your pfile/init.ora/spfile you can attempt to mount the database using each control file one by one. If you are able to mount the database with any of these control file copies you can then issue 'alter database backup controlfile to trace' to recreate controlfile.
在win中运行bbed程序
学习ORACLE三剑客:互联网,ORACLE资料,交流.今天在朋友的帮助下,了结了一个心结:在WIN平台中完美的使用bbed(8i/9i部分版本/10g 11g不支持),今天在朋友的帮助下解决了该问题
9i中bbed相关程序
Microsoft Windows [版本 6.1.7601] 版权所有 (c) 2009 Microsoft Corporation。保留所有权利。 C:\Users\XIFENFEI>cd E:\study\Oracle\数据库非常规恢复\bbed\win-bbed\bbed_win C:\Users\XIFENFEI>e: E:\study\Oracle\数据库非常规恢复\bbed\win-bbed\bbed_win>dir 驱动器 E 中的卷没有标签。 卷的序列号是 000C-3B41 E:\study\Oracle\数据库非常规恢复\bbed\win-bbed\bbed_win 的目录 2012/09/24 19:45 <DIR> . 2012/09/24 19:45 <DIR> .. 2006/07/29 13:33 147,728 bbed.exe 2006/06/28 11:32 20,752 heteroxa9.dll 2004/10/26 16:35 49,152 kpp95rdr.dll 2004/10/26 16:35 45,056 kpp97rdr.dll 2012/09/24 19:49 250 log.bbd 2006/07/29 02:08 229,648 njssl9.dll 2006/06/28 11:33 61,712 ocijdbc9.dll 2002/04/26 16:22 733,184 oip9.dll 2006/07/29 14:02 1,589,520 oraclient9.dll 2006/07/29 15:25 602,384 oracommon9.dll 2006/06/28 09:54 651,536 ORACORE9.DLL 2006/06/27 08:44 1,736,976 oractxx9.dll 2006/07/29 14:02 2,691,344 orageneric9.dll 2006/07/29 13:56 24,576 oraimr9.dll 2006/07/29 15:19 3,014,656 orajox9.dll 2006/06/28 03:09 155,920 oraldapclnt9.dll 2006/06/28 03:09 24,848 oraldapjclnt9.dll 2006/07/29 02:18 741,648 oran9.dll 2006/07/29 02:10 41,232 oranad9.dll 2006/07/29 02:06 33,040 oranbeq9.dll 2006/07/29 02:08 24,848 ORANCDS9.DLL 2006/07/29 02:07 98,576 orancrypt9.dll 2006/07/29 02:07 33,040 ORANGSS9.DLL 2006/07/29 02:07 24,848 oranhost9.dll 2006/07/29 02:06 33,040 oranipc9.dll 2006/07/29 02:08 176,400 oranjni9.dll 2006/07/29 02:07 213,264 ORANK59.DLL 2006/07/29 02:06 180,496 oranl9.dll 2006/07/29 02:07 74,000 oranldap9.dll 2006/07/29 02:08 28,944 oranldapj9.dll 2006/06/28 06:32 499,984 ORANLS9.DLL 2006/07/29 02:06 33,040 orannmp9.dll 2006/07/29 02:07 53,520 orannts9.dll 2006/07/29 02:07 28,944 orannzentr9.dll 2006/07/29 02:08 28,944 ORANNZMCS9.DLL 2006/07/29 02:07 586,000 orannzsbb9.dll 2006/07/29 02:07 24,848 oranoname9.dll 2006/07/29 02:08 57,616 oranoncj9.dll 2006/07/29 02:07 45,328 ORANRAD9.DLL 2006/07/29 02:06 225,552 oranro9.dll 2006/07/29 02:08 41,232 oransgr9.dll 2006/07/29 02:06 49,424 orantcp9.dll 2006/07/29 02:07 53,520 ORANTCPS9.DLL 2006/07/29 02:07 28,944 orantns9.dll 2006/07/29 13:58 57,784 oraobjop9.dll 2006/07/29 14:58 311,568 oraocci9.dll 2006/07/29 14:02 24,848 oraodm9.dll 2006/06/26 19:19 2,314,240 oraolapapi9.dll 2006/07/29 13:58 57,784 oraolapop9.dll 2006/07/18 08:53 377,104 oraordim9.dll 2006/07/29 12:39 61,712 ORAPLC9.DLL 2006/07/29 12:40 909,584 ORAPLP9.DLL 2006/07/29 12:39 3,281,168 ORAPLS9.DLL 2006/07/29 13:58 57,784 ORAPRTOP9.DLL 2003/01/22 18:59 20,480 orarac9.dll 2002/04/26 17:18 28,944 ORASLAX9.DLL 2006/06/28 06:33 69,904 ORASNLS9.DLL 2006/06/28 16:04 483,600 ORASQL9.DLL 2002/04/29 14:04 246,032 oratrace9.dll 2002/04/29 14:04 86,288 oratracepls9.dll 2006/06/28 06:32 69,904 ORAUNLS9.DLL 2006/07/29 14:02 24,848 oravsn9.dll 2005/03/29 17:17 24,576 orawsec9.dll 2006/07/29 14:02 24,848 orawtc9.dll 2001/04/16 19:19 191,248 orawwg9.dll 2006/06/27 01:50 520,464 ORAXML9.DLL 2006/06/27 01:50 41,232 ORAXMLG9.DLL 2006/06/27 01:50 172,304 ORAXSD9.DLL 2010/06/29 05:38 181,560 vspp97.dll 2010/06/29 05:38 83,256 vsqp9.dll 2010/06/29 05:38 177,464 vsw97.dll 72 个文件 25,234,522 字节 2 个目录 58,747,236,352 可用字节
执行bbed程序报错
E:\study\Oracle\数据库非常规恢复\bbed\win-bbed\bbed_win>bbed Message 112 not found; No message file for product=RDBMS, facility=BBED BBED-00113: file not found
分析原因:因为在11g中ORACLE并没有在?/RDBMS/MESG/中提供bbedus.msb程序,导致bbed运行时候无法显示相关提示信息,从而出现类此该错误
解决方法:在11g环境中需要从10g库中拷贝bbedus.msb文件放置到?/RDBMS/MESG/中即可
运行bbed程序
E:\study\Oracle\数据库非常规恢复\bbed\win-bbed\bbed_win>bbed Password: BBED: Release 2.0.0.0.0 - Limited Production on Mon Sep 24 19:45:40 2012 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. ************* !!! For Oracle Internal Use only !!! *************** BBED> info all; File# Name Size(blks) ----- ---- ---------- BBED> show all; FILE# 0 BLOCK# 1 OFFSET 0 DBA 0x00000000 (0 0,1) FILENAME BIFILE bifile.bbd LISTFILE BLOCKSIZE 2048 MODE Browse EDIT Unrecoverable IBASE Dec OBASE Dec WIDTH 80 COUNT 512 LOGFILE log.bbd SPOOL No