Aplikasi Migrasi Database dan Replikasi Bi-Directional

Authors

  • Michael Yoseph Ricky Bina Nusantara University

DOI:

https://doi.org/10.21512/comtech.v2i2.2828

Keywords:

database migration, Oracle Golden Gate, bi-directional replication, database

Abstract

This study aims to analyze and design a migration and replication configurations in an enterprise using several methods such as literary study and direc survey to the company; analysis on hangar systems, process migration and replication as well as existing problems; and a prototype design for migration process implementated with Oracle SQL Developer and replication process implementated with Oracle GoldenGate. The study resluts ini a prototype for migration and replication configuration processes using Oracle's Golden Gate which can produce two sets of identical data for backup and recovery. Also a simple tool is designed to assist active-active replication process as well as active-passive one. The migration process from MySQL database to Oracle database using Oracle GoldenGate can not be done because GoldenGate Oracle has bugs related to the binary log, so database migration is done using Oracle SQL Developer. However, bi-directional replication between Oracle database using Oracle GoldenGate can ensure data availability and reduce the workload of primary database.

 

References

Hart, M., Jesse S. (2004). Oracle Database 10g: High Availablity with RAC Flashback & Data Guard. California: McGraw-Hill Osborne.

Howard, G., Irving, S. M., Sceales, A. M., Sauvage, A. M. F. (2010). Error prevention for data replication. Diakses dari http://www.ipo.gov.uk/p-find-publication-getPDF.pdf?PatentNo=GB2468742&DocType=A&JournalNumber=6331.

Morales, Tony. (2002). Oracle9i Database Migration, Release 2 (9.2). Diakses dari http://download.oracle.com/docs/cd/B10501_01/server.920/a96530.pdf

Munoz, J., Syracuse, N. (2000). Replication and Migration. Diakses dari https://www.ietf.org/proceedings/49/slides/NFSV4-4.pdf.

Viv, S. (2010). Oracle® Database High Availability Overview 11g Release 1 (11.1). diakses dari http://isu.ifmo.ru/docs/doc112/server.112/e10804.pdf.

Zeis, C., Ruel, C., Wessler, M. (2009). Oracle® 11g For Dummies. Indianapolis: Wiley Publishing.

Downloads

Published

2011-12-01

Issue

Section

Articles
Abstract 209  .
PDF downloaded 100  .