姓名:杨宝秋,OCM,ACE。近8年的TB级数据库设计、建设、管理、运行维护、调优经验,也做了7年的Hp和IBM Rs6000的系统管理员,而且是获得了BCFP认证的SAN管理员,现为中国联通黑龙江分公司数据库主管。
Dul中的参数
上一篇 /
下一篇 2008-03-13 11:23:29
/ 个人分类:Oracle
Dul中可以使用的参数,放在这里备查:
_LPE_DEBUG : INTERNAL: compare lobpage dbas from inode and from scan
ALLOW_CHECKSUM_MISMATCH : DISCOURAGED: allow block checksum mismatch
ALLOW_DBA_MISMATCH : DISCOURAGED: allow wrong dba in block
ALLOW_OTHER_OBJNO : allow other objno in segment header(for out of sync data dictionaries)
ALLOW_TRAILER_MISMATCH : DISCOURAGED: allow block trailer/incseq mismatch
ASM_DO_HARD_CHECKS : Use H.A.R.D. checks to verify mirrors
AUTO_UPDATE_CHECKSUM : When patching automatically update the checksum
AUTO_UPDATE_TRAILER : When patching automatically update the trailer
BUFFER : row output buffer size
COMPATIBLE : database version (6|7|8|8.1|9|10)
CONTROL_FILE : DUL control file name
DB_BLOCK_SIZE : Oracle Data Block Size
DC_COLUMNS : Size of Column Dictionary Cache
DC_FILES : Size of internal file part table
DC_OBJECTS : Size of Object Dictionary Cache
DC_TABLES : Size of Table Dictionary Cache
DC_TABLESPACES : Size of Tablespace Dictionary Cache
DC_USERS : Size of Users Dictionary Cache
DC_SEGMENTS : Size of the Scanned Segment Dictionary Cache
DC_EXTENTS : Size of Scanned Extent Dictionary Cache
DEFAULT_CHARACTER_SET : Default character set Name or numeric id
DEFAULT_NATIONAL_CHARACTER_SET : Default National Character set Name or numeric id
EXPORT_MODE : EXPort output MODE or SQL*Loader like output
FEEDBACK : display progress every x rows (0)
FILE : Output (dump or data) file name
FILE_SIZE_IN_MB : max output file size, enables splitting output files
LDR_ENCLOSE_CHAR : Character to enclose strings
LDR_OUTPUT_IN_UTF8 : Convert (N)Character strings to UTF8 (beta)
LDR_PHYS_REC_SIZE : SQL*Loader physical record size
LOGFILE : DUL logfile
MAX_OPEN_FILES : Maximum # files that are concurrently kept open
OSD_MAX_THREADS : Port specific maximum number of threads
OSD_BIG_ENDIAN_FLAG : Byte order in machine word
OSD_DBA_FILE_BITS : File Number Size in DBA
OSD_FILE_LEADER_SIZE : bytes/blocks before file header block
OSD_C_STRUCT_ALIGNMENT : C Structure member alignment (0, 16, 32 or 64)
OSD_WORD_SIZE : Size of a machine word always 32, except for MS/DOS(16)
PARSE_HEX_ESCAPES : Use \xhh hex escape sequences in strings while parsing
RESET_LOGFILE : truncate the logfile on each invocation
SCAN_DATABASE_SCANS_LOB_SEGMENTS : builds (possibly huge) LOBPAGE.dat to find missing lob pages
TRACE_FLAGS : DUL Internal Tracing Options
USE_LOB_FILES : to get old behaviour with each lob in its own lobfile
USE_SCANNED_EXTENT_MAP : Use the scanned extent map in case of corrupted or missing segment headers
VERIFY_NUMBER_PRECISION : Check precision and scale of numbers during conversion
WARN_RECREATE_FILES : Issue a warning message if a data/export/control file will be recreated
WRITABLE_DATA_FILES : Allow DUL to update a data file, only required for FORMAT, UPDATE and SCAN DEVIC
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG: