Database of Migration and Replication with Oracle Golden Gate
Journal: Communication and Information Technology Journal (Vol.8, No. 2)Publication Date: 2014-10-29
Authors : Suharjito; Raymond Bahana; Ida Ratna;
Page : 62-67
Keywords : Analysis Oracle Golden Gate Migration Replication Bi-Directional INTRODUCTION In this globalization era; business is developing very rapidly and more competitive. As with this business development; information technology is also expected to devel;
Abstract
The main goal of this research is to analyze and design a database configuration of migration and replication in PT Metro Batavia. Research methodologies used in this research are data collecting, analysis and design model. Data collecting method is conducted with library research and direct survey in the company. Analysis method is conducted by analyzing hangar system, migration and reflection process and the available problems. Design method is conducted by designing a prototype for migration process with the implementation of Oracle SQL Developer and replication process with implementation of Oracle Golden Gate. The result of this research is a prototype for configuration of migration and replication process by using Oracle Golden Gate, which can produce two sets of identical data for the purpose of backup and recovery, and also design a simple tool that is expected to help active-active or active-passive replication process. The conclusion of this research is migration process of MySQL database to Oracle database by using Oracle Golden Gate hasnt been conducted, because Oracle Golden Gate still has bug related to binary log, so database of migration is conducted by using Oracle Golden Gate. However, replication of bi-directional in between database of Oracle by using Oracle SQL Developer can guarantee data availability and reduce work burden from primary database.
Other Latest Articles
- Image of the city through the eyes of inhabitants
- The government adjusting of factors of pricing at the housing market of regions of Ukraine in the context of decline of cost of building
- Extreme temperature regulation in the automation process in the production of biogas methane tanks
- Selection of the optimal solutions of thermal insulation of outdoor enclosing structure
- TRAUMATIC COMPLICATIONS AFTER HERNIOPLASTY AND THE STUDY OF MACROPHAGE TRANSFORMATION OF MONONUCLEAR CELLS IN LEUCOCYTE CULTURE OF PATIENT’S BLOOD
Last modified: 2015-11-17 11:46:22