标签云
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默认服务配置优先节点
标签归档:dul 19c
dul 12.2完美支持Oracle 19c恢复
Oracle dul 12.2完美支持12c+版本(实测19c恢复正常)
[root@ora11g dul]# ./dul Data UnLoader: 12.2.0.0.0 Beta - Internal Only - on Wed Nov 11 00:00:39 2020 with 64-bit io functions and the decompression option Copyright (c) 1994 2019 Bernard van Duijnen All rights reserved. Strictly Oracle Internal Use Only Found db_id = 2193655303 Found db_name = UORA19C 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 DUL: Warning: Recreating file "dict.ddl" Generating dict.ddl for version 12 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$ 72485 rows unloaded . unloading table TAB$ 2243 rows unloaded . unloading table COL$ 123798 rows unloaded . unloading table USER$ 127 rows unloaded Reading USER.dat 127 entries loaded Reading OBJ.dat 72485 entries loaded and sorted 72485 entries Reading TAB.dat 2243 entries loaded Reading COL.dat 123798 entries loaded and sorted 123798 entries Reading BOOTSTRAP.dat 60 entries loaded DUL: Warning: Recreating file "dict.ddl" Generating dict.ddl for version 12 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 TABPART$: segobjno 814, file 1 block 5424 INDPART$: segobjno 819, file 1 block 5464 TABCOMPART$: segobjno 836, file 1 block 5600 INDCOMPART$: segobjno 841, file 1 block 5640 TABSUBPART$: segobjno 826, file 1 block 5520 INDSUBPART$: segobjno 831, file 1 block 5560 IND$: segobjno 2, tabno 3, file 1 block 144 ICOL$: segobjno 2, tabno 4, file 1 block 144 LOB$: segobjno 2, tabno 6, file 1 block 144 COLTYPE$: segobjno 2, tabno 7, file 1 block 144 TYPE$: segobjno 740, tabno 1, file 1 block 4880 COLLECTION$: segobjno 740, tabno 2, file 1 block 4880 ATTRIBUTE$: segobjno 740, tabno 3, file 1 block 4880 LOBFRAG$: segobjno 847, file 1 block 5688 LOBCOMPPART$: segobjno 850, file 1 block 5720 UNDO$: segobjno 15, file 1 block 224 TS$: segobjno 6, tabno 2, file 1 block 176 PROPS$: segobjno 127, file 1 block 1320 Running generated file "@dict.ddl" to unload the dictionary tables . unloading table OBJ$ DUL: Warning: Recreating file "OBJ.ctl" 72485 rows unloaded . unloading table TAB$ DUL: Warning: Recreating file "TAB.ctl" 2243 rows unloaded . unloading table COL$ DUL: Warning: Recreating file "COL.ctl" 123798 rows unloaded . unloading table USER$ DUL: Warning: Recreating file "USER.ctl" 127 rows unloaded . unloading table TABPART$ 304 rows unloaded . unloading table INDPART$ 204 rows unloaded . unloading table TABCOMPART$ 1 row unloaded . unloading table INDCOMPART$ 0 rows unloaded . unloading table TABSUBPART$ 32 rows unloaded . unloading table INDSUBPART$ 0 rows unloaded . unloading table IND$ 2922 rows unloaded . unloading table ICOL$ 4996 rows unloaded . unloading table LOB$ 702 rows unloaded . unloading table COLTYPE$ 3035 rows unloaded . unloading table TYPE$ 5889 rows unloaded . unloading table COLLECTION$ 1385 rows unloaded . unloading table ATTRIBUTE$ 15376 rows unloaded . unloading table LOBFRAG$ 15 rows unloaded . unloading table LOBCOMPPART$ 0 rows unloaded . unloading table UNDO$ 21 rows unloaded . unloading table TS$ 21 rows unloaded . unloading table PROPS$ 42 rows unloaded Reading USER.dat 127 entries loaded Reading OBJ.dat 72485 entries loaded and sorted 72485 entries Reading TAB.dat 2243 entries loaded Reading COL.dat 123798 entries loaded and sorted 123798 entries Reading TABPART.dat 304 entries loaded and sorted 304 entries Reading TABCOMPART.dat 1 entries loaded and sorted 1 entries Reading TABSUBPART.dat 32 entries loaded and sorted 32 entries Reading INDPART.dat 204 entries loaded and sorted 204 entries Reading INDCOMPART.dat 0 entries loaded and sorted 0 entries Reading INDSUBPART.dat 0 entries loaded and sorted 0 entries Reading IND.dat 2922 entries loaded Reading LOB.dat 702 entries loaded Reading ICOL.dat 4996 entries loaded Reading COLTYPE.dat 3035 entries loaded Reading TYPE.dat DUL: Notice: Increased the size of DC_TYPES from 4096 to 32768 entries 5889 entries loaded Reading ATTRIBUTE.dat 15376 entries loaded Reading COLLECTION.dat DUL: Notice: Increased the size of DC_COLLECTIONS from 1024 to 8192 entries 1385 entries loaded Reading BOOTSTRAP.dat 60 entries loaded Reading LOBFRAG.dat 15 entries loaded and sorted 15 entries Reading LOBCOMPPART.dat 0 entries loaded and sorted 0 entries Reading UNDO.dat 21 entries loaded Reading TS.dat 21 entries loaded Reading PROPS.dat 42 entries loaded Database character set is AL32UTF8 Database national character set is AL16UTF16
实际测试一张表恢复
DUL> unload table sys.props$; . unloading table PROPS$ DUL: Warning: Recreating file "SYS_PROPS.ctl" 42 rows unloaded
dul支持Oracle 19C
Oracle 19C
[oracle@localhost ~]$ ss SQL*Plus: Release 19.0.0.0.0 - Production on Sat Mar 2 07:02:18 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.2.0.0.0 SQL> select name from v$datafile where rownum<3; NAME -------------------------------------------------------------------------------- /u01/app/oracle/oradata/ORA19C/system01.dbf /u01/app/oracle/oradata/ORA19C/sysaux01.dbf
dul支持19C
[root@localhost dul]# ./dul Data UnLoader: 11.3.0.0.2 - Internal Only - on Sat Mar 2 08:26:11 2019 with 64-bit io functions and the decompression option Copyright (c) 1994 2018 Bernard van Duijnen All rights reserved. Strictly Oracle Internal Use Only DUL: Warning: Recreating file "dul.log" Found db_id = 1054612630 Found db_name = ORA19C DUL> bootstrap; DUL: Warning: Recreating file "dict.ddl" Generating dict.ddl for version 12 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 TABPART$: segobjno 814, file 1 block 5424 INDPART$: segobjno 819, file 1 block 5464 TABCOMPART$: segobjno 836, file 1 block 5600 INDCOMPART$: segobjno 841, file 1 block 5640 TABSUBPART$: segobjno 826, file 1 block 5520 INDSUBPART$: segobjno 831, file 1 block 5560 IND$: segobjno 2, tabno 3, file 1 block 144 ICOL$: segobjno 2, tabno 4, file 1 block 144 LOB$: segobjno 2, tabno 6, file 1 block 144 COLTYPE$: segobjno 2, tabno 7, file 1 block 144 TYPE$: segobjno 740, tabno 1, file 1 block 4888 COLLECTION$: segobjno 740, tabno 2, file 1 block 4888 ATTRIBUTE$: segobjno 740, tabno 3, file 1 block 4888 LOBFRAG$: segobjno 847, file 1 block 5688 LOBCOMPPART$: segobjno 850, file 1 block 5720 UNDO$: segobjno 15, file 1 block 224 TS$: segobjno 6, tabno 2, file 1 block 176 PROPS$: segobjno 127, file 1 block 1320 Running generated file "@dict.ddl" to unload the dictionary tables . unloading table OBJ$ DUL: Warning: Recreating file "OBJ.ctl" 72388 rows unloaded . unloading table TAB$ DUL: Warning: Recreating file "TAB.ctl" 2218 rows unloaded . unloading table COL$ DUL: Warning: Recreating file "COL.ctl" 123175 rows unloaded . unloading table USER$ DUL: Warning: Recreating file "USER.ctl" 127 rows unloaded . unloading table TABPART$ DUL: Warning: Recreating file "TABPART.ctl" 294 rows unloaded . unloading table INDPART$ DUL: Warning: Recreating file "INDPART.ctl" 195 rows unloaded . unloading table TABCOMPART$ DUL: Warning: Recreating file "TABCOMPART.ctl" 1 row unloaded . unloading table INDCOMPART$ DUL: Warning: Recreating file "INDCOMPART.ctl" 0 rows unloaded . unloading table TABSUBPART$ DUL: Warning: Recreating file "TABSUBPART.ctl" 32 rows unloaded . unloading table INDSUBPART$ DUL: Warning: Recreating file "INDSUBPART.ctl" 0 rows unloaded . unloading table IND$ DUL: Warning: Recreating file "IND.ctl" 2878 rows unloaded . unloading table ICOL$ DUL: Warning: Recreating file "ICOL.ctl" 4958 rows unloaded . unloading table LOB$ DUL: Warning: Recreating file "LOB.ctl" 678 rows unloaded . unloading table COLTYPE$ DUL: Warning: Recreating file "COLTYPE.ctl" 2999 rows unloaded . unloading table TYPE$ DUL: Warning: Recreating file "TYPE.ctl" 5895 rows unloaded . unloading table COLLECTION$ DUL: Warning: Recreating file "COLLECTION.ctl" 1384 rows unloaded . unloading table ATTRIBUTE$ DUL: Warning: Recreating file "ATTRIBUTE.ctl" 15365 rows unloaded . unloading table LOBFRAG$ DUL: Warning: Recreating file "LOBFRAG.ctl" 14 rows unloaded . unloading table LOBCOMPPART$ DUL: Warning: Recreating file "LOBCOMPPART.ctl" 0 rows unloaded . unloading table UNDO$ DUL: Warning: Recreating file "UNDO.ctl" 21 rows unloaded . unloading table TS$ DUL: Warning: Recreating file "TS.ctl" 6 rows unloaded . unloading table PROPS$ DUL: Warning: Recreating file "PROPS.ctl" 42 rows unloaded Reading USER.dat 127 entries loaded Reading OBJ.dat 72388 entries loaded and sorted 72388 entries Reading TAB.dat 2201 entries loaded Reading COL.dat DUL: Notice: Increased the size of DC_COLUMNS from 100000 to 132768 entries 123148 entries loaded and sorted 123148 entries Reading TABPART.dat 294 entries loaded and sorted 294 entries Reading TABCOMPART.dat 1 entries loaded and sorted 1 entries Reading TABSUBPART.dat 32 entries loaded and sorted 32 entries Reading INDPART.dat 195 entries loaded and sorted 195 entries Reading INDCOMPART.dat 0 entries loaded and sorted 0 entries Reading INDSUBPART.dat 0 entries loaded and sorted 0 entries Reading IND.dat 2878 entries loaded Reading LOB.dat 678 entries loaded Reading ICOL.dat 4958 entries loaded Reading COLTYPE.dat 2999 entries loaded Reading TYPE.dat 5895 entries loaded Reading ATTRIBUTE.dat 15365 entries loaded Reading COLLECTION.dat 1384 entries loaded Reading BOOTSTRAP.dat 60 entries loaded Reading LOBFRAG.dat 14 entries loaded and sorted 14 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 DUL> desc sys.tab$; Table SYS.TAB$ obj#= 4, dataobj#= 2, ts#= 0, file#= 1, block#=144 tab#= 1, segcols= 45, clucols= 1 Column information: icol# 01 segcol# 01 OBJ# len 22 type 2 NUMBER(0) icol# 02 segcol# 02 DATAOBJ# len 22 type 2 NUMBER(0) icol# 03 segcol# 03 TS# len 22 type 2 NUMBER(0) icol# 04 segcol# 04 FILE# len 22 type 2 NUMBER(0) icol# 05 segcol# 05 BLOCK# len 22 type 2 NUMBER(0) icol# 06 segcol# 06 BOBJ# len 22 type 2 NUMBER(0) icol# 07 segcol# 07 TAB# len 22 type 2 NUMBER(0) icol# 08 segcol# 08 COLS len 22 type 2 NUMBER(0) icol# 09 segcol# 09 CLUCOLS len 22 type 2 NUMBER(0) icol# 10 segcol# 10 PCTFREE$ len 22 type 2 NUMBER(0) icol# 11 segcol# 11 PCTUSED$ len 22 type 2 NUMBER(0) icol# 12 segcol# 12 INITRANS len 22 type 2 NUMBER(0) icol# 13 segcol# 13 MAXTRANS len 22 type 2 NUMBER(0) icol# 14 segcol# 14 FLAGS len 22 type 2 NUMBER(0) icol# 15 segcol# 15 AUDIT$ len 38 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 16 segcol# 16 ROWCNT len 22 type 2 NUMBER(0) icol# 17 segcol# 17 BLKCNT len 22 type 2 NUMBER(0) icol# 18 segcol# 18 EMPCNT len 22 type 2 NUMBER(0) icol# 19 segcol# 19 AVGSPC len 22 type 2 NUMBER(0) icol# 20 segcol# 20 CHNCNT len 22 type 2 NUMBER(0) icol# 21 segcol# 21 AVGRLN len 22 type 2 NUMBER(0) icol# 22 segcol# 22 AVGSPC_FLB len 22 type 2 NUMBER(0) icol# 23 segcol# 23 FLBCNT len 22 type 2 NUMBER(0) icol# 24 segcol# 24 ANALYZETIME len 7 type 12 DATE icol# 25 segcol# 25 SAMPLESIZE len 22 type 2 NUMBER(0) icol# 26 segcol# 26 DEGREE len 22 type 2 NUMBER(0) icol# 27 segcol# 27 INSTANCES len 22 type 2 NUMBER(0) icol# 28 segcol# 28 INTCOLS len 22 type 2 NUMBER(0) icol# 29 segcol# 29 KERNELCOLS len 22 type 2 NUMBER(0) icol# 30 segcol# 30 PROPERTY len 22 type 2 NUMBER(0) icol# 31 segcol# 31 TRIGFLAG len 22 type 2 NUMBER(0) icol# 32 segcol# 32 SPARE1 len 22 type 2 NUMBER(0) icol# 33 segcol# 33 SPARE2 len 22 type 2 NUMBER(0) icol# 34 segcol# 34 SPARE3 len 22 type 2 NUMBER(0) icol# 35 segcol# 35 SPARE4 len 1000 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 36 segcol# 36 SPARE5 len 1000 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 37 segcol# 37 SPARE6 len 7 type 12 DATE icol# 38 segcol# 38 SPARE7 len 22 type 2 NUMBER(0) icol# 39 segcol# 39 SPARE8 len 22 type 2 NUMBER(0) icol# 40 segcol# 40 SPARE9 len 1000 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 41 segcol# 41 SPARE10 len 1000 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 42 segcol# 42 ACDRFLAGS len 22 type 2 NUMBER(0) icol# 43 segcol# 43 ACDRTSOBJ# len 22 type 2 NUMBER(0) icol# 44 segcol# 44 ACDRDEFAULTTIME len 11 type 180 TIMESTAMP(9) icol# 45 segcol# 45 ACDRROWTSINTCOL# len 22 type 2 NUMBER(0)
可能遇到错误
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: Error: string2ub8(73786976294838206464), Conversion to number (ub8) overflowed DUL: Error: Number conversion error in file COL.dat, line 114321 DUL: Warning: Ignoring file COL.dat cache