INCREASING FAULT TOLERANCE IN TRANSACTIONAL DATABASES BY ADDING AN ADDITIONAL SECONDARY DATABASE

Abstract

This article explores the enhancement of fault tolerance in transactional databases through the implementation of an additional secondary database. It highlights the critical importance of data reliability and availability in modern business operations, especially in sectors such as finance and healthcare, which are subject to stringent regulatory requirements. The paper discusses Oracle's database solutions, emphasizing their utility in maintaining high availability and resilience against cyber-attacks and hardware failures. By deploying a backup database and configuring a real-time replication system using triggers, the study demonstrates an effective approach to ensure data consistency and system reliability. Experiments validate the system's capability to seamlessly switch to a backup database and maintain operational continuity during failures, thereby minimizing downtime and data loss. The findings underscore the essential role of robust data management strategies in supporting uninterrupted business processes and maintaining competitive advantages.