标签云
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,671)
- DB2 (22)
- MySQL (73)
- Oracle (1,533)
- 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安装升级 (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)
-
最近发表
- 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默认服务配置优先节点
- Oracle 19c RAC 替换私网操作
- 监听报TNS-12541 TNS-12560 TNS-00511错误
- drop tablespace xxx including contents恢复
标签归档:oracle dul
最新版oracle dul工具
oracle官方dul工具继续更新,现在已经更新到12.2.0.2.5版本,可以支持oracle 6及其以上的所有版本,是oracle数据库在极端情况下恢复利器
[oracle@xifenfei dul]$ ./dul Data UnLoader: 12.2.0.2.5 - Internal Only - on Sun Mar 5 15:12:11 2023 with 64-bit io functions and the decompression option Copyright (c) 1994 2023 Bernard van Duijnen All rights reserved. Strictly Oracle Internal Use Only DUL: Warning: Could not open parameter file <init.dul> DUL: Warning: Compatible is set to 11 Values can be 6|7|8|9|10|11|12|17|18 DUL: Warning: no parameter file means no logfile DUL>
配置init.dul文件之后
[oracle@iZbp1hx0enix3hix1kvyrxZ dul]$ ./dul Data UnLoader: 12.2.0.2.5 - Internal Only - on Sun Mar 5 15:22:26 2023 with 64-bit io functions and the decompression option Copyright (c) 1994 2023 Bernard van Duijnen All rights reserved. Strictly Oracle Internal Use Only Found db_id = 1588579327 Found db_name = ORCL DUL> show datafiles; ts# rf# start blocks offs open err file name 0 1 0 97281 0 1 0 /u01/app/oracle/oradata/orcl/system01.dbf 1 2 0 387841 0 1 0 /u01/app/oracle/oradata/orcl/sysaux01.dbf 2 3 0 37761 0 1 0 /u01/app/oracle/oradata/orcl/undotbs01.dbf 4 4 0 5761 0 1 0 /u01/app/oracle/oradata/orcl/users01.dbf 7 5 0 16385 0 1 0 /u01/app/oracle/oradata/orcl/t_xifenfei01.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 59 rows unloaded Reading BOOTSTRAP.dat 59 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$ 86411 rows unloaded . unloading table TAB$ DUL: Warning: Block has been marked soft corrupt DUL: Error: While processing ts# 0 file# 1 block# 13335 2904 rows unloaded . unloading table COL$ DUL: Warning: Block has been marked soft corrupt DUL: Error: While processing ts# 0 file# 1 block# 13335 94714 rows unloaded . unloading table USER$ 88 rows unloaded Reading USER.dat 88 entries loaded Reading OBJ.dat 86411 entries loaded and sorted 86411 entries Reading TAB.dat 2904 entries loaded Reading COL.dat 94714 entries loaded and sorted 94714 entries Reading BOOTSTRAP.dat 59 entries loaded DUL: Warning: Recreating file "dict.ddl" 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 TABPART$: segobjno 591, file 1 block 4000 INDPART$: segobjno 596, file 1 block 4040 TABCOMPART$: segobjno 613, file 1 block 4176 INDCOMPART$: segobjno 618, file 1 block 4216 TABSUBPART$: segobjno 603, file 1 block 4096 INDSUBPART$: segobjno 608, file 1 block 4136 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 518, tabno 1, file 1 block 3464 COLLECTION$: segobjno 518, tabno 2, file 1 block 3464 ATTRIBUTE$: segobjno 518, tabno 3, file 1 block 3464 LOBFRAG$: segobjno 624, file 1 block 4264 LOBCOMPPART$: segobjno 627, file 1 block 4288 UNDO$: segobjno 15, file 1 block 224 TS$: segobjno 6, tabno 2, file 1 block 176 PROPS$: segobjno 98, file 1 block 800 Running generated file "@dict.ddl" to unload the dictionary tables . unloading table OBJ$ DUL: Warning: Recreating file "OBJ.ctl" 86411 rows unloaded . unloading table TAB$ DUL: Warning: Block has been marked soft corrupt DUL: Error: While processing ts# 0 file# 1 block# 13335 DUL: Warning: Recreating file "TAB.ctl" 2904 rows unloaded . unloading table COL$ DUL: Warning: Block has been marked soft corrupt DUL: Error: While processing ts# 0 file# 1 block# 13335 DUL: Warning: Recreating file "COL.ctl" 94714 rows unloaded . unloading table USER$ DUL: Warning: Recreating file "USER.ctl" 88 rows unloaded . unloading table TABPART$ 143 rows unloaded . unloading table INDPART$ 124 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$ DUL: Warning: Block has been marked soft corrupt DUL: Error: While processing ts# 0 file# 1 block# 13335 4931 rows unloaded . unloading table ICOL$ DUL: Warning: Block has been marked soft corrupt DUL: Error: While processing ts# 0 file# 1 block# 13335 7644 rows unloaded . unloading table LOB$ DUL: Warning: Block has been marked soft corrupt DUL: Error: While processing ts# 0 file# 1 block# 13335 1031 rows unloaded . unloading table COLTYPE$ DUL: Warning: Block has been marked soft corrupt DUL: Error: While processing ts# 0 file# 1 block# 13335 2565 rows unloaded . unloading table TYPE$ 2909 rows unloaded . unloading table COLLECTION$ 1002 rows unloaded . unloading table ATTRIBUTE$ 11328 rows unloaded . unloading table LOBFRAG$ 1 row unloaded . unloading table LOBCOMPPART$ 0 rows unloaded . unloading table UNDO$ 21 rows unloaded . unloading table TS$ 8 rows unloaded . unloading table PROPS$ 36 rows unloaded Reading USER.dat 88 entries loaded Reading OBJ.dat 86411 entries loaded and sorted 86411 entries Reading TAB.dat 2904 entries loaded Reading COL.dat 94714 entries loaded and sorted 94714 entries Reading TABPART.dat 143 entries loaded and sorted 143 entries Reading TABCOMPART.dat 1 entries loaded and sorted 1 entries Reading TABSUBPART.dat 32 entries loaded and sorted 32 entries Reading INDPART.dat 124 entries loaded and sorted 124 entries Reading INDCOMPART.dat 0 entries loaded and sorted 0 entries Reading INDSUBPART.dat 0 entries loaded and sorted 0 entries Reading IND.dat 4931 entries loaded Reading LOB.dat DUL: Notice: Increased the size of DC_LOBS from 1024 to 8192 entries 1031 entries loaded Reading ICOL.dat 7644 entries loaded Reading COLTYPE.dat 2565 entries loaded Reading TYPE.dat 2909 entries loaded Reading ATTRIBUTE.dat 11328 entries loaded Reading COLLECTION.dat 1002 entries loaded Reading BOOTSTRAP.dat 59 entries loaded Reading LOBFRAG.dat 1 entries loaded and sorted 1 entries Reading LOBCOMPPART.dat 0 entries loaded and sorted 0 entries Reading UNDO.dat 21 entries loaded Reading TS.dat 8 entries loaded Reading PROPS.dat 36 entries loaded Database character set is ZHS16GBK Database national character set is AL16UTF16 DUL>
oracle dul 12.2正式版发布
oracle官方dul 正式发布 12.2版本(在上次的测试中dul 12.2完美支持Oracle 19c恢复还是beta版本)
[root@iZbp1hx0enix3hix1kvyrxZ tmp]# ./dul Data UnLoader: 12.2.0.0.1 - Internal Only - on Sun Mar 21 13:55:39 2021 with 64-bit io functions and the decompression option Copyright (c) 1994 2021 Bernard van Duijnen All rights reserved. Strictly Oracle Internal Use Only DUL> show parameters; _SLPE_DEBUG = FALSE ALLOW_CHECKSUM_MISMATCH = FALSE ALLOW_DBA_MISMATCH = FALSE ALLOW_OTHER_OBJNO = FALSE ALLOW_TRAILER_MISMATCH = FALSE ALLOW_ZERO_IN_DATE_COLUMNS = FALSE ASM_DO_HARD_CHECKS = TRUE AUTO_UPDATE_CHECKSUM = TRUE AUTO_UPDATE_TRAILER = TRUE BUFFER = 104857600 CF_FILES = 1022 CF_TABLESPACES = 64 COMPATIBLE = 11 CONTROL_FILE = control.txt DB_BLOCK_SIZE = 8192 DB_NAME = DB_ID = 0 DC_COLUMNS = 2000000 DC_LOB_ENTRIES = 327680 DC_EXTENTS = 10000 DC_OBJECTS = 1000000 DC_SEGMENTS = 100000 DC_TABLES = 10000 DC_USERS = 400 DEFAULT_CHARACTER_SET = DEFAULT_NATIONAL_CHARACTER_SET = EXPORT_MODE = true FEEDBACK = 10000 FILE = FILE_SIZE_IN_MB = 0 LDR_ENCLOSE_CHAR = | LDR_OUTPUT_IN_UTF8 = FALSE LDR_PHYS_REC_SIZE = 0 LOGFILE = dul.log MAX_OPEN_FILES = 8 MAX_SCAN_ROWS = 0 MAX_SAMPLE_ROWS = 5 OSD_MAX_THREADS = 1055 OSD_BIG_ENDIAN_FLAG = false OSD_DBA_FILE_BITS = 10 OSD_FILE_LEADER_SIZE = 0 OSD_C_STRUCT_ALIGNMENT = 32 OSD_WORD_SIZE = 32 PARSE_HEX_ESCAPES = FALSE RESET_LOGFILE = FALSE SCAN_DATABASE_SCANS_LOB_SEGMENTS = TRUE SCAN_STEP_SIZE = 512 TRACE_FLAGS = 0 UNEXP_MAX_ERRORS = 1000 UNEXP_VERBOSE = FALSE USE_LOB_FILES = FALSE USE_SCANNED_EXTENT_MAP = FALSE VERIFY_NUMBER_PRECISION = TRUE WARN_RECREATE_FILES = TRUE WRITABLE_DATAFILES = FALSE DUL> exit Life is DUL without it [root@iZbp1hx0enix3hix1kvyrxZ tmp]#
oracle dul 12 正式发布
千呼万唤oracle官方dul工具终于发布了12版本,dul 11版本发布参见:oracle dul 11 正式发布
Data UnLoader: 12.0.0.0.5 - Internal Only - on Thu Feb 27 11:27:42 2020 with 64-bit io functions Copyright (c) 1994 2019 Bernard van Duijnen All rights reserved. Strictly Oracle Internal Use Only Reading USER.dat 87 entries loaded Reading OBJ.dat 72882 entries loaded and sorted 72882 entries Reading TAB.dat 2810 entries loaded Reading COL.dat 90151 entries loaded and sorted 90151 entries Reading TABPART.dat 107 entries loaded and sorted 107 entries Reading TABCOMPART.dat 0 entries loaded and sorted 0 entries Reading TABSUBPART.dat 0 entries loaded and sorted 0 entries Reading INDPART.dat 124 entries loaded and sorted 124 entries Reading INDCOMPART.dat 0 entries loaded and sorted 0 entries Reading INDSUBPART.dat 0 entries loaded and sorted 0 entries Reading IND.dat 4695 entries loaded Reading LOB.dat 883 entries loaded Reading ICOL.dat 7430 entries loaded Reading COLTYPE.dat 2203 entries loaded Reading TYPE.dat 2779 entries loaded Reading ATTRIBUTE.dat 10852 entries loaded Reading COLLECTION.dat 960 entries loaded Reading BOOTSTRAP.dat 60 entries loaded Reading LOBFRAG.dat 1 entries loaded and sorted 1 entries Reading LOBCOMPPART.dat 0 entries loaded and sorted 0 entries Reading UNDO.dat 21 entries loaded Reading TS.dat 11 entries loaded Reading PROPS.dat 36 entries loaded Database character set is ZHS16GBK Database national character set is AL16UTF16 Found db_id = 3861844098 Found db_name = O11201GB DUL> 2 show datafiles; ts# rf# start blocks offs open err file name 0 1 0 103681 0 1 0 D:\app\XIFENFEI\oradata\o11201gbk/system01.dbf DUL>
从Compatible参数上看,直接支持到oracle 18版本,具体后续测试