Data Guard在数据库主备切换中的应用研究  

Application research of Data Guard in database active-standby switchover

作　　者：张小文 肖菊香 魏能强 郭丽 朱润娟 ZHANG Xiaowen;XIAO Juxiang;WEI Nengqiang;GUO Li;ZHU Runjuan(Chengdu Aircraft Industry(Group)Co.,Ltd.,Chengdu 610000,China)

机构地区：[1]成都飞机工业(集团)有限责任公司,四川成都610000

出　　处：《中国高新科技》2022年第14期92-94,100,共4页

摘　　要：针对企业大型核心系统数据库高可用性需求,采用DataGuard数据库容灾解决方案,构建数据库“一主多从”容灾架构,提升数据库可靠性和数据安全性。在此基础上,针对应用系统新功能模块频繁部署的高可靠性的需求,提供与正式库完全一致的数据库测试环境,采用主备切换过程的数据日志复制及闪回技术,实现应用系统测试开发库和冷备库之间的多重角色履职。最后,采用Perl技术,将转换过程流程化、自动化,有效缩短切换时间,避免人工误判,实现数据库故障的秒级切换及冷备库、测试开发库之间的秒级转换。Aiming at the high availability requirements of large-scale core system databases of enterprises,the Data Guard database disaster recovery solution is used to build a database“one master and multiple slaves”disaster recovery architecture to improve database reliability and data security.On this basis,according to the high reliability requirements of the frequent deployment of new functional modules of the application system,a database test environment that is completely consistent with the official library is provided,and the data log replication and flashback technology of the active-standby switching process are used to realize the application system test and development.The multiple roles between the warehouse and the cold standby warehouse are fulfilled.Finally,using Perl technology,the conversion process is streamlined and automated,which effectively shortens the switching time,avoids manual misjudgment,and realizes second-level switching of database failures and second-level switching between cold standby libraries and test development libraries.

关 键 词：ORACLE Data Guard 闪回技术 多角色转换 

分 类 号：TP392[自动化与计算机技术—计算机应用技术]