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

运维处理 2021-06-21 28℃ 0 0

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

评论 (0)

Top