Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data backup method, device, apparatus, and storage medium

A data backup and backup technology, applied in the field of database processing, can solve the problem of occupying the memory resources of the database host

Active Publication Date: 2019-03-29
SHANGHAI DAMENG DATABASE
View PDF14 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present invention provides a data backup method, device, equipment and storage medium to solve the problem in the prior art that each online backup needs to occupy the memory resources of the database host. Under the premise of ensuring the normal operation of the online backup , reducing the impact on the execution efficiency of the database business

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
  • Data backup method, device, apparatus, and storage medium
  • Data backup method, device, apparatus, and storage medium
  • Data backup method, device, apparatus, and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0031] Figure 1A It is a flow chart of a data backup method provided by Embodiment 1 of the present invention, and this embodiment is applicable to any backup computer capable of realizing database functions. A data backup method provided in this embodiment can be executed by the data backup device provided in the embodiment of the present invention, the device can be realized by means of software and / or hardware, and integrated in the device that executes the method, in this embodiment In the example, the device for executing the method can be any intelligent terminal capable of database application functions such as a tablet computer, a desktop computer, and a notebook. Specifically, refer to Figure 1A , the method may include the following steps:

[0032] S110. Search for the target checkpoint identifier in the backup database file, and send the target checkpoint identifier to the database host.

[0033] Wherein, the backup database file is received from the database hos...

Embodiment 2

[0050] figure 2 It is a flowchart of a data backup method provided by Embodiment 2 of the present invention. This embodiment is optimized on the basis of the foregoing embodiments. Optionally, this embodiment mainly describes in detail the specific process of modifying the backup database file and finding the target checkpoint identifier in the backup database file. optional, see figure 2 , this embodiment may specifically include the following steps:

[0051] S210. Receive a backup database file from the database host.

[0052] Specifically, in this embodiment, when the data information in the database host needs to be backed up, it is first necessary to obtain the data to be backed up on the database host, that is, the backup database file in this embodiment, and perform this backup on the backup computer Previously, the backup database file needed for this backup was received in advance from the database host. Optionally, in this embodiment, the backup database file ...

Embodiment 3

[0066] Figure 3A It is a scenario block diagram of a specific scenario applicable to the data backup method provided by Embodiment 3 of the present invention. Specifically, in this embodiment, the source database in the database host 10 needs to be backed up to the corresponding backup computer 20. At this time, the user copies the backup database files of the source database in the database host 10 to the corresponding positions of the backup computer 20 in sequence. In this embodiment, the backup computer 20 performs a backup recovery process after receiving the backup database file copied from the database host 10 in detail.

[0067] Specifically, such as Figure 3B As shown, the backup computer 20 receives the backup database file copied from the database host 10, and according to the log position modification instruction input by the user, changes the storage location of the online log file and data file stored in the control file and configuration file in the backup da...

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

The embodiment of the invention discloses a data backup method, device, and apparatus and a storage medium. The method comprises the following steps: searching a target checkpoint identifier in a backup database file, and sending the target checkpoint identifier to a database host, wherein the backup database file is received from the database host in advance; receiving a transaction log after thetarget checkpoint identification from the database host; updating the backup database file according to the transaction log to obtain a new backup database file. The technical proposal provided by the embodiment of the invention, on the basis of ensuring the consistency of the data in the backup local machine and the database host, does not need to occupy the memory resources of the database host, reduces the influence on the execution efficiency of the database service, and improves the reliability of the data backup.

Description

technical field [0001] The embodiments of the present invention relate to the field of database processing, in particular to a data backup method, device, equipment and storage medium. Background technique [0002] With the rapid development of database technology, the security requirements for all kinds of data information stored in the database host are getting higher and higher. In order to prevent data loss or damage caused by the failure of the database host, data backup will be performed on the data information. [0003] When the database host uses online backup and the database is working normally, it will perform normal database business operations. At this time, the existing online backup will first write the data to be backed up to the local backup set of the database host, and then back it up locally. After the set is written, copy the backup set to the target machine, that is, the target standby machine used to store the content of the backup database. At this ti...

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
IPC IPC(8): G06F11/14G06F16/27
CPCG06F11/1448G06F11/1469G06F11/1471
Inventor 沈宁王海龙薛慧
Owner SHANGHAI DAMENG DATABASE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com