Method for realizing high-efficiency rapid backup of database

Abstract

The invention provides a method for realizing high-efficiency rapid backup of a database, which is characterized by triggering a writing-log daemon progress of the database to start when the database sends out a service update request, starting a synchronous writing-log daemon progress during writing a local rework log to write a backup rework log and forming archived log data at the backup end. By the archived log analysis at the backup end, the database required to be backed up can be identified and an increment marker file can be generated. A system backup daemon progress reads the increment marker file for backing up the increment and generates an increment backup gather. The method can realize the immediate backup of the database system, rapid increment backup of the database system and key function of backup synthesis, thereby achieving high-efficiency rapid backup. The method is suitable for database systems of Oracle, Microsoft SQL Server, Mysql and the like.

Description

technical field [0001] The invention relates to the field of database applications, in particular to a method for realizing efficient and fast backup of databases. technical background [0002] With years of IT system construction in China, all walks of life have basically established applicable IT information systems to support daily business operations. As the core system of IT information system, the database system stores core data and basic business logic, and has been widely recognized by IT information managers and database administrators in terms of business system reliability and business data integrity. focus on. [0003] In some industries, users have higher requirements for databases. For example, the IT business system of a telecommunications company is the cornerstone of many businesses of the telecommunications company, and the data stored in the database is the core factor related to the normal development of the business. Data integrity is the basic work ...

AI Technical Summary

Problems solved by technology

[0005] 1) The validity of the data backup cannot be confirmed, and the validity of the backed up data cannot be verified;

[0006] 2) The integrity of the data cannot be guaranteed. Whether it is a logical backup or the current physical backup, there is no guarantee that data will not be lost when a failure occurs and recovery is performed;

Backups, especially physical backups, often have a relatively large performance impact on the production system, especially IO pressure, due to problems in the formulation of backup scripts or backup strategies;

[0008] 4) Data backup / restore takes a long time

When the network fails, the backup will be interrupted. After the network is restored, the backup cannot continue

When the database is restored, the business system needs to be interrupted, and the recovery time is long, and failures are prone to occur during the recovery process, especially the recovery of logical backups

[0009] So, is there a method that can not only inherit the advantages of the traditional backup method, but also improve the shortcomings of the traditional backup method, and perform database backup efficiently and quickly? This is exactly what the present invention will study

Images