达梦V8数据库dexp导出报错及其解决办法
当前库大小[dmdba@dmdb1 OA]$ pwd/dm8/mdbms/data/OA[dmdba@dmdb1 OA]$ du -sh158G.[dmdba@dmdb1 OA]$当前导出目录剩余大小/dm8/expimp/full_filesize剩余279G[dmdba@dmdb1 full_filesize]$ df -hFilesystemSizeUsed Avail Use% Mount
·
当前库大小
[dmdba@dmdb1 OA]$ pwd
/dm8/mdbms/data/OA
[dmdba@dmdb1 OA]$ du -sh
158G .
[dmdba@dmdb1 OA]$
当前导出目录剩余大小
/dm8/expimp/full_filesize剩余279G
[dmdba@dmdb1 full_filesize]$ df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 7.8G 0 7.8G 0% /dev
tmpfs 7.8G 0 7.8G 0% /dev/shm
tmpfs 7.8G 13M 7.8G 1% /run
tmpfs 7.8G 0 7.8G 0% /sys/fs/cgroup
/dev/sda3 492G 213G 279G 44% /
/dev/sda1 297M 164M 134M 55% /boot
tmpfs 1.6G 12K 1.6G 1% /run/user/42
tmpfs 1.6G 0 1.6G 0% /run/user/0
tmpfs 1.6G 0 1.6G 0% /run/user/1001
[dmdba@dmdb1 full_filesize]$
执行dexp导出
执行语句为：dexp USERID=SYSDBA/SYSDBA FULL=Y file=db_full%U.dmp LOG=db_full%U.log DIRECTORY=/dm8/expimp/full_filesize FILESIZE=128m PARALLEL=4 TABLE_PARALLEL=4
执行后报错：[WARNING]create file fail, the space of the file exhaust…
[dmdba@dmdb1 full_filesize]$
[dmdba@dmdb1 full_filesize]$ dexp USERID=SYSDBA/SYSDBA FULL=Y file=db_full%U.dmp LOG=db_full%U.log DIRECTORY=/dm8/expimp/full_filesize FILESIZE=128m PARALLEL=4 TABLE_PARALLEL=4
dexp V8
export NO. 1 SYSPACKAGE_DEF : SYS_VIEW
----- export total 1 SYSPACKAGE_DEF -----
----- export total 0 SYSPACKAGE_DATA -----
----- export total 0 SYNONYM -----
----- export total 0 DBLINK -----
export NO. 1 USER : TESTU
----- export total 1 USER -----
----- export total 0 ROLE -----
----- export total 0 CONTEXT -----
export NO. 1 DIRECTORY : BOOKFILES
----- export total 1 DIRECTORY -----
export NO. 1 SYSTEM_PRIVILEGE : CREATE SESSION
----- export total 1 SYSTEM_PRIVILEGE -----
----- export total 0 USER_ROLE_PRIVILEGE -----
export NO. 1 SYS_ROLE_PRIVILEGE : DBA
export NO. 2 SYS_ROLE_PRIVILEGE : PUBLIC
export NO. 3 SYS_ROLE_PRIVILEGE : SOI
export NO. 4 SYS_ROLE_PRIVILEGE : VTI
----- export total 4 SYS_ROLE_PRIVILEGE -----
----- export total 0 SYS_ROLE_PRIVILEGE -----
the privilege of the object at the export mode...
exporting NO. 1 SCHEMA : TESTU
start export schema[TESTU].....
----- export total 0 SEQUENCE -----
----- export total 0 VIEW -----
----- export total 0 TRIGGER -----
----- export total 0 COMMENT VIEW -----
----- export total 0 COMMENT COL -----
----- export total 0 PROCEDURE -----
----- export total 0 SYNONYM -----
----- export total 0 DBLINK -----
----- export total 0 TRIGGER -----
----- export total 0 PACKAGE -----
----- export total 0 PKG_BODY -----
----- export total 0 OBJECT of NO REFER OTHER CLASS -----
----- export total 0 OBJECT of REFER OTHER CLASS -----
----- export total 0 JCLASS -----
----- export total 0 CLASS_BODY -----
----- export total 0 DOMAIN -----
the privilege of the object at the export mode...
---- [2022-05-23 22:03:17]export table:BOOKINFO3 -----
---- [2022-05-23 22:03:17]export table:A -----
---- [2022-05-23 22:03:17]export table:BOOKINFO_BAK -----
the privilege of the object at the export mode...
---- [2022-05-23 22:03:17]export table:BOOKINFO -----
the privilege of the object at the export mode...
the privilege of the object at the export mode...
table :BOOKINFO3 export terminate, total export 0 rows
the privilege of the object at the export mode...
table :BOOKINFO export terminate, total export 12 rows
table :A export terminate, total export 5 rows
[WARNING]create file fail, the space of the file exhaust...
[dmdba@dmdb1 full_filesize]$
报错排查1、目录剩余大小
/dm8/expimp/full_filesize剩余267G
[dmdba@dmdb1 full_filesize]$
[dmdba@dmdb1 full_filesize]$ df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 7.8G 0 7.8G 0% /dev
tmpfs 7.8G 0 7.8G 0% /dev/shm
tmpfs 7.8G 13M 7.8G 1% /run
tmpfs 7.8G 0 7.8G 0% /sys/fs/cgroup
/dev/sda3 492G 226G 267G 46% / 《===剩余空间267G
/dev/sda1 297M 164M 134M 55% /boot
tmpfs 1.6G 12K 1.6G 1% /run/user/42
tmpfs 1.6G 0 1.6G 0% /run/user/0
tmpfs 1.6G 0 1.6G 0% /run/user/1001
[dmdba@dmdb1 full_filesize]$
报错排查2、导出文件数目
dmp文件数目已经99个
[dmdba@dmdb1 full_filesize]$ ls
db_full01.dmp db_full10.dmp db_full20.dmp db_full30.dmp db_full40.dmp db_full50.dmp db_full60.dmp db_full70.dmp db_full80.dmp db_full90.dmp
db_full01.log db_full11.dmp db_full21.dmp db_full31.dmp db_full41.dmp db_full51.dmp db_full61.dmp db_full71.dmp db_full81.dmp db_full91.dmp
db_full02.dmp db_full12.dmp db_full22.dmp db_full32.dmp db_full42.dmp db_full52.dmp db_full62.dmp db_full72.dmp db_full82.dmp db_full92.dmp
db_full03.dmp db_full13.dmp db_full23.dmp db_full33.dmp db_full43.dmp db_full53.dmp db_full63.dmp db_full73.dmp db_full83.dmp db_full93.dmp
db_full04.dmp db_full14.dmp db_full24.dmp db_full34.dmp db_full44.dmp db_full54.dmp db_full64.dmp db_full74.dmp db_full84.dmp db_full94.dmp
db_full05.dmp db_full15.dmp db_full25.dmp db_full35.dmp db_full45.dmp db_full55.dmp db_full65.dmp db_full75.dmp db_full85.dmp db_full95.dmp
db_full06.dmp db_full16.dmp db_full26.dmp db_full36.dmp db_full46.dmp db_full56.dmp db_full66.dmp db_full76.dmp db_full86.dmp db_full96.dmp
db_full07.dmp db_full17.dmp db_full27.dmp db_full37.dmp db_full47.dmp db_full57.dmp db_full67.dmp db_full77.dmp db_full87.dmp db_full97.dmp
db_full08.dmp db_full18.dmp db_full28.dmp db_full38.dmp db_full48.dmp db_full58.dmp db_full68.dmp db_full78.dmp db_full88.dmp db_full98.dmp
db_full09.dmp db_full19.dmp db_full29.dmp db_full39.dmp db_full49.dmp db_full59.dmp db_full69.dmp db_full79.dmp db_full89.dmp db_full99.dmp
[dmdba@dmdb1 full_filesize]$ ls *.dmp |wc -l
99
[dmdba@dmdb1 full_filesize]$
[dmdba@dmdb1 full_filesize]$
解决办法
file num最多99个文件。当前库有158G，设置每个导出文件为2G，80个文件可以有160G，不超过99个文件
执行语句为：dexp USERID=SYSDBA/SYSDBA FULL=Y file=db_full%U.dmp LOG=db_full%U.log DIRECTORY=/dm8/expimp/full_filesize FILESIZE=2048m PARALLEL=4 TABLE_PARALLEL=4
[dmdba@dmdb1 full_filesize]$
[dmdba@dmdb1 full_filesize]$ dexp USERID=SYSDBA/SYSDBA FULL=Y file=db_full%U.dmp LOG=db_full%U.log DIRECTORY=/dm8/expimp/full_filesize FILESIZE=2048m PARALLEL=4 TABLE_PARALLEL=4
dexp V8
export NO. 1 SYSPACKAGE_DEF : SYS_VIEW
----- export total 1 SYSPACKAGE_DEF -----
----- export total 0 SYSPACKAGE_DATA -----
----- export total 0 SYNONYM -----
----- export total 0 DBLINK -----
export NO. 1 USER : TESTU
----- export total 1 USER -----
----- export total 0 ROLE -----
----- export total 0 CONTEXT -----
export NO. 1 DIRECTORY : BOOKFILES
----- export total 1 DIRECTORY -----
export NO. 1 SYSTEM_PRIVILEGE : CREATE SESSION
----- export total 1 SYSTEM_PRIVILEGE -----
----- export total 0 USER_ROLE_PRIVILEGE -----
export NO. 1 SYS_ROLE_PRIVILEGE : DBA
export NO. 2 SYS_ROLE_PRIVILEGE : PUBLIC
export NO. 3 SYS_ROLE_PRIVILEGE : SOI
export NO. 4 SYS_ROLE_PRIVILEGE : VTI
----- export total 4 SYS_ROLE_PRIVILEGE -----
----- export total 0 SYS_ROLE_PRIVILEGE -----
the privilege of the object at the export mode...
exporting NO. 1 SCHEMA : TESTU
start export schema[TESTU].....
----- export total 0 SEQUENCE -----
----- export total 0 VIEW -----
----- export total 0 TRIGGER -----
----- export total 0 COMMENT VIEW -----
----- export total 0 COMMENT COL -----
----- export total 0 PROCEDURE -----
----- export total 0 SYNONYM -----
----- export total 0 DBLINK -----
----- export total 0 TRIGGER -----
----- export total 0 PACKAGE -----
----- export total 0 PKG_BODY -----
----- export total 0 OBJECT of NO REFER OTHER CLASS -----
----- export total 0 OBJECT of REFER OTHER CLASS -----
----- export total 0 JCLASS -----
----- export total 0 CLASS_BODY -----
----- export total 0 DOMAIN -----
the privilege of the object at the export mode...
---- [2022-05-23 22:43:09]export table:BOOKINFO3 -----
---- [2022-05-23 22:43:09]export table:BOOKINFO_BAK -----
---- [2022-05-23 22:43:09]export table:A -----
the privilege of the object at the export mode...
the privilege of the object at the export mode...
table :BOOKINFO3 export terminate, total export 0 rows
---- [2022-05-23 22:43:09]export table:BOOKINFO -----
the privilege of the object at the export mode...
the privilege of the object at the export mode...
table :BOOKINFO export terminate, total export 12 rows
table :A export terminate, total export 5 rows
table :BOOKINFO_BAK export terminate, total export 192 rows
schema[TESTU] export terminate.....
successfully exported NO.1 SCHEMA : TESTU
exporting NO. 2 SCHEMA : SYSDBA
start export schema[SYSDBA].....
----- export total 0 SEQUENCE -----
----- export total 0 VIEW -----
----- export total 0 TRIGGER -----
----- export total 0 COMMENT VIEW -----
----- export total 0 COMMENT COL -----
----- export total 0 PROCEDURE -----
----- export total 0 SYNONYM -----
----- export total 0 DBLINK -----
----- export total 0 TRIGGER -----
----- export total 0 PACKAGE -----
----- export total 0 PKG_BODY -----
----- export total 0 OBJECT of NO REFER OTHER CLASS -----
----- export total 0 OBJECT of REFER OTHER CLASS -----
----- export total 0 JCLASS -----
----- export total 0 CLASS_BODY -----
----- export total 0 DOMAIN -----
the privilege of the object at the export mode...
---- [2022-05-23 23:23:31]export table:T01 -----
---- [2022-05-23 23:23:31]export table:TB01 -----
the privilege of the object at the export mode...
the privilege of the object at the export mode...
table :T01 export terminate, total export 10 rows
table :TB01 export terminate, total export 10203000 rows
schema[SYSDBA] export terminate.....
successfully exported NO.2 SCHEMA : SYSDBA
export total 2 SCHEMA
all the export process spent total 2426.117 s
terminate export success without warning
[dmdba@dmdb1 full_filesize]$
[dmdba@dmdb1 full_filesize]$ du -sh
105G .
[dmdba@dmdb1 full_filesize]$
[dmdba@dmdb1 full_filesize]$
[dmdba@dmdb1 full_filesize]$
[dmdba@dmdb1 full_filesize]$ ls *.dmp |wc -l
53
[dmdba@dmdb1 full_filesize]$
[dmdba@dmdb1 full_filesize]$
腾讯云面向开发者汇聚海量精品云计算使用和开发经验，营造开放的云计算技术生态圈。
更多推荐
0
0- 0
已为社区贡献1条内容
所有评论(0)