EMIS生产数据库备份方案优化与实施

详细信息

Optimization and implementation of EMIS production database backup scheme

Institute of Computing Technologies, China Academy of Railway Sciences, Beijing 100081, China

摘要: 对EMIS现场数据库常见的故障进行总结,分析了既有数据库备份策略进行数据恢复的优缺点。结合现场信息系统数据库的实际使用情况,对既有数据库备份方案进行了深入的优化研究,制定了一套易于操作、高可用的数据库新备份方案,并在全路动车所完成了实施与应用,以提高数据库恢复的完整性和连续性,保证信息系统数据的安全性和稳定性。
- EMIS /
- 数据库 /
- 备份优化 /
- 实时同步
Abstract: This article summarized the common faults of EMIS field database, analyzed the advantages and disadvantages of the existing database backup strategy. According to the actual usage of the EMIS field database, the article optimized and studied the existing database backup scheme in-depth, made a set of database backup scheme which was easy to operate and high availability. The scheme was implemented and applied to all of the EMU depots for improving the integrity and continuity of database recovery, ensuring the security and stability of information system data.
- EMIS /
- database /
- backup optimization /
- real-time synchronous

[1]	林树泽,卢芬, 杨亚琦.Oracle DBA高可用、备份恢复与性能优化[M].北京:清华大学出版社,2015.
[2]	杨建荣. Oracle DBA工作笔记[M].北京:中国铁道出版社,2016.
[3]	盖国强. 循序渐进Oracle:数据库管理、优化与备份恢复[M]. 北京:人民邮电出版社,2011.
[4]	柳遵梁,潘敏君,应以峰.Oracle数据库性能优化方法论和最佳实践[M]. 北京:机械工业出版社,2016.
[5]	潘传迪. 基于DataGuard 和RMAN 的Oracle 数据库容灾方案[J].医院管理论坛,2014 (1):51-54.
[6]	袁文. 使用DATA GUARD建立数据库备份系统[J].中国电子商务,2013 (21):37.