标签云
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 修改网卡名称
标签归档:dul 11g
dul 10支持oracle 11g r2
以前一直以为dul对应的版本只能恢复最高的数据库版本一致,今天测试发现dul 10可以恢复11g最新版的数据库.
模拟环境
SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0 Production TNS for Linux: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3.0 - Production SQL> select to_char(sysdate,'yyyy-mm-dd hh:mi:ss') "WWW.XIFENFEI.COM" FROM DUAL; WWW.XIFENFEI.COM ------------------- 2012-08-04 12:49:29 SQL> create table t_xifenfei 2 as 3 select * from dba_objects; Table created. SQL> select count(*) from t_xifenfei; COUNT(*) ---------- 74491 SQL> alter system checkpoint; System altered. SQL> / System altered.
dul 参数配置
[oracle@xifenfei dul]$ more init.dul osd_big_endian_flag=false osd_dba_file_bits=10 osd_c_struct_alignment=32 osd_file_leader_size=0 osd_word_size = 32 dc_columns=2000000 dc_tables=10000 dc_objects=1000000 dc_users=400 dc_segments=100000 control_file = control11.dul db_block_size=8192 export_mode=false compatible=11 BUFFER=10000000 LDR_ENCLOSE_CHAR=| [oracle@xifenfei dul]$ more control11.dul 0 1 /u01/oracle/oradata/ora11g/system01.dbf 1 2 /u01/oracle/oradata/ora11g/sysaux01.dbf 2 3 /u01/oracle/oradata/ora11g/undotbs01.dbf 4 4 /u01/oracle/oradata/ora11g/users01.dbf
dul恢复11g数据库
[oracle@xifenfei dul]$ ./dul10 Data UnLoader: 10.2.0.5.13 - Internal Only - on Sat Aug 4 00:36:15 2012 with 64-bit io functions Copyright (c) 1994 2012 Bernard van Duijnen All rights reserved. Strictly Oracle Internal Use Only DUL: Warning: Recreating file "dul.log" Found db_id = 4185048347 Found db_name = ORA11G 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 DUL: Warning: Dictionary cache DC_BOOTSTRAP is empty 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$ 74493 rows unloaded . unloading table TAB$ 2858 rows unloaded . unloading table COL$ 93503 rows unloaded . unloading table USER$ 88 rows unloaded Reading USER.dat 88 entries loaded Reading OBJ.dat 74493 entries loaded and sorted 74493 entries Reading TAB.dat 2858 entries loaded Reading COL.dat 93503 entries loaded and sorted 93503 entries Reading BOOTSTRAP.dat 60 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 568, file 1 block 3872 INDPART$: segobjno 573, file 1 block 3912 TABCOMPART$: segobjno 590, file 1 block 4056 INDCOMPART$: segobjno 595, file 1 block 4096 TABSUBPART$: segobjno 580, file 1 block 3976 INDSUBPART$: segobjno 585, file 1 block 4016 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 495, tabno 1, file 1 block 3344 COLLECTION$: segobjno 495, tabno 2, file 1 block 3344 ATTRIBUTE$: segobjno 495, tabno 3, file 1 block 3344 LOBFRAG$: segobjno 601, file 1 block 4144 LOBCOMPPART$: segobjno 604, file 1 block 4168 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" 74493 rows unloaded . unloading table TAB$ DUL: Warning: Recreating file "TAB.ctl" 2858 rows unloaded . unloading table COL$ DUL: Warning: Recreating file "COL.ctl" 93503 rows unloaded . unloading table USER$ DUL: Warning: Recreating file "USER.ctl" 88 rows unloaded . unloading table TABPART$ 90 rows unloaded . unloading table INDPART$ 106 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$ 5092 rows unloaded . unloading table ICOL$ 7518 rows unloaded . unloading table LOB$ 1251 rows unloaded . unloading table COLTYPE$ 2967 rows unloaded . unloading table TYPE$ 2872 rows unloaded . unloading table COLLECTION$ 985 rows unloaded . unloading table ATTRIBUTE$ 11127 rows unloaded . unloading table LOBFRAG$ 1 row unloaded . unloading table LOBCOMPPART$ 0 rows unloaded . unloading table UNDO$ 21 rows unloaded . unloading table TS$ 6 rows unloaded . unloading table PROPS$ 36 rows unloaded Reading USER.dat 88 entries loaded Reading OBJ.dat 74493 entries loaded and sorted 74493 entries Reading TAB.dat 2858 entries loaded Reading COL.dat 93503 entries loaded and sorted 93503 entries Reading TABPART.dat 90 entries loaded and sorted 90 entries Reading TABCOMPART.dat 1 entries loaded and sorted 1 entries Reading TABSUBPART.dat 32 entries loaded and sorted 32 entries Reading INDPART.dat 106 entries loaded and sorted 106 entries Reading INDCOMPART.dat 0 entries loaded and sorted 0 entries Reading INDSUBPART.dat 0 entries loaded and sorted 0 entries Reading IND.dat 5092 entries loaded Reading LOB.dat DUL: Warning: Increased the size of DC_LOBS from 1024 to 8192 entries 1251 entries loaded Reading ICOL.dat 7518 entries loaded Reading COLTYPE.dat 2967 entries loaded Reading TYPE.dat 2872 entries loaded Reading ATTRIBUTE.dat 11127 entries loaded Reading COLLECTION.dat 985 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 6 entries loaded Reading PROPS.dat 36 entries loaded Database character set is ZHS16GBK Database national character set is AL16UTF16 DUL> desc chf.t_xifenfei; Table CHF.T_XIFENFEI obj#= 75562, dataobj#= 75562, ts#= 4, file#= 4, block#=170 tab#= 0, segcols= 15, clucols= 0 Column information: icol# 01 segcol# 01 OWNER len 30 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 02 segcol# 02 OBJECT_NAME len 128 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 03 segcol# 03 SUBOBJECT_NAME len 30 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 04 segcol# 04 OBJECT_ID len 22 type 2 NUMBER(0,-127) icol# 05 segcol# 05 DATA_OBJECT_ID len 22 type 2 NUMBER(0,-127) icol# 06 segcol# 06 OBJECT_TYPE len 19 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 07 segcol# 07 CREATED len 7 type 12 DATE icol# 08 segcol# 08 LAST_DDL_TIME len 7 type 12 DATE icol# 09 segcol# 09 TIMESTAMP len 19 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 10 segcol# 10 STATUS len 7 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 11 segcol# 11 TEMPORARY len 1 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 12 segcol# 12 GENERATED len 1 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 13 segcol# 13 SECONDARY len 1 type 1 VARCHAR2 cs 852(ZHS16GBK) icol# 14 segcol# 14 NAMESPACE len 22 type 2 NUMBER(0,-127) icol# 15 segcol# 15 EDITION_NAME len 30 type 1 VARCHAR2 cs 852(ZHS16GBK) DUL> unload table chf.t_xifenfei; . unloading table T_XIFENFEI 74491 rows unloaded
通过一些列的dul 10测试,发现dul 10功能确实较9强大了很多.支持asm,支持11g,支持字符串换行+lob类型