GoldenGate软件在数据迁移中的应用  

Application of Goldengate in the Data Migration

作　　者：俞凯晟 

机构地区：[1]万达信息股份有限公司

出　　处：《微型电脑应用》2012年第4期47-49,52,共4页Microcomputer Applications

摘　　要：最近成功实施了一项数据迁移工作,对GoldenGate在此次迁移工程中的成功应用有所心得。作为商用软件实施方案,GoldenGate即提供了实施过程的快捷性,也保证了后期维护的便利性。把数据从源端数据库(Oracle9i)迁移到目标端数据库(Oracle11G)只用了短短几天时间,也不影响源端生产系统的正常运行。考虑到部分技术内容的敏感性,故将具体实施单位隐去,就GoldenGate的具体实施方案及经验与各位同行分享。This paper presents recently implemented a data migration project and gained certain insights on the successful application of GoldenGate in the migration. As a commercial software solution, GoldenGate ensures the efficiency of the implementation process and the convenience of later maintenance. It took only a few days in migrating the data from the source database （Oracle 9i） to the target database （Oracle 11G）, while the operation of the production system at the source remained intact. In consideration of the sensitivity of some technical information, the name of the project undertaker is concealed. This article aims to share the detailed information on GoldenGate solution, experience and lessons with other industry professionals.

关 键 词：数据迁移 GOLDENGATE ORACLE9I Oracle11G 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]