Learning Note: Oracle dul data Mining export oracle11g data file in table in bad block

test simulation Export data from a table in a bad block of data files in an Oracle 11G database

Previously thought that the dul corresponding version can only restore the highest database version consistent, today test found that Dul 10 can restore the latest version of the 11g database.
Simulation Environment

Sql> select * from V$version; BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition release 11.2.0.3.0-productionpl/sql release 11.2.0.3.0-productioncore    11.2.0.3.0      Productiontns for linux:version 11.2.0.3.0-productionnlsrtl Version 11.2.0.3.0-productionsql> Select To_char (SYSDA Te, ' yyyy-mm-dd hh:mi:ss ') "WWW. Xifenfei.com "from DUAL; Www. Xifenfei. COM-------------------2012-08-04 12:49:29sql> CREATE table T_xifenfei   2  as  3  select * FROM Dba_ Objects Table created. Sql> Select COUNT (*) from T_xifenfei;  COUNT (*)----------     74491sql> alter system checkpoint; System altered. Sql>/system altered.

Dul parameter Configuration

[Email protected] dul]$ more Init.dul osd_big_endian_flag=falseosd_dba_file_bits=10osd_c_struct_alignment=32osd_ File_leader_size=0osd_word_size = 32dc_columns=2000000dc_tables=10000dc_objects=1000000dc_users=400dc_segments= 100000control_file = Control11.duldb_block_size=8192export_mode=falsecompatible=11buffer=10000000ldr_enclose_ char=| [Email protected] 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 Recovering a 11g database

