CAJ | 학술논문

近年来，随着110指挥中心的业务发展，接、处警数据量急剧上升，老旧数据库服务器已经不满足实际工作需要，亟需将大量数据迁移到一台高性能数据库服务器上，同时也要满足数据不丢失、操作简单、停机时间短等实际要求。Oracle GoldenGate(OGG)是一种基于日志的结构化数据复制软件，它通过解析源数据库在线日志或归档日志获得数据的增删改变化，再将这些变化应用到目标数据库，实现源数据库与目标数据库同步。
근년래，수착110지휘중심적업무발전，접、처경수거량급극상승，로구수거고복무기이경불만족실제공작수요，극수장대량수거천이도일태고성능수거고복무기상，동시야요만족수거불주실、조작간단、정궤시간단등실제요구。Oracle GoldenGate(OGG)시일충기우일지적결구화수거복제연건，타통과해석원수거고재선일지혹귀당일지획득수거적증산개변화，재장저사변화응용도목표수거고，실현원수거고여목표수거고동보。
With the business development of 110 command center, the number of alarms in the alarm center increas- ed rapidly in recent years. As a result, the old database server could not meet the needs of practical work. Therefore, a high-performance database server is highly expected to transfer these massive data. Meanwhile, the new server should be able to prevent data from missing. Additionally, easy operation and short downtime are also needed for the new serv-er. Oracle Golden Gate is a kind of structurized data-copy software which is used based on log. By analyzing the addi-tion, cancelation and alteration of the data source online or on archive logs, OGG automatically sends these changes to the target database, thus synchronizing the source database and the target database.