-
UID:862213
-
- 注册时间2016-04-26
- 最后登录2016-07-12
- 在线时间11小时
-
- 发帖34
- 搜Ta的帖子
- 精华0
- 黑豆6
- 威望138
- 贡献值0
- 交易币0
- 红豆0
-
访问TA的空间加好友用道具
|
dul对被drop对象进行恢复,需要提供两个信息1.被删除表所属表空间(非必须) 2.被删除表结构(必须) 模拟删除表使用logminer找到data_object_id这里可以知道,被删除表的data_object_id为68474
DUL恢复被删除表 --dul版本 E:\dul10>dul.exe Data UnLoader 10.2.4.37 - Oracle Internal Only - on Mon Feb 04 23:49:50 2013 with 64-bit io functions Copyright (c) 1994 2010 Bernard van Duijnen All rights reserved. Strictly Oracle Internal use Only DUL> ALTER SESSION SET USE_SCANNED_EXTENT_MAP = TRUE; Parameter altered --扫描所属表空间 DUL> scan tablespace 6; Scanning tablespace 6, data file 6 ... 13 segment header and 331 data blocks tablespace 6, data file 6: 1279 blocks scanned Reading EXT.dat 13 entries loaded and sorted 13 entries Reading SEG.dat 13 entries loaded Reading COMPATSEG.dat 0 entries loaded Reading SCANNEDLOBPAGE.dat 0 entries loaded and sorted 0 entries --scan tables得到需求表(可以核对数据样例) DUL> scan tables; UNLOAD TABLE OBJNO68474 ( COL001 VARCHAR2(11), COL002 VARCHAR2(30), COL003 VARCHAR2(6) , COL004 VARCHAR2(20), COL005 VARCHAR2(30), COL006 VARCHAR2(5), COL007 NUMBER , COL008 NUMBER, COL009 NUMBER, COL010 NUMBER, COL011 NUMBER , COL012 NUMBER, COL013 NUMBER, COL014 NUMBER, COL015 CHAR , COL016 NUMBER, COL017 NUMBER, COL018 VARCHAR2(3), COL019 VARCHAR2(1) , COL020 NUMBER, COL021 NUMBER, COL022 NUMBER, COL023 NUMBER , COL024 NUMBER, COL025 NUMBER, COL026 NUMBER, COL027 NUMBER , COL028 VARCHAR2(10), COL029 VARCHAR2(10), COL030 VARCHAR2(5), COL031 VARCHAR2(7) , COL032 NUMBER, COL033 DATE, COL034 VARCHAR2(3), COL035 VARCHAR2(12) , COL036 VARCHAR2(1), COL037 VARCHAR2(1), COL038 VARCHAR2(3), COL039 VARCHAR2(7) , COL040 VARCHAR2(7), COL041 VARCHAR2(7), COL042 VARCHAR2(8), COL043 VARCHAR2(3) , COL044 VARCHAR2(2), COL045 VARCHAR2(15), COL046 VARCHAR2(8), COL047 VARCHAR2(3) , COL048 VARCHAR2(3), COL049 VARCHAR2(8), COL050 VARCHAR2(8), COL051 VARCHAR2(5) , COL052 VARCHAR2(2), COL053 VARCHAR2(2), COL054 VARCHAR2(3), COL055 VARCHAR2(7) ) STORAGE( DATAOBJNO 68474 ); --恢复删除表(业务提供表结构) DUL> unload table t_dul_drop( 2 OWNER VARCHAR2(30), 3 TABLE_NAME VARCHAR2(30), 4 TABLESPACE_NAME VARCHAR2(30), 5 CLUSTER_NAME VARCHAR2(30), 6 IOT_NAME VARCHAR2(30), 7 STATUS VARCHAR2(8) , 8 PCT_FREE NUMBER , 9 PCT_USED NUMBER , 10 INI_TRANS NUMBER , 11 MAX_TRANS NUMBER , 12 INITIAL_EXTENT NUMBER , 13 NEXT_EXTENT NUMBER , 14 MIN_EXTENTS NUMBER , 15 MAX_EXTENTS NUMBER , 16 PCT_INCREASE NUMBER , 17 FREELISTS NUMBER , 18 FREELIST_GROUPS NUMBER , 19 LOGGING VARCHAR2(3) , 20 BACKED_UP VARCHAR2(1) , 21 NUM_ROWS NUMBER , 22 BLOCKS NUMBER , 23 EMPTY_BLOCKS NUMBER , 24 AVG_SPACE NUMBER , 25 CHAIN_CNT NUMBER , 26 AVG_ROW_LEN NUMBER , 27 AVG_SPACE_FREELIST_BLOCKS NUMBER , 28 NUM_FREELIST_BLOCKS NUMBER , 29 DEGREE VARCHAR2(20), 30 INSTANCES VARCHAR2(20), 31 CACHE VARCHAR2(10), 32 TABLE_LOCK VARCHAR2(8) , 33 SAMPLE_SIZE NUMBER , 34 LAST_ANALYZED DATE , 35 PARTITIONED VARCHAR2(3) , 36 IOT_TYPE VARCHAR2(12), 37 TEMPORARY VARCHAR2(1) , 38 SECONDARY VARCHAR2(1) , 39 NESTED VARCHAR2(3) , 40 BUFFER_POOL VARCHAR2(7) , 41 FLASH_CACHE VARCHAR2(7) , 42 CELL_FLASH_CACHE VARCHAR2(7) , 43 ROW_MOVEMENT VARCHAR2(8) , 44 GLOBAL_STATS VARCHAR2(3) , 45 USER_STATS VARCHAR2(3) , 46 DURATION VARCHAR2(15), 47 SKIP_CORRUPT VARCHAR2(8) , 48 MONITORING VARCHAR2(3) , 49 CLUSTER_OWNER VARCHAR2(30), 50 DEPENDENCIES VARCHAR2(8) , 51 COMPRESSION VARCHAR2(8) , 52 COMPRESS_FOR VARCHAR2(12), 53 DROPPED VARCHAR2(3) , 54 READ_ONLY VARCHAR2(3) , 55 SEGMENT_CREATED VARCHAR2(3) , 56 RESULT_CACHE VARCHAR2(7)) 57 STORAGE( DATAOBJNO 68474 ); . unloading table T_DUL_DROP DUL: Warning: Recreating file "T_DUL_DROP.ctl" 1785 rows unloaded | 模拟业务规则提供,创建表导入数据恢复数据结果· 完美解决dul处理clob字段乱码问题· dul支持ORACLE 12C CDB数据库恢复· dul恢复truncate表测试· exp dmp文件损坏恢复· 跳过obj$坏块方法· goldengate 异常处理· 通过修改基表(link$)让非public dblink变为public· sqlplus 使用小技巧· table()函数用法· long查询结果转换为varchar2类型· oracle 建立分区表· 表在线重定义(无主键) 更多Oracle学习:http://www.wyzc.com/ocp/?tg=3006123630
|