MHDBS 民航气象数据库子系统无法归档问题排查

一般这个情况主要出现在 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组就解决了