问题描述
使用expdp导元数据或者导很小的数据(大概10M)都报错:
$expdp parfile=expdp_bip20190324.par
Export: Release 11.2.0.4.0 - Production on 星期三 3月 27 09:33:37 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
启动 "SYS"."SYS_EXPORT_SCHEMA_19": /******** AS SYSDBA parfile=expdp_bip20190324.par
处理对象类型 SCHEMA_EXPORT/USER
ORA-39126: 在 KUPW$WORKER.CREATE_OBJECT_ROWS [USER:"BIPLOG"] 中 Worker 发生意外致命错误
ORA-19510: 无法设置 4294967295 块的大小 (对于文件 "/backup/dump/expdp_bip20190324.dmp" (块大小=4096))
ORA-27039: 产生文件失败, 达到最大文件限度.
Additional information: 2
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: 在 "SYS.KUPW$WORKER", line 9715
----- PL/SQL Call Stack -----
object line object
handle number name
700010008a15c60 21979 package body SYS.KUPW$WORKER
700010008a15c60 9742 package body SYS.KUPW$WORKER
700010008a15c60 8638 package body SYS.KUPW$WORKER
700010008a15c60 11712 package body SYS.KUPW$WORKER
700010008a15c60 2808 package body SYS.KUPW$WORKER
700010008a15c60 10422 package body SYS.KUPW$WORKER
700010008a15c60 1824 package body SYS.KUPW$WORKER
700010142c9d820 2 anonymous block
作业 "SYS"."SYS_EXPORT_SCHEMA_19" 因致命错误于 星期三 3月 27 09:34:31 2019 elapsed 0 00:00:48 停止
expdp的par文件如下:
$cat expdp_bip20190324.par
userid=" / as sysdba"
directory=DUMP
dumpfile=expdp_bip20190324.dmp
logfile=expdp_bip20190324.log
cluster=n
exclude=statistics
content=metadata_only
COMPRESSION=all
schemas=(
BIPLOG
)
上网查了下说是有限制的,查了下ulimit
$ulimit -a
time(seconds) unlimited
file(blocks) 209715100
data(kbytes) unlimited
stack(kbytes) 4194304
memory(kbytes) unlimited
coredump(blocks) 2097151
nofiles(descriptors) unlimited
threads(per process) unlimited
processes(per user) unlimited
file(blocks)应该有100G了,应该够用的。而且我dd if=/mydirectory of=mytestfile bs=4096 count=1048576,是可以生成一个4G的文件的。
所以现在不知道怎么解决这个问题。
专家解答
将file size设置成unlimited