Method for recovering backup of real-time database

Abstract

The invention discloses a method for recovering a backup of a real-time database and belongs to the field of application of the real-time database in an information-based system. The method comprises the steps as follow: offline performing total backup and recovering under the state that the database stops operating, online performing total backup and recovering under the state that the database is operated normally, and performing incremental backup and recovering under the state that the database is operated normally. The method achieves the condition of safe, stable and efficient data backup and data recovery of a real-time database system in a production environment under the premise that an upper application is not influenced. The method achieves a backup tool program to support total backup of the real-time database under the offline state and the online state, and simultaneously supports incremental data backup of the database under online state, and achieves a recovery tool program to support to settle and recover the backup file to ensure validity of the backup. By using the manner of backing up a file block, the method improves backup efficiency and greatly reduces influence of a backup procedure on the real-time database and the application thereof.

Description

technical field [0001] The invention belongs to the application field of a real-time database in an information system, and in particular relates to a method for backing up and restoring data in a real-time database of an information system. Background technique [0002] With the continuous improvement of production system informatization and automation level, the continuous development and wide application of database technology, in order to ensure the 7×24 uninterrupted safe production and operation of the comprehensive business information real-time processing system (referred to as the comprehensive business system), usually in the system The application layer and the database layer use software and hardware fault-tolerant technology to improve the security and stability of the integrated business system. [0003] At the system application level, fault-tolerant technologies such as disk array machine, dual-system hot backup, and streaming backup are common. From the syst...

AI Technical Summary

Problems solved by technology

However, most of the existing logical backup methods are for relational databases, and it is difficult to satisfy the efficiency of backup and recovery of large-scale archive stream data. For real-time databases that are good at processing large-scale archive stream data, the backup and recovery methods are currently Relatively lacking, the main research results focus on checkpoint technology, log records, protocols, reinstallation algorithms, etc., but most of them are applicable to in-memory databases

Images