Method and device used for database recovery

A database and equipment technology, applied in the field of database recovery, can solve problems such as user data loss, data loss, and unsatisfactory recovery

Active Publication Date: 2016-09-21
久盈世纪(北京)科技有限公司
View PDF5 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the prior art, although the recovery method using the database archive log (Archive Log) can restore the database, it can only restore the historical database data corresponding to the specified archive log time point, and cannot completely restore such as the online redo log (Online Redo Log) The backed up database data at the most recent point in time, but in the existing technology, the recovery method using online redo logs can only restore the data at the latest point in time of the database, but cannot satisfy the recovery at any point in time, resulting in partial 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
  • Method and device used for database recovery
  • Method and device used for database recovery
  • Method and device used for database recovery

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

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

[0026] In a typical configuration of this application, the terminal, the equipment of the service network, and the trusted party all include one or more processors (CPU), input / output interfaces, network interfaces, and memory.

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

[0028] Computer-readable media includes permanent and non-permanent, removable and non-removable media, and information storage can be realized by any method or technology. The information can be computer-readable instructions, data structures, program modules, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic rand...

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] This application relates to the computer field, and in particular to a technology for database recovery. Background technique [0002] With the advent of the big data era, 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 for recovery points. Although the recovery method using the database archive log (Archive Log) in the prior art can recover the database, it can only recover the historical database data corresponding to the specified archive log time point, and cannot completely recover, for example, the Online Redo Log. The database data backed up at the latest point in time, while the online redo log recovery method in the prior art can only recover the data at the latest point in time of the database, but cannot meet the recovery at any point in time, resulting in part of the data The ...

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 Applications(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