一种基于 Prebuilt Trigger 的数据迁移方法

摘要

Data migrating is an important part in Oracle database management and maintenance .This paper proposes a method of data migrating based on Trigger in order to resolve the problems caused by large volume migrating of data , a long time downtime and the different versions and platforms of database .This method supports the migrating online more than a hundred G'database and can resolve the difficulties about the shortest time switch , cross-platform migration , cross-version migration in the high availability environment . The test results verify the effectiveness of the method .%数据迁移是Oracle数据库管理维护的重要内容。为了解决数据迁移过程中由迁移数据量大、宕机时间长、数据库平台或版本不同等因素造成的迁移失败问题，提出一种类似Prebuilt MV的Trigger数据迁移方法。该方法可以在线迁移百G以上的大型数据库，还可以解决高可用环境中数据迁移难以解决的最短时间切换、跨平台迁移、跨版本迁移等问题。试验结果证实了该方法的有效性。