Logic backup method and logic backup system for database

Abstract

The invention provides a logic backup method and a logic backup system for a database. The method comprises the following steps: a network segment centralized deployment node sends logic backup requests to a plurality of nodes of a production server; the nodes of the production server achieve logic backup of production data according to the logic backup requests so as to obtain backup data; the production server sends operation information and backup logs, which are generated in the logic backup process, to the network segment centralized deployment node; the network segment centralized node collects a plurality of backup logs to generate log information; a center node grabs the log information and the operation information on the network segment centralized deployment node; the center node analyzes the log information to obtain analysis result information; and the center node analyzes the operation information to acquire analysis result. The invention solves the difficult technical problems in the prior art that the management of the backup system is decentralized, the quantity of backup operation is large and operation and maintenance are cumbersome.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to database backup technology, specifically a database logic backup method and a logic backup system. Background technique [0002] As the most critical component in the open platform system, the database plays a vital role in daily production activities. Among them, the security of data in the database is the top priority, which is the basic requirement for the healthy and stable operation of the database. For a long time, the database has faced many security problems, especially the logical structure in the database is damaged (such as the table is deleted by mistake). As a kind of destructive failure, the industry has not had a good way to quickly recover data . Once the above data loss occurs in the database, it will cause immeasurable losses to daily production activities and enterprises. [0003] The logical backup of the database is a method of backing up the database ac...

AI Technical Summary

Problems solved by technology

[0005] In order to overcome the technical problems of decentralized backup system management, large parallel backup workload, and cumbersome operation and maintenance in the prior art, the embodiment of the present invention provides a logical backup method and a logical backup system for the database. By adopting the centralized deployment mode, Deploy backup scripts on centralized deployment nodes in the network segment, adopt a unified logical backup strategy for production servers in the same network segment, and store logical backup data on centralized deployment nodes in the network segment. Compared with the original logical backup system, the management is more convenient and the operation and maintenance costs are lower. decrease accordingly

Images