标签云
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,674)
- DB2 (22)
- MySQL (73)
- Oracle (1,536)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (22)
- 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备份恢复 (562)
- Oracle安装升级 (92)
- 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)
-
最近发表
- 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-27102 OSD-00026 O/S-Error: (OS 1455)
- .[metro777@cock.li].Elbie勒索病毒加密数据库恢复
- 应用连接错误,初始化mysql数据库恢复
- RAC默认服务配置优先节点
标签归档:bootstrap$
恶意删除bootstrap$导致数据库无法正常启动
有客户10.2.0.5的数据库关闭之后,无法正常启动报ORA-00704 ORA-00702错误.使用自研的ORA-702_Recovery Tool小工具可以实现一键恢复,下载地址:ORA-702_Recovery下载
Fri May 18 22:42:26 2018 ALTER DATABASE OPEN Fri May 18 22:42:27 2018 Beginning crash recovery of 1 threads parallel recovery started with 7 processes Fri May 18 22:42:27 2018 Started redo scan Fri May 18 22:42:27 2018 Completed redo scan 1 redo blocks read, 0 data blocks need recovery Fri May 18 22:42:27 2018 Started redo application at Thread 1: logseq 2, block 2, scn 8448162573 Fri May 18 22:42:27 2018 Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0 Mem# 0: D:\DATABASE\xifenfei\REDO02.LOG Fri May 18 22:42:27 2018 Completed redo application Fri May 18 22:42:27 2018 Completed crash recovery at Thread 1: logseq 2, block 3, scn 8448182575 0 data blocks read, 0 data blocks written, 1 redo blocks read Fri May 18 22:42:28 2018 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=23, OS id=3188 ARC1 started with pid=24, OS id=3168 ARC2 started with pid=25, OS id=996 ARC3 started with pid=26, OS id=432 ARC4 started with pid=27, OS id=3728 Fri May 18 22:42:28 2018 ARC0: Archival started ARC1: Archival started ARC5 started with pid=28, OS id=2876 Fri May 18 22:42:28 2018 ARC2: Archival started ARC3: Archival started ARC4: Archival started ARC5: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Fri May 18 22:42:28 2018 Thread 1 advanced to log sequence 3 (thread open) Thread 1 opened at log sequence 3 Current log# 3 seq# 3 mem# 0: D:\DATABASE\xifenfei\REDO03.LOG Successful open of redo thread 1 Fri May 18 22:42:28 2018 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Fri May 18 22:42:28 2018 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Fri May 18 22:42:28 2018 ARC2: Becoming the heartbeat ARCH Fri May 18 22:42:28 2018 SMON: enabling cache recovery Fri May 18 22:42:28 2018 Errors in file d:\oracle\product\10.2.0\admin\xifenfei\udump\xifenfei_ora_3148.trc: ORA-00704: 引导程序进程失败 ORA-00702: 引导程序版本 '' 与版本 '8.0.0.0.0' 不一致 Fri May 18 22:42:28 2018 Error 704 happened during db open, shutting down database USER: terminating instance due to error 704 Instance terminated by USER, pid = 3148 ORA-1092 signalled during: ALTER DATABASE OPEN...
根据以前恢复经验ORA-00702: bootstrap verison ” inconsistent with version ’8.0.0.0.0′,很可能是由于bootstrap$表异常了.
通过dbv检查system文件确认没有坏块
通过bbed分析,确认记录被删除
把数据文件拷贝到本地,通过bbed进行分析,确认记录丢失
BBED> map File: d:/system01.dbf (0) Block: 379 Dba:0x00000000 ------------------------------------------------------------ KTB Data Block (Table/Cluster) struct kcbh, 20 bytes @0 struct ktbbh, 48 bytes @20 struct kdbh, 14 bytes @68 struct kdbt[1], 4 bytes @82 sb2 kdbr[24] @86 ub1 freespace[1158] @134 ub1 rowdata[6896] @1292 ub4 tailchk @8188 BBED> p *kdbr[0] rowdata[6875] ------------- ub1 rowdata[6875] @8167 0x3c BBED> x /rnnc rowdata[6875] @8167 ------------- flag@8167: 0x3c (KDRHFL, KDRHFF, KDRHFD, KDRHFH) lock@8168: 0x01 cols@8169: 0
故障原因跟踪
有人在数据库中注入了恶意脚本,导致数据库删除了bootstrap$中数据,关闭之后无法正常启动
处理方法
通过oracle bbed 修复数据字典,正常启动数据库
ORA-00702: bootstrap verison ” inconsistent with version ’8.0.0.0.0′
数据库启动报ORA-01092 ORA-00704 ORA-00702错误
使用自研的ORA-702_Recovery Tool小工具可以实现一键恢复,下载地址:ORA-702_Recovery下载
SQL> startup ORACLE instance started. Total System Global Area 3056513024 bytes Fixed Size 2257152 bytes Variable Size 704646912 bytes Database Buffers 2332033024 bytes Redo Buffers 17575936 bytes Database mounted. ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-00702: bootstrap verison '' inconsistent with version '8.0.0.0.0' Process ID: 27344 Session ID: 191 Serial number: 3
查看alert日志
Mon Apr 09 16:22:34 2018 ALTER DATABASE MOUNT Successful mount of redo thread 1, with mount id 1383493834 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Mon Apr 09 16:22:39 2018 ALTER DATABASE OPEN Thread 1 opened at log sequence 3 Current log# 3 seq# 3 mem# 0: /u01/app/oracle/oradata/orcl/redo03.log Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set SMON: enabling cache recovery Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_27344.trc: ORA-00704: bootstrap process failure ORA-00702: bootstrap verison '' inconsistent with version '8.0.0.0.0' Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_27344.trc: ORA-00704: bootstrap process failure ORA-00702: bootstrap verison '' inconsistent with version '8.0.0.0.0' Error 704 happened during db open, shutting down database USER (ospid: 27344): terminating the instance due to error 704 Instance terminated by USER, pid = 27344 ORA-1092 signalled during: ALTER DATABASE OPEN... opiodr aborting process unknown ospid (27344) as a result of ORA-1092 Mon Apr 09 16:22:40 2018 ORA-1092 : opitsk aborting process
错误比较明显是由于数据库open过程中核心基表异常导致,出现此类错误一般是由于软件介质和db不匹配或者字典表的block故障导致.
官方说明
Versions 9.2, 10.1, 10.2, 11.1, 11.2, 12.1 Error: ORA-00702 bootstrap verison '%s' inconsistent with version '%s' --------------------------------------------------------------------------- Cause: The reading version of the boostrap is incompatible with the current bootstrap version. Action: Restore a version of the software that is compatible with this bootstrap version
由于核心基表等相关表处理比较特殊,如果您遭遇此类相关异常无法解决,需要恢复支持,请联系我们
Phone:17813235971 Q Q:107644445 E-Mail:dba@xifenfei.com
数据库不能open 报ORA-7445 lmebucp错
有一个朋友数据库启动报错ORA-03113
SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi PL/SQL Release 10.2.0.5.0 - Production CORE 10.2.0.5.0 Production TNS for Linux: Version 10.2.0.5.0 - Production NLSRTL Version 10.2.0.5.0 - Production SQL> startup ORACLE instance started. Total System Global Area 1610612736 bytes Fixed Size 2096632 bytes Variable Size 385876488 bytes Database Buffers 1207959552 bytes Redo Buffers 14680064 bytes Database mounted. ORA-03113: end-of-file on communication channel
alert日志报ORA-7445 lmebucp()+24错误
Sun Apr 08 08:05:07 CST 2018 ALTER DATABASE MOUNT Sun Apr 08 08:05:11 CST 2018 Setting recovery target incarnation to 2 Sun Apr 08 08:05:11 CST 2018 Successful mount of redo thread 1, with mount id 2650526067 Sun Apr 08 08:05:11 CST 2018 Database mounted in Exclusive Mode Completed: ALTER DATABASE MOUNT Sun Apr 08 08:05:11 CST 2018 ALTER DATABASE OPEN Sun Apr 08 08:05:11 CST 2018 Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/t10g/redo01.log Successful open of redo thread 1 Sun Apr 08 08:05:11 CST 2018 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sun Apr 08 08:05:11 CST 2018 SMON: enabling cache recovery Sun Apr 08 08:05:11 CST 2018 Errors in file /u01/app/oracle/admin/t10g/udump/t10g_ora_32810.trc: ORA-07445: exception encountered: core dump [lmebucp()+24] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
对应trace文件
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0x37e6418, lmebucp()+24] *** 2014-04-08 08:05:11.793 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [lmebucp()+24] [SIGSEGV] [Address not mapped to object] [0x000000000] [] [] Current SQL statement for this session: ALTER DATABASE OPEN ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedst()+31 call ksedst1() 000000000 ? 000000001 ? 7F4238A22BD0 ? 7F4238A22C30 ? 7F4238A22B70 ? 000000000 ? ksedmp()+610 call ksedst() 000000000 ? 000000001 ? 7F4238A22BD0 ? 7F4238A22C30 ? 7F4238A22B70 ? 000000000 ? ssexhd()+629 call ksedmp() 000000003 ? 000000001 ? 7F4238A22BD0 ? 7F4238A22C30 ? 7F4238A22B70 ? 000000000 ? __restore_rt()+0 call ssexhd() 00000000B ? 7F4238A23BF0 ? 7F4238A23AC0 ? 7F4238A22C30 ? 7F4238A22B70 ? 000000000 ? lmebucp()+24 signal __restore_rt() 000000000 ? 000008C00 ? 7FFF0F778790 ? 000000009 ? 000000000 ? 00000000D ? kqlbebs()+1468 call lmebucp() 000000000 ? 000008C00 ? 7FFF0F778790 ? 000000009 ? 000000000 ? 00000000D ? kqlblfc()+172 call kqlbebs() 000000000 ? 0BC119DE0 ? 7FFF0F778790 ? 000000009 ? 000000000 ? 00000000D ? adbdrv()+58009 call kqlblfc() 000000000 ? 7FFF0F77F610 ? 7FFF0F778790 ? 000000009 ? 000000000 ? 00000000D ? opiexe()+13745 call adbdrv() 000000000 ? 7FFF0F77F610 ? 0B9FFF9A8 ? 000000009 ? 000000000 ? 00000000D ? opiosq0()+3398 call opiexe() 000000004 ? 000000000 ? 7FFF0F7807CC ? 000000001 ? 000000000 ? 00000000D ? kpooprx()+318 call opiosq0() 000000003 ? 00000000E ? 7FFF0F780AF8 ? 0000000A4 ? 000000000 ? 600000013 ? kpoal8()+783 call kpooprx() 7FFF0F783CDC ? 7FFF0F781D30 ? 000000013 ? 000000001 ? 000000000 ? 600000013 ? opiodr()+1184 call kpoal8() 00000005E ? 000000017 ? 7FFF0F783CD8 ? 000000001 ? 000000001 ? 600000013 ? ttcpip()+1226 call opiodr() 00000005E ? 000000017 ? 7FFF0F783CD8 ? 000000000 ? 005BEBD70 ? 600000013 ? opitsk()+1310 call ttcpip() 006AF1FB0 ? 0054A6760 ? 7FFF0F783CD8 ? 000000000 ? 7FFF0F7837D8 ? 7FFF0F783E40 ? opiino()+1024 call opitsk() 000000003 ? 000000000 ? 7FFF0F783CD8 ? 000000001 ? 000000000 ? 721000200000001 ? opiodr()+1184 call opiino() 00000003C ? 000000004 ? 7FFF0F784ED8 ? 000000001 ? 000000000 ? 721000200000001 ? opidrv()+548 call opiodr() 00000003C ? 000000004 ? 7FFF0F784ED8 ? 000000000 ? 005BEB820 ? 721000200000001 ? sou2o()+114 call opidrv() 00000003C ? 000000004 ? 7FFF0F784ED8 ? 000000000 ? 005BEB820 ? 721000200000001 ? opimai_real()+163 call sou2o() 7FFF0F784EB0 ? 00000003C ? 000000004 ? 7FFF0F784ED8 ? 005BEB820 ? 721000200000001 ? main()+116 call opimai_real() 000000002 ? 7FFF0F784F40 ? 000000004 ? 7FFF0F784ED8 ? 005BEB820 ? 721000200000001 ? __libc_start_main() call main() 000000002 ? 7FFF0F784F40 ? +244 000000004 ? 7FFF0F784ED8 ? 005BEB820 ? 721000200000001 ? _start()+41 call __libc_start_main() 00072D108 ? 000000002 ? 7FFF0F785098 ? 000000000 ? 005BEB820 ? 000000002 ? --------------------- Binary Stack Dump ---------------------
10046定位语句
SQL> staRTUP MOUNT ORACLE instance started. Total System Global Area 1610612736 bytes Fixed Size 2096632 bytes Variable Size 385876488 bytes Database Buffers 1207959552 bytes Redo Buffers 14680064 bytes Database mounted. SQL> oradebug setmypid Statement processed. SQL> alter session set events '10046 trace name context forever, level 12'; Session altered. SQL> oradebug tracefile_name /u01/app/oracle/admin/t10g/udump/t10g_ora_32908.trc SQL> alter database open; ERROR: ORA-03113: end-of-file on communication channel SQL> PARSING IN CURSOR #2 len=55 dep=1 uid=0 oct=3 lid=0 tim=1463569438249596 hv=2111436465 ad='beb13e10' select line#, sql_text from bootstrap$ where obj# != :1 END OF STMT PARSE #2:c=0,e=471,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1463569438249594 BINDS #2: kkscoacd Bind#0 oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00 oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0 kxsbbbfp=7f8f940fadc0 bln=22 avl=02 flg=05 value=56 EXEC #2:c=2000,e=61246,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1463569438310929 WAIT #2: nam='db file sequential read' ela= 41 file#=1 block#=377 blocks=1 obj#=56 tim=1463569438311099 WAIT #2: nam='db file scattered read' ela= 73 file#=1 block#=378 blocks=3 obj#=56 tim=1463569438311528 FETCH #2:c=1000,e=775,p=4,cr=5,cu=0,mis=0,r=0,dep=1,og=4,tim=1463569438311772 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0x37e6418, lmebucp()+24] *** 2018-04-08 08:11:44.840 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [lmebucp()+24] [SIGSEGV] [Address not mapped to object] [0x000000000] [] [] Current SQL statement for this session: alter database open
通过这里基本上可以定位,报错是由于bootstrap$中对象异常导致。由于该对象比较特殊,使用一些特殊方法进行处理,数据库正常启动成功。如果需要相关技术支持请联系我们,提供专业ORACLE数据库恢复技术支持
Phone:17813235971 Q Q:107644445 E-Mail:dba@xifenfei.com