CAJ | 학술논문

数据迁移是Oracle数据库管理维护的重要内容。为了解决数据迁移过程中由迁移数据量大、宕机时间长、数据库平台或版本不同等因素造成的迁移失败问题，提出一种类似Prebuilt MV的Trigger数据迁移方法。该方法可以在线迁移百G以上的大型数据库，还可以解决高可用环境中数据迁移难以解决的最短时间切换、跨平台迁移、跨版本迁移等问题。试验结果证实了该方法的有效性。
수거천이시Oracle수거고관리유호적중요내용。위료해결수거천이과정중유천이수거량대、탕궤시간장、수거고평태혹판본불동등인소조성적천이실패문제，제출일충유사Prebuilt MV적Trigger수거천이방법。해방법가이재선천이백G이상적대형수거고，환가이해결고가용배경중수거천이난이해결적최단시간절환、과평태천이、과판본천이등문제。시험결과증실료해방법적유효성。
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 .