Oracle数据库迁移方法研究及在河北地球物理台网的应用  

Research on Oracle Database Migration Method and Its Application in Hebei Geophysical Network

作　　者：王加敏 马广庆[1,2] 赵鹏 李永庆 WANG Jia-min;MA Guang-qing;ZHAO Peng;LI Yong-qing(Hebei Earthquake Agency,Shijiazhuang,Hebei 225000,China;Hebei Hongshan National Observatory on Thick Sediments and Seismic Hazards,Xingtai,Hebei 055350,China)

机构地区：[1]河北省地震局,河北石家庄225000 [2]河北红山巨厚沉积与地震灾害国家野外科学观测研究站,河北邢台055350

出　　处：《山西地震》2022年第3期52-56,共5页Earthquake Research in Shanxi

基　　金：河北省地震科技星火计划项目(DZ2021121800003);河北省防震减灾信息服务平台(2018-130000-74-01-001627)。

摘　　要：地球物理Oracle数据库安全、稳定的运行是开展地震数据分析研究的基础,服务器出现系统故障会影响数据的汇集和处理。在台站节点无备用数据库时,出现故障容易造成数据丢失。数据迁移是数据库备份与恢复的过程。基于Oracle的地球物理节点数据库备份主要有冷备份、在线热备份和逻辑备份三种方式。该文结合地球物理台网的日常工作,介绍几种不同方式数据迁移的实例。结果表明,逻辑备份和物理备份的有效结合可提高地球物理台网Oracle数据库运行的稳定性。The safe and stable operation of geophysical Oracle database is the basis for seismic data analysis and research.System failure of the server will affect data collection and processing.There is no standby database at the station node,and data loss is easily caused by failure.Data migration is the process of database backup and recovery.The database backup of geophysical nodes based on Oracle mainly includes cold backup,online hot backup and logical backup.Combined with the daily work of geophysical network,this paper introduces several examples of data migration in different ways.The results show that the effective combination of logical backup and physical backup can improve the stability of Oracle database in geophysical network.

关 键 词：数据迁移 ORACLE数据库 冷备份 Exp/Imp 数据泵 

分 类 号：P315-39[天文地球—地震学]