Method and system for online backup of database

A database and backup technology, which is applied in the direction of data error detection, electrical digital data processing, and special data processing applications, can solve the problems of users' normal business impact, improve backup efficiency, and reduce occupied space. Effect

Inactive Publication Date: 2011-04-13
UNITED INFORMATION TECH +1
View PDF3 Cites 33 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, it will also have a certain

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 system for online backup of database
  • Method and system for online backup of database
  • Method and system for online backup of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] The following takes the backup of Oracle database as an example to elaborate on the technical solution of the present invention.

[0038] In order to realize the operation of the storage array and the operation of the Oracle database, the solution of the present invention needs to implement an intermediate agent module, the main work of the agent module is to generate a snapshot of the source logical volume where the database is located, and in the process of generating the snapshot Control the related operations of the database.

[0039] Among them, the proxy module needs to operate on the following files of the database:

[0040] 1. Control file: It stores information describing the physical structure of the database in binary form.

[0041] 2. Online redo log files: Each database has two or more sets of redo log files. The main function of the redo log is to record all changes in the data. Recovery from a crash.

[0042] 3. Archived log file: The archived log file...

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 utility model provides a system for online backup of a database, comprising a database server, a storage array, a backup server and a tape library, wherein the database server is used for operating a database, and using a logic volume of the storage array to store the data of the database; an instruction for carrying out snapshot generation on the logic volume called by the database server is sent to the storage array according to a command for carrying out backup operation on the database from the backup server; the backup server is used for connecting to the database server, pausing input and output of the database on the database server to a storage system, and sending a command for carrying out database backup operation on the database server; mapping information is added to a snapshot volume generated by the storage array, the snapshot volume is loaded according to the mapping information, and the data of the snapshot volume is moved to the tape library; and the storage array is used for carrying out snapshot operation on the logic volume called by the database server according to the instruction from the backup server so as to generate the snapshot volume.

Description

technical field [0001] The invention relates to the technical field of computer data storage, in particular to a database online backup method and system. Background technique [0002] Traditional file copy-based backup usually requires the application to suspend its operation, then start copying data, and resume the application after the copy is complete. This traditional backup method is not suitable for applications that need to ensure business continuity. At the same time, under the traditional backup method, when the amount of backup data is large, the time to copy data is generally longer, so the backup window time will also be very long, which will seriously affect the normal operation of the business system. Therefore, in the business that needs continuous operation In the system, this traditional backup method is not feasible. [0003] With the improvement of storage application requirements, users need online data protection. Snapshot (Snapshot) is one of the effe...

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): G06F17/30G06F11/14
Inventor 赵胜志
Owner UNITED INFORMATION TECH
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