Disaster Preparedness Backend Database to Read and Write Separation Technology Research

Abstract

GoldenGate and Active DataGuard are both products of Oracle. GoldenGate can realize data synchronization with production database at the second level. And the same time it can realize writing data on both ends at the same time. Active DataGuard not only can realize the data real-time synchronization. Therefore, to combine GoldenGate and Active DataGuard technology not only can realize the disaster of the production data, but also can realize separation of disaster preparedness back-end database, reading and writing, and improve the business processing ability of the system as a whole. At the same time it can make full use of the computing power of the backend resources to reduce the cost.