oracle number(8 0),DUL10直接支持ORACLE 8.0 – 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@Tel:+86 ...

最新推荐文章于 2021-11-24 17:07:16 发布

weixin_39845039

最新推荐文章于 2021-11-24 17:07:16 发布

阅读量261

点赞数

文章标签： oracle number(8 0)

在以前的文章中,写过DUL挖ORACLE 8.0数据库,使用的是dul 8的版本,现在测试dul 10直接支持ORACLE 8.0数据库

数据库版本 ORACLE 8

SVRMGR> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle8 Release 8.0.5.0.0 - Production

PL/SQL Release 8.0.5.0.0 - Production

CORE Version 4.0.5.0.0 - Production

TNS for 32-bit Windows: Version 8.0.5.0.0 - Production

NLSRTL Version 3.3.2.0.0 - Production

5 rows selected.

dul版本 DUL 10

e:\dul10>dul

Data UnLoader: 10.2.0.5.26 - Internal Only - on Sat Feb 15 15:54:15 2014

with 64-bit io functions

Strictly Oracle Internal Use Only

Found db_id = 1207542366

Found db_name = ORCL

DUL读取数据文件

DUL> show datafiles;

ts# rf# start blocks offs open err file name

UNK 1 0 102401 0 1 0 C:\Users\XIFENFEI\Desktop\temp\SYS1ORCL.ORA

DUL10参数配置

DUL> show parameter;

_SLPE_DEBUG = FALSE

ALLOW_CHECKSUM_MISMATCH = TRUE

ALLOW_DBA_MISMATCH = TRUE

ALLOW_OTHER_OBJNO = TRUE

ALLOW_TRAILER_MISMATCH = TRUE

ASM_DO_HARD_CHECKS = TRUE

AUTO_UPDATE_CHECKSUM = TRUE

AUTO_UPDATE_TRAILER = TRUE

BUFFER = 10485760

CF_FILES = 1022

CF_TABLESPACES = 64

COMPATIBLE = 8

CONTROL_FILE = control.txt

DB_BLOCK_SIZE = 2048

DB_NAME =

DB_ID = 0

DC_COLUMNS = 100000

DC_OBJECTS = 128k

DC_TABLES = 10000

DC_USERS = 1000

DC_SEGMENTS = 10000

DC_EXTENTS = 10000

DEFAULT_CHARACTER_SET =

DEFAULT_NATIONAL_CHARACTER_SET =

EXPORT_MODE = false

FEEDBACK = 1000

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

OSD_MAX_THREADS = 1055

OSD_BIG_ENDIAN_FLAG = false

OSD_DBA_FILE_BITS = 10

OSD_FILE_LEADER_SIZE = 1

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 = TRUE

USE_SCANNED_EXTENT_MAP = FALSE

VERIFY_NUMBER_PRECISION = TRUE

WARN_RECREATE_FILES = TRUE

WRITABLE_DATAFILES = FALSE

DUL10加载ORACLE 8数据字典

DUL> bootstrap;

Probing file = 1, block = 527

database version 8 bootstrap$ at file 1, block 352

. unloading table BOOTSTRAP$

DUL: Warning: block number is non zero but marked deferred trying to process it anyhow

52 rows unloaded

DUL: Warning: Dictionary cache DC_BOOTSTRAP is empty

Reading BOOTSTRAP.dat 52 entries loaded

Parsing Bootstrap$ contents

DUL: Warning: Recreating file "dict.ddl"

Generating dict.ddl for version 8

OBJ$: segobjno 18, file 1 block 167

TAB$: segobjno 2, tabno 1, file 1 block 52

COL$: segobjno 2, tabno 5, file 1 block 52

USER$: segobjno 10, tabno 1, file 1 block 147

Running generated file "@dict.ddl" to unload the dictionary tables

. unloading table OBJ$ 3504 rows unloaded

. unloading table TAB$ 434 rows unloaded

. unloading table COL$ 16185 rows unloaded

. unloading table USER$ 24 rows unloaded

Reading USER.dat 24 entries loaded

Reading OBJ.dat 3504 entries loaded and sorted 3504 entries

Reading TAB.dat 434 entries loaded

Reading COL.dat 16185 entries loaded and sorted 16185 entries

Reading BOOTSTRAP.dat 52 entries loaded

DUL: Error: No entry in OBJ$ for "TABCOMPART$" type = 2

DUL: Error: No base dict info for SYS.TABCOMPART$

DUL: Error: No entry in OBJ$ for "INDCOMPART$" type = 2

DUL: Error: No base dict info for SYS.INDCOMPART$

DUL: Error: No entry in OBJ$ for "TABSUBPART$" type = 2

DUL: Error: No base dict info for SYS.TABSUBPART$

DUL: Error: No entry in OBJ$ for "INDSUBPART$" type = 2

DUL: Error: No base dict info for SYS.INDSUBPART$

DUL: Warning: Recreating file "dict.ddl"

Generating dict.ddl for version 8

OBJ$: segobjno 18, file 1 block 167

TAB$: segobjno 2, tabno 1, file 1 block 52

COL$: segobjno 2, tabno 5, file 1 block 52

USER$: segobjno 10, tabno 1, file 1 block 147

TABPART$: segobjno 180, file 1 block 1275

INDPART$: segobjno 182, file 1 block 1285

IND$: segobjno 2, tabno 3, file 1 block 52

ICOL$: segobjno 2, tabno 4, file 1 block 52

LOB$: segobjno 2, tabno 8, file 1 block 52

Running generated file "@dict.ddl" to unload the dictionary tables

. unloading table OBJ$

DUL: Warning: Recreating file "OBJ.ctl"

3504 rows unloaded

. unloading table TAB$

DUL: Warning: Recreating file "TAB.ctl"

434 rows unloaded

. unloading table COL$

DUL: Warning: Recreating file "COL.ctl"

16185 rows unloaded

. unloading table USER$

DUL: Warning: Recreating file "USER.ctl"

24 rows unloaded

. unloading table TABPART$ 0 rows unloaded

. unloading table INDPART$ 0 rows unloaded

. unloading table IND$ 525 rows unloaded

. unloading table ICOL$ 899 rows unloaded

. unloading table LOB$ 27 rows unloaded

Reading USER.dat 24 entries loaded

Reading OBJ.dat 3504 entries loaded and sorted 3504 entries

Reading TAB.dat 434 entries loaded

Reading COL.dat 16185 entries loaded and sorted 16185 entries

Reading TABPART.dat 0 entries loaded and sorted 0 entries

Reading INDPART.dat 0 entries loaded and sorted 0 entries

Reading IND.dat 525 entries loaded

Reading LOB.dat 27 entries loaded

Reading ICOL.dat 899 entries loaded

Reading BOOTSTRAP.dat 52 entries loaded

DUL 10 unload ORACLE 8 TABLE

DUL> unload table ts$;

. unloading table TS$ 4 rows unloaded

DUL>

通过测试,证明DUL10可以完美支持ORACLE 8.0数据库,在以后的低版本数据使用dul unload过程中,可以直接使用最新版本,而不用去到处寻找老版本dul