标签云
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误删除数据文件恢复
月归档:六月 2018
oracle 18c依旧支持bbed
18c数据库版本
SQL> select BANNER from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
编译18c的bbed
[oracle@localhost soft]$ make -f ./rdbms/lib/ins_rdbms.mk BBED=./bin/bbed ./bin/bbed Linking BBED utility (bbed) rm -f bin/bbed /u02/soft/bin/orald -o bin/bbed -m64 -z noexecstack -Wl,--disable-new-dtags -L/u02/soft/rdbms/lib/ -L/u02/soft/lib/ -L/u02/soft/lib/stubs/ /u02/soft/lib/s0main.o /u02/soft/rdbms/lib/ssbbded.o /u02/soft/rdbms/lib/sbbdpt.o `cat /u02/soft/lib/ldflags` -lncrypt18 -lnsgr18 -lnzjs18 -ln18 -lnl18 -lngsmshd18 -ldbtools18 -lclntsh -lclntshcore `cat /u02/soft/lib/ldflags` -lncrypt18 -lnsgr18 -lnzjs18 -ln18 -lnl18 -lngsmshd18 -lnro18 `cat /u02/soft/lib/ldflags` -lncrypt18 -lnsgr18 -lnzjs18 -ln18 -lnl18 -lngsmshd18 -lnnz18 -lzt18 -lztkg18 -lztkg18 -lclient18 -lnnetd18 -lcommon18 -lgeneric18 -lmm -lsnls18 -lnls18 -lcore18 -lsnls18 -lnls18 -lcore18 -lsnls18 -lnls18 -lxml18 -lcore18 -lunls18 -lsnls18 -lnls18 -lcore18 -lnls18 `cat /u02/soft/lib/ldflags` -lncrypt18 -lnsgr18 -lnzjs18 -ln18 -lnl18 -lngsmshd18 -lnro18 `cat /u02/soft/lib/ldflags` -lncrypt18 -lnsgr18 -lnzjs18 -ln18 -lnl18 -lngsmshd18 -lclient18 -lnnetd18 -lcommon18 -lgeneric18 -lsnls18 -lnls18 -lcore18 -lsnls18 -lnls18 -lcore18 -lsnls18 -lnls18 -lxml18 -lcore18 -lunls18 -lsnls18 -lnls18 -lcore18 -lnls18 -lclient18 -lnnetd18 -lcommon18 -lgeneric18 -lsnls18 -lnls18 -lcore18 -lsnls18 -lnls18 -lcore18 -lsnls18 -lnls18 -lxml18 -lcore18 -lunls18 -lsnls18 -lnls18 -lcore18 -lnls18 `cat /u02/soft/lib/sysliblist` -Wl,-rpath,/u02/soft/lib -lm `cat /u02/soft/lib/sysliblist` -ldl -lm -L/u02/soft/lib
启动bbed
[oracle@localhost soft]$ bbed Password: BBED: Release 2.0.0.0.0 - Limited Production on Fri Jun 15 17:06:28 2018 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. ************* !!! For Oracle Internal Use only !!! *************** BBED> set filename '/u02/app/oracle/oradata/XFFDB/system01.dbf' FILENAME /u02/app/oracle/oradata/XFFDB/system01.dbf BBED> map File: /u02/app/oracle/oradata/XFFDB/system01.dbf (0) Block: 1 Dba:0x00000000 ------------------------------------------------------------ Data File Header struct kcvfh, 1272 bytes @0 ub4 tailchk @8188 BBED> p kcvfh struct kcvfh, 1272 bytes @0 struct kcvfhbfh, 20 bytes @0 ub1 type_kcbh @0 0x0b ub1 frmt_kcbh @1 0xa2 ub2 wrp2_kcbh @2 0x0000 ub4 rdba_kcbh @4 0x00400001 ub4 bas_kcbh @8 0x00000000 ub2 wrp_kcbh @12 0x0000 ub1 seq_kcbh @14 0x01 ub1 flg_kcbh @15 0x04 (KCBHFCKV) ub2 chkval_kcbh @16 0x2df1 ub2 spare3_kcbh @18 0x0000 struct kcvfhhdr, 76 bytes @20 ub4 kccfhswv @20 0x00000000 ub4 kccfhcvn @24 0x12000000<--已经为18c版本(16进制12=10进制18) ub4 kccfhdbi @28 0x386dba85 text kccfhdbn[0] @32 X text kccfhdbn[1] @33 F text kccfhdbn[2] @34 F text kccfhdbn[3] @35 D text kccfhdbn[4] @36 B text kccfhdbn[5] @37 text kccfhdbn[6] @38 text kccfhdbn[7] @39 ub4 kccfhcsq @40 0x000027af ub4 kccfhfsz @44 0x0001ae00 s_blkz kccfhbsz @48 0x00 ub2 kccfhfno @52 0x0001 ub2 kccfhtyp @54 0x0003 ub4 kccfhacid @56 0x00000000 ub4 kccfhcks @60 0x00000000 text kccfhtag[0] @64 text kccfhtag[1] @65 text kccfhtag[2] @66 text kccfhtag[3] @67 text kccfhtag[4] @68 text kccfhtag[5] @69 text kccfhtag[6] @70 text kccfhtag[7] @71 text kccfhtag[8] @72 text kccfhtag[9] @73 text kccfhtag[10] @74 text kccfhtag[11] @75 text kccfhtag[12] @76 text kccfhtag[13] @77 text kccfhtag[14] @78 text kccfhtag[15] @79 text kccfhtag[16] @80 text kccfhtag[17] @81 text kccfhtag[18] @82 text kccfhtag[19] @83 text kccfhtag[20] @84 text kccfhtag[21] @85 text kccfhtag[22] @86 text kccfhtag[23] @87 text kccfhtag[24] @88 text kccfhtag[25] @89 text kccfhtag[26] @90 text kccfhtag[27] @91 text kccfhtag[28] @92 text kccfhtag[29] @93 text kccfhtag[30] @94 text kccfhtag[31] @95 ub4 kcvfhrdb @96 0x00400208 struct kcvfhcrs, 8 bytes @100 ub4 kscnbas @100 0x00000007 ub2 kscnwrp @104 0x8000 ub2 kscnwrp2 @106 0x0000 ub4 kcvfhcrt @108 0x39aaed07 ub4 kcvfhrlc @112 0x39c5e108 struct kcvfhrls, 8 bytes @116 ub4 kscnbas @116 0x0016ac11 ub2 kscnwrp @120 0x8000 ub2 kscnwrp2 @122 0x0000 ub4 kcvfhbti @124 0x00000000 struct kcvfhbsc, 8 bytes @128 ub4 kscnbas @128 0x00000000 ub2 kscnwrp @132 0x0000 ub2 kscnwrp2 @134 0x0000 ub2 kcvfhbth @136 0x0000 ub2 kcvfhsta @138 0x2004 (KCVFHOFZ) struct kcvfhckp, 36 bytes @484 struct kcvcpscn, 8 bytes @484 ub4 kscnbas @484 0x001cb769 ub2 kscnwrp @488 0x8000 ub2 kscnwrp2 @490 0x0000 ub4 kcvcptim @492 0x3a585ab6 ub2 kcvcpthr @496 0x0001 union u, 12 bytes @500 struct kcvcprba, 12 bytes @500 ub4 kcrbaseq @500 0x00000007 ub4 kcrbabno @504 0x0000fce3 ub2 kcrbabof @508 0x0010 ub1 kcvcpetb[0] @512 0x02 ub1 kcvcpetb[1] @513 0x00 ub1 kcvcpetb[2] @514 0x00 ub1 kcvcpetb[3] @515 0x00 ub1 kcvcpetb[4] @516 0x00 ub1 kcvcpetb[5] @517 0x00 ub1 kcvcpetb[6] @518 0x00 ub1 kcvcpetb[7] @519 0x00 ub4 kcvfhcpc @140 0x0000003c ub4 kcvfhrts @144 0x3a5859f0 ub4 kcvfhccc @148 0x0000003b struct kcvfhbcp, 36 bytes @152 struct kcvcpscn, 8 bytes @152 ub4 kscnbas @152 0x00000000 ub2 kscnwrp @156 0x0000 ub2 kscnwrp2 @158 0x0000 ub4 kcvcptim @160 0x00000000 ub2 kcvcpthr @164 0x0000 union u, 12 bytes @168 struct kcvcprba, 12 bytes @168 ub4 kcrbaseq @168 0x00000000 ub4 kcrbabno @172 0x00000000 ub2 kcrbabof @176 0x0000 ub1 kcvcpetb[0] @180 0x00 ub1 kcvcpetb[1] @181 0x00 ub1 kcvcpetb[2] @182 0x00 ub1 kcvcpetb[3] @183 0x00 ub1 kcvcpetb[4] @184 0x00 ub1 kcvcpetb[5] @185 0x00 ub1 kcvcpetb[6] @186 0x00 ub1 kcvcpetb[7] @187 0x00 ub4 kcvfhbhz @312 0x00000000 struct kcvfhxcd, 16 bytes @316 ub4 space_kcvmxcd[0] @316 0x00000000 ub4 space_kcvmxcd[1] @320 0x00000000 ub4 space_kcvmxcd[2] @324 0x00000000 ub4 space_kcvmxcd[3] @328 0x00000000 sword kcvfhtsn @332 0 ub2 kcvfhtln @336 0x0006 text kcvfhtnm[0] @338 S text kcvfhtnm[1] @339 Y text kcvfhtnm[2] @340 S text kcvfhtnm[3] @341 T text kcvfhtnm[4] @342 E text kcvfhtnm[5] @343 M text kcvfhtnm[6] @344 text kcvfhtnm[7] @345 text kcvfhtnm[8] @346 text kcvfhtnm[9] @347 text kcvfhtnm[10] @348 text kcvfhtnm[11] @349 text kcvfhtnm[12] @350 text kcvfhtnm[13] @351 text kcvfhtnm[14] @352 text kcvfhtnm[15] @353 text kcvfhtnm[16] @354 text kcvfhtnm[17] @355 text kcvfhtnm[18] @356 text kcvfhtnm[19] @357 text kcvfhtnm[20] @358 text kcvfhtnm[21] @359 text kcvfhtnm[22] @360 text kcvfhtnm[23] @361 text kcvfhtnm[24] @362 text kcvfhtnm[25] @363 text kcvfhtnm[26] @364 text kcvfhtnm[27] @365 text kcvfhtnm[28] @366 text kcvfhtnm[29] @367 ub4 kcvfhrfn @368 0x00000001 struct kcvfhrfs, 8 bytes @372 ub4 kscnbas @372 0x00000000 ub2 kscnwrp @376 0x0000 ub2 kscnwrp2 @378 0x0000 ub4 kcvfhrft @380 0x00000000 struct kcvfhafs, 8 bytes @384 ub4 kscnbas @384 0x00000000 ub2 kscnwrp @388 0x0000 ub2 kscnwrp2 @390 0x0000 ub4 kcvfhbbc @392 0x00000000 ub4 kcvfhncb @396 0x00000000 ub4 kcvfhmcb @400 0x00000000 ub4 kcvfhlcb @404 0x00000000 ub4 kcvfhbcs @408 0x00000000 ub2 kcvfhofb @412 0x000a ub2 kcvfhnfb @414 0x000a ub4 kcvfhprc @416 0x39aaecfc struct kcvfhprs, 8 bytes @420 ub4 kscnbas @420 0x00000001 ub2 kscnwrp @424 0x0000 ub2 kscnwrp2 @426 0x0000 struct kcvfhprfs, 8 bytes @428 ub4 kscnbas @428 0x00000000 ub2 kscnwrp @432 0x0000 ub2 kscnwrp2 @434 0x0000 ub4 kcvfhtrt @444 0x00000000 BBED>
这里证明bbed依旧能够在Oracle 18c的数据库版本中工作,oracle 12.2依旧支持bbed
Oracle dul支持18c
在以前的文章中已经写过oracle 原厂dul工具可以很好的支持oracle 11g,12c(Oracle dul支持Oracle 12.2(12c),dul 10支持oracle 11g r2),现在确认通过一些处理,dul也可以完美支持oracle 18c
数据库版本18c
[oracle@localhost dul]$ sqlplus / as sysdba SQL*Plus: Release 18.0.0.0.0 Production on Fri Jun 15 14:23:00 2018 Version 18.1.0.0.0 Copyright (c) 1982, 2017, Oracle. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.1.0.0.0 SQL> select BANNER from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production SQL> select name from v$datafile; NAME ------------------------------------------------------------- /u02/app/oracle/oradata/XFFDB/system01.dbf /u02/app/oracle/oradata/XFFDB/sysaux01.dbf /u02/app/oracle/oradata/XFFDB/undotbs01.dbf /u02/app/oracle/oradata/XFFDB/users01.dbf SQL> create table t_xifenfei as select * from dba_objects; Table created. SQL> alter system checkpoint; System altered. SQL> select count(*) from sys.t_xifenfei; COUNT(*) ------------------------------------------------------------- 72870
dul加载18c字典失败
DUL: FATAL Error: File OBJ.dat和DUL: Error: string2ub8错误导致obj和TAB字典加载失败
[oracle@localhost dul]$ ./dul Data UnLoader: 11.2.0.6.1 - Internal Only - on Fri Jun 15 12:04:17 2018 with 64-bit io functions and the decompression option Copyright (c) 1994 2017 Bernard van Duijnen All rights reserved. Strictly Oracle Internal Use Only DUL: Warning: ulimit process stack size is only 33554432 Found db_id = 946715269 Found db_name = XFFDB DUL> show datafiles; ts# rf# start blocks offs open err file name 0 1 0 110081 0 1 0 /u02/app/oracle/oradata/XFFDB/system01.dbf 1 3 0 79361 0 1 0 /u02/app/oracle/oradata/XFFDB/sysaux01.dbf 2 4 0 7681 0 1 0 /u02/app/oracle/oradata/XFFDB/undotbs01.dbf 4 7 0 641 0 1 0 /u02/app/oracle/oradata/XFFDB/users01.dbf DUL> bootstrap; Probing file = 1, block = 520 . unloading table BOOTSTRAP$ DUL: Warning: block number is non zero but marked deferred trying to process it anyhow 60 rows unloaded Reading BOOTSTRAP.dat 60 entries loaded Parsing Bootstrap$ contents Generating dict.ddl for version 11 OBJ$: segobjno 18, file 1 block 240 TAB$: segobjno 2, tabno 1, file 1 block 144 COL$: segobjno 2, tabno 5, file 1 block 144 USER$: segobjno 10, tabno 1, file 1 block 208 Running generated file "@dict.ddl" to unload the dictionary tables . unloading table OBJ$ 72872 rows unloaded . unloading table TAB$ 2173 rows unloaded . unloading table COL$ 120489 rows unloaded . unloading table USER$ 123 rows unloaded Reading USER.dat 123 entries loaded Reading OBJ.dat DUL: FATAL Error: File OBJ.dat, line 20174: identifier too long [oracle@localhost dul]$ ./dul Data UnLoader: 11.2.0.6.1 - Internal Only - on Fri Jun 15 13:46:51 2018 with 64-bit io functions and the decompression option Copyright (c) 1994 2017 Bernard van Duijnen All rights reserved. Strictly Oracle Internal Use Only DUL: Warning: Recreating file "dul.log" DUL: Warning: ulimit process stack size is only 33554432 Reading USER.dat 123 entries loaded Reading OBJ.dat 35926 entries loaded and sorted 35926 entries Reading TAB.dat DUL: Error: string2ub8(618970019642690137449563136), Conversion to number (ub8) overflowed DUL: Error: Number conversion error in file TAB.dat, line 22 DUL: Warning: Ignoring file TAB.dat cache Reading COL.dat DUL: Notice: Increased the size of DC_COLUMNS from 100000 to 132768 entries 120489 entries loaded and sorted 120489 entries Reading BOOTSTRAP.dat 60 entries loaded Found db_id = 946715269 Found db_name = XFFDB
通过dul修复字典之后
[oracle@localhost dul]$ ./dul Data UnLoader: 11.2.0.6.1 - Internal Only - on Fri Jun 15 14:12:52 2018 with 64-bit io functions and the decompression option Copyright (c) 1994 2017 Bernard van Duijnen All rights reserved. Strictly Oracle Internal Use Only DUL: Warning: Recreating file "dul.log" DUL: Warning: ulimit process stack size is only 33554432 Reading USER.dat 123 entries loaded Reading OBJ.dat 35926 entries loaded and sorted 35926 entries Reading TAB.dat 2155 entries loaded Reading COL.dat DUL: Notice: Increased the size of DC_COLUMNS from 100000 to 132768 entries 120489 entries loaded and sorted 120489 entries Reading TABPART.dat 299 entries loaded and sorted 299 entries Reading TABCOMPART.dat 1 entries loaded and sorted 1 entries Reading TABSUBPART.dat 32 entries loaded and sorted 32 entries Reading INDPART.dat 216 entries loaded and sorted 216 entries Reading INDCOMPART.dat 0 entries loaded and sorted 0 entries Reading INDSUBPART.dat 0 entries loaded and sorted 0 entries Reading IND.dat 2845 entries loaded Reading LOB.dat 665 entries loaded Reading ICOL.dat 4911 entries loaded Reading COLTYPE.dat 2971 entries loaded Reading TYPE.dat 4031 entries loaded Reading ATTRIBUTE.dat 15856 entries loaded Reading COLLECTION.dat DUL: Notice: Increased the size of DC_COLLECTIONS from 1024 to 8192 entries 1454 entries loaded Reading BOOTSTRAP.dat 60 entries loaded Reading LOBFRAG.dat 18 entries loaded and sorted 18 entries Reading LOBCOMPPART.dat 0 entries loaded and sorted 0 entries Reading UNDO.dat 21 entries loaded Reading TS.dat 6 entries loaded Reading PROPS.dat 42 entries loaded Database character set is AL32UTF8 Database national character set is AL16UTF16 Found db_id = 946715269 Found db_name = XFFDB DUL> unload table sys.t_xifenfei; . unloading table T_XIFENFEI 72870 rows unloaded DUL>
由此可以看出来dul,可以比较好的支持oracle 18c数据库
发表在 ORACLE 18C, Oracle备份恢复
标签为 dul 18c, dul 恢复, DUL: Error: string2ub8, DUL: FATAL Error: File OBJ.dat, oracle dul
评论关闭
12.2 standby 报ORA-01110
12.2备库报错
2018-06-13T19:29:00.302767+08:00 Errors in file /u01/app/oracle/diag/rdbms/xifenfeidg/xifenfei/trace/xifenfei_m000_2457.trc: ORA-01110: data file 1: '/u01/app/oracle/oradata/xifenfei/system01.dbf' 2018-06-13T19:29:00.829861+08:00 Errors in file /u01/app/oracle/diag/rdbms/xifenfeidg/xifenfei/trace/xifenfei_m000_2457.trc: ORA-01110: data file 2: '/u01/app/oracle/oradata/xifenfei/rich101.dbf' 2018-06-13T19:29:00.930632+08:00 Errors in file /u01/app/oracle/diag/rdbms/xifenfeidg/xifenfei/trace/xifenfei_m000_2457.trc: ORA-01110: data file 3: '/u01/app/oracle/oradata/xifenfei/sysaux01.dbf' 2018-06-13T19:29:01.010230+08:00 Errors in file /u01/app/oracle/diag/rdbms/xifenfeidg/xifenfei/trace/xifenfei_m000_2457.trc: ORA-01110: data file 4: '/u01/app/oracle/oradata/xifenfei/undotbs01.dbf' 2018-06-13T11:29:01.055975+00:00 Archived Log entry 5072 added for T-1.S-5020 ID 0x6a8e9d72 LAD:1 RFS[18]: Selected log 10 for T-1.S-5024 dbid 1787743346 branch 957530932 2018-06-13T19:29:01.091059+08:00 Errors in file /u01/app/oracle/diag/rdbms/xifenfeidg/xifenfei/trace/xifenfei_m000_2457.trc: ORA-01110: data file 5: '/u01/app/oracle/oradata/xifenfei/richman01.dbf' 2018-06-13T19:29:01.172613+08:00 Errors in file /u01/app/oracle/diag/rdbms/xifenfeidg/xifenfei/trace/xifenfei_m000_2457.trc: ORA-01110: data file 7: '/u01/app/oracle/oradata/xifenfei/users01.dbf' 2018-06-13T19:29:01.251906+08:00 Errors in file /u01/app/oracle/diag/rdbms/xifenfeidg/xifenfei/trace/xifenfei_m000_2457.trc: ORA-01110: data file 8: '/u01/app/oracle/oradata/xifenfei/r_index01.dbf'
trace文件
*** 2018-06-13T19:29:00.282836+08:00 *** SESSION ID:(2281.15120) 2018-06-13T19:29:00.282868+08:00 *** CLIENT ID:() 2018-06-13T19:29:00.282873+08:00 *** SERVICE NAME:(SYS$BACKGROUND) 2018-06-13T19:29:00.282878+08:00 *** MODULE NAME:(MMON_SLAVE) 2018-06-13T19:29:00.282883+08:00 *** ACTION NAME:(DDE async action) 2018-06-13T19:29:00.282888+08:00 *** CLIENT DRIVER:() 2018-06-13T19:29:00.282892+08:00 ========= Dump for error ORA 312 (no incident) ======== ----- DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) ----- dbkh_reactive_run_check: BEGIN dbkh_reactive_run_check:; incident_id=0 dbkh_run_check_internal: BEGIN; check_namep=DB Structure Integrity Check, run_namep=<null> dbkh_run_check_internal: BEGIN; timeout=0 dbkh_run_check_internal: AFTER RUN CREATE; run_id=1841 *** 2018-06-13T19:29:00.302510+08:00 DDE previous invocation failed before phase II DDE was called in a 'No Invocation Mode' ----- Start Diag Diagnostic Dump ----- Diagnostic dump is performed due to an error in the diagfw code during error handling. Dump error and call stack for the diagnostic dump: *** 2018-06-13T19:29:00.302576+08:00 dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=1, mask=0x0) ----- Error Stack Dump ----- ORA-01110: data file 1: '/u01/app/oracle/oradata/xifenfei/system01.dbf' ----- SQL Statement (None) ----- Current SQL information unavailable - no cursor. ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedst()+119 call kgdsdst() 7FFF1A0D6C68 000000002 7FFF1A0B86D0 ? 7FFF1A0B87E8 ? 000000000 000000082 ? dbkedDefDump()+1200 call ksedst() 000000000 000000002 ? 7FFF1A0B86D0 ? 7FFF1A0B87E8 ? 000000000 ? 000000082 ? ksedmp()+259 call dbkedDefDump() 000000001 000000000 7FFF1A0B86D0 ? 7FFF1A0B87E8 ? 000000000 ? 000000082 ? dbgexExecuteIntDiag call ksedmp() 000000001 000000000 ? Dmp()+1457 7FFF1A0B86D0 ? 7FFF1A0B87E8 ? 000000000 ? 000000082 ? dbgeBeginInvoke()+3 call dbgexExecuteIntDiag 7F5A00000003 7F5A99B856C0 59 Dmp() 7FFF1A0B86D0 ? 7FFF1A0B87E8 ? 000000000 ? 000000082 ? dbgePostErrorKGE()+ call dbgeBeginInvoke() 7F5A99B856C0 7FFF1A0D7D20 1676 7FFF1A0B86D0 ? 7FFF1A0B87E8 ? 000000000 ? 000000082 ? dbkePostKGE_kgsf()+ call dbgePostErrorKGE() 7F5A99BC59A0 7F5A99AA0048 90 000000456 7FFF1A0B87E8 ? 000000000 ? 000000082 ? kgeade()+432 call dbkePostKGE_kgsf() 7F5A99BC59A0 7F5A99AA0048 000000456 7FFF1A0B87E8 ? 000000000 ? 000000082 ? kgerelv()+144 call kgeade() 7F5A99BC59A0 ? 7F5A99BC5BE8 ? 7F5A99AA0048 ? 000000456 ? 000000000 000000000 kgerev()+36 call kgerelv() 7F5A99BC59A0 ? 7F5A99AA0048 ? 7F5A99AA0048 ? 000000456 ? 012E79CF4 ? 000000002 ? kserec2()+185 call kgerev() 7F5A99BC59A0 ? 7F5A99AA0048 ? 7F5A99AA0048 ? 000000456 ? 7FFF1A0D8000 000000002 ? kcf_record_fn()+634 call kserec2() 7F5A99BC59A0 ? 000000000 000000001 000000001 00000002C 141E0C518 kcvvra_dfh()+5278 call kcf_record_fn() 000000001 151622BB8 000000000 7FFF1A0DA5D8 00000002C ? 141E0C518 ? kcidr_file_header_c call kcvvra_dfh() 7FFF1A0DA460 ? 7FFF1A0D9FE8 ? heck_common()+4669 000000000 ? 7FFF1A0D9398 7F5A94379000 ? 000000001 ? kcidr_file_header_a call kcidr_file_header_c 7F5A99A9F7A0 7F5A94379000 ll_check_common()+2 heck_common() 000000001 000000000 259 7F5A94379000 ? 000000000 kcidr_cross_check() call kcidr_file_header_a 7F5A99A9F7A0 7FFF1A0DABE4 +566 ll_check_common() 000000001 ? 000000000 ? 7F5A94379000 ? 000000000 ? dbkird_cross_check( call kcidr_cross_check() 7F5A99A9F7A0 7FFF1A0DABE4 ? )+557 7F5A99BC5BE8 000000000 ? 7F5A94379000 ? 000000000 ? dbkh_run_check_inte call dbkird_cross_check( 7F5A99A9F7A0 7FFF1A0DABE4 ? rnal()+2228 ) 7F5A99BC5BE8 ? 000000000 ? 7F5A94379000 ? 000000000 ? dbkh_reactive_run_c call dbkh_run_check_inte 7FFF1A0DB970 000000000 heck()+3011 rnal() 000000002 000000000 000000000 000000000 dbgdaAsyncReceive() call dbkh_reactive_run_c 7F5A99B856C0 7FFF1A0DBC90 +279 heck() 000000002 ? 000000000 ? 000000000 ? 000000000 ? dbgea_exec_()+1739 call dbgdaAsyncReceive() 7F5A99B856C0 0020C0029 7FFF1A0E7CA0 7FFF1A0E7D20 000000002 000000000 ? dbgea_exec()+621 call dbgea_exec_() 7F5A99B856C0 7F5A94984D18 0000000E8 000000000 000000002 ? 000000000 ? dbkea_exec()+1718 call dbgea_exec() 7F5A99B856C0 7F5A94984D18 0000000E8 000000000 000000002 ? 000000000 ? dbkea_slave_exec()+ call dbkea_exec() 7F5A99B856C0 ? 7F5A94984D18 ? 518 0000000E8 ? 000000000 ? 000000002 ? 000000000 ? kebm_slave_cb()+64 call dbkea_slave_exec() 1453D7248 7F5A94984D18 ? 0000000E8 ? 000000000 ? 000000002 ? 000000000 ? kebm_slave_main()+7 call kebm_slave_cb() 1453D7248 ? 7F5A94984D18 ? 72 0000000E8 ? 000000000 ? 000000002 ? 000000000 ? ksvrdp_int()+2010 call kebm_slave_main() 1453D7248 ? 1453D7248 0000000E8 ? 000000000 ? 000000002 ? 000000000 ? opirip()+602 call ksvrdp_int() 000000000 ? 000000000 ? 0000000E8 ? 000000000 ? 000000002 ? 000000000 ? opidrv()+602 call opirip() 000000032 000000004 7FFF1A0EAD98 000000000 ? 000000002 ? 000000000 ? sou2o()+145 call opidrv() 000000032 000000004 7FFF1A0EAD98 000000000 ? 000000002 ? 000000000 ? opimai_real()+202 call sou2o() 7FFF1A0EAD70 000000032 000000004 7FFF1A0EAD98 000000002 ? 000000000 ? ssthrdmain()+417 call opimai_real() 000000000 7FFF1A0EB080 000000004 ? 7FFF1A0EAD98 ? 000000002 ? 000000000 ? main()+262 call ssthrdmain() 000000000 000000003 7FFF1A0EB080 000000001 000000000 000000000 ? __libc_start_main() call main() 000000000 7FFF1A0EB2B8 +245 7FFF1A0EB080 ? 000000001 ? 000000000 ? 000000000 ? _start()+41 call __libc_start_main() 000D05240 000000001 7FFF1A0EB2B8 7F5A95015C05 ? 000000000 ? 000000000 ? --------------------- Binary Stack Dump ---------------------
BUG:24844841 – PHSB:CDB M000 REPORTED ORA-1110 ON ADG WHEN A DATAFILE IS ADDED ON PRIMARY
@ The M000 messages is a false alarm as well. It is a false alarm by DRA check
@ that doesn’t consider standby media recovery properly. Adding a file happens
@ to trigger the timing for the false alarm.
@ One way to fix this is to skip file header check if standby recovery is
@ running inside kcidr_file_header_all_check_common.
M000进程检查数据库文件头信息,由于bug原因报ORA-01110错误.
处理建议
1.打上补丁24844841
2.19.1版本修复该问题
3.重启备库,启动mgr
4.暂时忽略该问题(目前没有发现影响数据库同步)
参考:ORA-01110 For All Files In Standby Database (Doc ID 2322290.1)