-
加我微信
加我QQ
标签云
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 修改网卡名称
标签归档：ORA-7445 lmebucp
数据库不能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