Aplikasi Migrasi Database dan Replikasi Bi-Directional
Keywords:database migration, Oracle Golden Gate, bi-directional replication, database
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.
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.
Authors who publish with this journal agree to the following terms:
a. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License - Share Alike that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
b. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
c. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
All articles published Open Access will be immediately and permanently free for everyone to read and download. We are continuously working with our author communities to select the best choice of license options, currently being defined for this journal as follows: