Method for triggering Oracle disaster tolerance automatic emergency switching based on fault detection

Abstract

The invention discloses a method for triggering Oracle disaster tolerance automatic emergency switching based on fault detection, and the method comprises the following steps: S1, determining a faultdetection type, formulating an emergency switching direction, and building a decision tree model; S2, carrying out real-time fault detection on each node state of the Oracle disaster recovery architecture to obtain fault information; S3, matching the fault information through a decision tree model, and obtaining and executing a final switching scheme; and S4, verifying the operation state after disaster recovery automatic emergency switching is completed, and confirming a switching result. According to the invention, a safe and stable switching method is provided by taking emergency switchingoperation which is commonly used in a general Oracle disaster recovery architecture and has high importance as a carrier. It is guaranteed that the switching process is automatically completed according to the normal process when a fault occurs, and the operation state after switching is fed back. When a fault occurs, layer-by-layer judgment is carried out through a predefined decision tree mode,the judgment efficiency is improved, and errors of manual judgment are reduced.

Description

technical field [0001] The invention relates to a database disaster recovery switching method, in particular to a method for triggering Oracle disaster recovery automatic emergency switching based on fault detection. Background technique [0002] With the advancement of informatization and the rapid development of business, the requirements for data security and continuity of applications are getting higher and higher. As a mainstream relational database, Oracle database is used in many fields such as large and medium-sized enterprises, financial institutions, and government departments. It is widely used and supports the underlying data of enterprises. Therefore, Oracle's disaster recovery automatic emergency switch is directly related to the data security and application continuity of the user's core business system. [0003] To solve the above problems, Oracle provides a variety of high-availability cluster solutions, such as RAC, Data Guard, MAA, etc., in which all node...

AI Technical Summary

Problems solved by technology

[0004] Currently, there are two types of switchover for Data Guard disaster recovery clusters, namely normal switchover and emergency switchover. Although the two methods deal with different scenarios, the implementation process requires manual participation, and the business needs to be interrupted, so the sustainability of the business cannot be truly guaranteed. , and the switching conditions mainly depend on human experience to judge, the judgment process is not recorded, and the rationality of the switching cannot be evaluated, which is a potential threat to the necessity of the switching operation, data security, and business continuity

Images