[[email protected] dul]$./dul10data unloader:10.2.0.5.13-internal only-on Sat 4 00:36:15 2012with 64-bit I o Functionscopyright (c) 1994, Bernard van Duijnen all rights reserved. Strictly Oracle Internal use OnlyDUL:Warning:Recreating file "Dul.log" Found db_id = 4185048347Found db_name = ora11gdul&  Gt Bootstrap Probing file = 1, block = 520. Unloading table Bootstrap$dul:warning:block number is non zero and marked deferred trying to process it a Nyhow rows UnloadedDUL:Warning:Dictionary Cache Dc_bootstrap is emptyreading BOOTSTRAP.dat entries Loadedpars ing bootstrap$ contentsgenerating dict.ddl for version one obj$: Segobjno, File 1 block tab$: Segobjno 2, Tabno 1, F Ile 1 Block 144 col$: Segobjno 2, tabno 5, File 1 Block 144 user$: Segobjno, tabno 1, file 1 block 208Running genera Ted 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$ (rows unloadedreading USER.dat) entries loadedreading OBJ.dat 74493 ent Ries loaded and sorted 74493 entriesreading TAB.dat 2858 entries loadedreading COL.dat 93503 entries loaded and sorted 935 entriesreading BOOTSTRAP.dat Entries loadedDUL:Warning:Recreating file "Dict.ddl" generating dict.ddl for version 1 1 obj$: Segobjno, File 1 block tab$: Segobjno 2, tabno 1, file 1 Block 144 col$: Segobjno 2, tabno 5, file 1 bloc K 144 user$: Segobjno, tabno 1, file 1 Block 208 tabpart$: Segobjno 568, file 1 block 3872 indpart$: Segobjno 573, fil E 1 Block 3912 tabcompart$: Segobjno 590, file 1 Block 4056 indcompart$: Segobjno 595, file 1 block 4096 tabsubpart$: Sego Bjno 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 bloc K 3344 lobfrag$: Segobjno 601, file 1 block 4144 lobcomppart$: Segobjno 604, file 1 block 4168 undo$: segobjno, file 1 Block 224 ts$: Segobjno 6, Tabno 2, file 1 block 176 props$: Segobjno 98, file 1 block 800Running generated file "@dict. D DL "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" in rows unloaded. Unloading table tabpart$ rows UNLOaded. Unloading table indpart$ 106 rows unloaded. Unloading table tabcompart$ 1 row unloaded. Unloading table indcompart$ 0 rows unloaded. Unloading table tabsubpart$ the 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$ rows unloaded.   Unloading table                    ts$ 6 rows unloaded. Unloading table props$, rows unloadedreading USER.dat, entries loadedreading OBJ.dat 74493 ent Ries loaded and sorted 74493 entriesreading TAB.dat 2858 entries loadedreading COL.dat 93503 entries loaded and sorted 935 TABPART.dat entries loaded and sorted entriesreading entriesreading TABCOMPART.dat 1 entries loaded and sorted 1  entriesreading TABSUBPART.dat entries loaded and sorted + entriesreading INDPART.dat 106 entries loaded and sorted 106 Entriesreading INDCOMPART.dat 0 Entries loaded and sorted 0 entriesreading INDSUBPART.dat 0 entries loaded and sorted 0 E Ntriesreading IND.dat 5092 Entries loadedreading LOB.datDUL:Warning:Increased the size of dc_lobs from 1024x768 to 8192 entr IES 1251 entries loadedreading ICOL.dat 7518 entries loadedreading COLTYPE.dat 2967 entries loadedreading TYPE.dat 2872 en Tries loadedreading ATTRIBUTE.dat 11127 entries loadedreading COLLECTION.dat 985 entries Loadedreading BOOTSTRAP.dat entries loadedreading LOBFRAG.dat 1 entries loaded and sorted 1 entriesreading LOBCOMPPART.dat 0 entr IES loaded and sorted 0 entriesreading UNDO.dat entries loadedreading TS.dat 6 entries loadedreading PROPS.dat-Entri Es loadeddatabase Character set is Zhs16gbkdatabase national character set is al16utf16dul> desc Chf.t_xifenfei; Table CHF. t_xifenfeiobj#= 75562, dataobj#= 75562, ts#= 4, file#= 4, block#=170 tab#= 0, segcols=, clucols= 0Column informati on:icol# segcol#, OWNER Len 1, VARCHAR2 CS 852 (ZHS16GBK) icol#-segcol#, object_name len-ty PE 1 VARCHAR2 CS 852 (ZHS16GBK) icol# segcol# (subobject_name) Len Type 1 VARCHAR2 CS 852 (ZHS16GBK) icol# l# object_id Len Type 2 number (0,-127) icol# segcol# data_object_id len Type 2 number (0,-127) icol# segcol# object_type len Type 1 VARCHAR2 CS 852 (ZHS16GBK) icol#, segcol# CREATED len 7 type DAT eicol# segcol# 08Last_ddl_time len 7 type dateicol# segcol# TIMESTAMP len Type 1 VARCHAR2 CS 852 (ZHS16GBK) icol# ten SEG col# STATUS len 7 Type 1 VARCHAR2 CS 852 (ZHS16GBK) icol# one segcol# one temporary len 1 type 1 VARCHAR2 CS 852 (ZHS16GBK) icol# segcol# GENERATED len 1 type 1 VARCHAR2 CS 852 (ZHS16GBK) icol#-segcol# Y len 1 type 1 VARCHAR2 CS 852 (ZHS16GBK) icol# segcol# (NAMESPACE) Len Type 2 number (0,-127) icol# l# edition_name Len 1 VARCHAR2 CS 852 (ZHS16GBK) dul> unload table Chf.t_xifenfei;. Unloading table T_xifenfei 74491 rows unloaded

With some columns of the Dul 10 test, it was found that Dul 10 was really a lot more powerful than 9. Support ASM, support 11g, string wrapping +lob type

-----------------Tips--------------------operation is risky, hands-on need to be cautious Oracle Research Center http://www.oracleplus.net This article by the master cherish the original sharing, reproduced please try to retain the site website

--------------------------------------ORACLE-DBA----------------------------------------

The most authoritative and professional Oracle Case Resource Summary Study NOTE: Oracle Dul Data Mining export oracle11g data file in table in bad block

Original URL: http://www.oracleplus.net/arch/oracle-20160522-214.html

Oracle Research Center Key Words:Oracle Dul Data Mining oracle11g data files in bad blocks export data from a table in a bad block in an Oracle data file

Learning Note: Oracle dul data Mining export oracle11g data file in table in bad block