A method and device for database recovery

A database and device technology, applied in the field of database recovery, can solve the problems of inability to fully recover database data, inability to recover completely, and loss of user data.

Active Publication Date: 2019-05-28
久盈世纪(北京)科技有限公司
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the prior art, the method of using the database archive log (Archive Log) for recovery can restore the database, but it can only restore the historical database data corresponding to the specified archive log time point, and cannot completely restore the data stored in the online redo log (Online Redo Log). The database data at the latest time point of the backup, and the recovery method using online redo logs in the prior art can only restore the data at the latest time point of the database, but cannot satisfy the recovery at any point in time, resulting in the loss of some data lost
Therefore, no matter whether using archived logs or online redo logs for recovery, all data information of the entire database cannot be completely recovered, which will lead to loss of user data and incomplete database data, which cannot meet the requirements of recovery to any time. point of demand

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A method and device for database recovery
  • A method and device for database recovery
  • A method and device for database recovery

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] The application will be described in further detail below in conjunction with the accompanying drawings.

[0026] In a typical configuration of the present application, the terminal, the device serving the network and the trusted party all include one or more processors (CPUs), input / output interfaces, network interfaces and memory.

[0027] Memory may include non-permanent storage in computer readable media, in the form of random access memory (RAM) and / or nonvolatile memory such as read only memory (ROM) or flash RAM. Memory is an example of computer readable media.

[0028] Computer-readable media, including both permanent and non-permanent, removable and non-removable media, can be implemented by any method or technology for storage of information. Information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random acce...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

An objective of the invention is to provide a method and a device used for database recovery. Specifically, the method comprises: obtaining a database on-line redo log and a database archiving log; according to the database on-line redo log, performing database recovery operation; obtaining the database archiving log generated in the database recovery operation; updating the database archiving log, and according to the updated database archiving log, performing database recovery operation on assigned point-in-time. Compared with the prior art, the method recovers a database through the on-line redo log, to obtain an archiving log corresponding to the on-line redo log in recent transaction operation time, so as to update all archiving logs, and make the archiving logs cover all point-in-time in database historical operation, and the updated archiving logs are used to recover the database, so that the database can be recovered to any point-in-time. The method completely reserves database data, so that data of the database is completely protected.

Description

technical field [0001] The present application relates to the computer field, and in particular to a technology for database recovery. Background technique [0002] With the advent of the era of big data, the amount of data usage is increasing exponentially, and there are higher and higher requirements for data backup and recovery, as well as higher and higher requirements for the integrity of data recovery and the time of recovery points. In the prior art, the method of using the database archive log (Archive Log) for recovery can restore the database, but it can only restore the historical database data corresponding to the specified archive log time point, and cannot completely restore the data stored in the online redo log (Online Redo Log). The database data at the latest time point of the backup, and the recovery method using online redo logs in the prior art can only restore the data at the latest time point of the database, but cannot satisfy the recovery at any poin...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F11/14
CPCG06F11/1469G06F11/1471
Inventor 任养超李天泽李玉亮
Owner 久盈世纪(北京)科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap