一般这个情况主要出现在 RAC 双机的气象中心节点。
表现为BULL01_ALL
表导出后就不继续了
1、如果情况允许,清空数据表是最先采用的办法,主要是因为这套老系统不适应数据量越来越大的实际情况。
truncate
table MHAPP.IMAGE01_RADAR DROP
STORAGE;
truncate table MHAPP.IMAGE01_STAR DROP
STORAGE;
truncate table MHAPP.IMAGE01_FAX DROP
STORAGE;
truncate table MHAPP.IMAGE01_PROG DROP
STORAGE;
truncate table MHAPP.IMAGE01_MEDIA DROP
STORAGE;
truncate table MHAPP.IMAGE01_WIND DROP
STORAGE;
truncate table MHAPP.ELE01_AWOS DROP
STORAGE;
truncate table MHAPP.ELE01_TEMPCON_DTL
DROP STORAGE;
truncate table MHAPP.ELE01_TEMPCON_KEY
DROP STORAGE;
truncate table MHAPP.ELE01_TEMP DROP
STORAGE;
truncate table MHAPP.ELE01_FA DROP STORAGE;
truncate table MHAPP.ELE01_FR DROP
STORAGE;
truncate table MHAPP.ELE01_FV DROP
STORAGE;
truncate table MHAPP.ELE01_FK DROP
STORAGE;
truncate table MHAPP.ELE01_WGA DROP
STORAGE;
truncate table MHAPP.ELE01_SASP DROP
STORAGE;
truncate table MHAPP.ELE01_FCFT DROP
STORAGE;
truncate table MHAPP.ELE01_WINDCON_DTL
DROP STORAGE;
truncate table MHAPP.ELE01_WINDCON_KEY
DROP STORAGE;
truncate table MHAPP.ELE01_WIND DROP
STORAGE;
truncate table MHAPP.ELE01_AIREP DROP
STORAGE;
truncate table MHAPP.ELE01_SURF DROP
STORAGE;
truncate table MHAPP.ELE01_SX DROP
STORAGE;
truncate table MHAPP.ELE01_TYPH DROP
STORAGE;
truncate table MHAPP.ELE01_AUTOSTATION
DROP STORAGE;
truncate table MHAPP.RPT01_WARN DROP
STORAGE;
truncate table MHAPP.RPT01_WCV DROP
STORAGE;
truncate table MHAPP.RPT01_ABBR DROP
STORAGE;
truncate table MHAPP.RPT01_CAC DROP
STORAGE;
truncate table MHAPP.RPT01_ERR DROP
STORAGE;
truncate table MHAPP.RPT01_MSG DROP
STORAGE;
truncate table MHAPP.RPT01_UA DROP
STORAGE;
truncate table MHAPP.DATA01_BUFR DROP STORAGE;
truncate table MHAPP.DATA01_GRIB DROP
STORAGE;
truncate table MHAPP.BULL01_ALL DROP
STORAGE;
2、如果不行,那就手工expdp
导出dump
文件,然后分析
建立目录,强制修改权限,防止无法写入的情况出现
mkdir -p
/home/database/data/backup/20191029/IMAGE01_PROG/
chmod 755
/home/database/data/backup/20191029/IMAGE01_PROG/
create or
replace directory dirname as
'/home/database/data/backup/20191029/IMAGE01_PROG/';
手工导出
expdp
userdbs/userdbs tables=MHAPP.IMAGE01_RADAR directory=dirname filesize=800M
dumpfile=IMAGE01_RADAR.%U.dmp logfile=IMAGE01_RADAR.log
可以手工导出,证明跟导出没有关系
3、观察发现,BULL01_ALL的导出zip文件大小为0
经排查后为mhdbs
用户无法读取backup
目录下oracle
导出的dmp文件,oracle导出的dmp
文件权限为oracle:asmadmin
把mhdbs
用户加入asmadmin
组就解决了
精选留言