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

Consistent data protection and consistent state capture method for Oracle databases

A data protection and database technology, applied in special data processing applications, redundant data error detection in operations, digital data processing, etc. It can solve the problem of immeasurable losses, interruption of Oracle database users' production and business, and use of storage devices. Lifetime data loss and other problems, to reduce maintenance pressure, reduce operational risks, and improve efficiency

Active Publication Date: 2014-12-24
EISOO SOFTWARE
View PDF6 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For example, physical damage and service life of storage devices, sudden power outages, fires, earthquakes, etc. may lead to the loss of data stored on the computer, resulting in the interruption of the production and business of Oracle database users, resulting in immeasurable losses

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
  • Consistent data protection and consistent state capture method for Oracle databases
  • Consistent data protection and consistent state capture method for Oracle databases
  • Consistent data protection and consistent state capture method for Oracle databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0046] According to the introduction in the background technology, as a new development trend in the field of data protection, CDP real-time backup and storage snapshots are increasingly welcomed by users.

[0047] However, writing logs and writing data files in the Oracle database are the two operations that consume the most I / O. After the commit operation with data modification, the logs are synchronously recorded in the redo online log files, but the data will not be written to the disk immediately. , stored in the buffer cache as a dirty block, and the dirty block will be written to the disk only when the checkpoint is triggered to notify the DBWR process to write. as below figure 1 The flow chart of the principle of writing data in Oracle is shown:

[0048] Therefore, when the data has not been written to the disk, the point-in-time snapshot is cut. When the Oracle database is damaged and needs to be restored at this point in time, it will cause the problem that the data...

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 invention relates to a consistent data protection and consistent state capture method for Oracle databases, which includes the following steps: (1) during CDP (Continuous Data Protection) real-time backup and snapshot storage, data are flashed into a disk from a cache, moreover, an Oracle database is set as a quiesced state, and then time buckets of consistency are queried and time point snapshots are cut; (2) after the time point snapshots are cut, the database is set as a non-quiesced state, and the normal Oracle production state is resumed. Compared with the prior art, the method can ensure that any time point of CDP real-time backup and snapshot storage can meet Oracle consistency and can be successfully recovered in order to achieve the goal of continuing business and recovering data loss as precisely as possible under the premise of not affecting the normal operation of the Oracle database of a user; the method can effectively decrease the operational risk of Oracle databases of users, increase efficiency and decrease the pressure of maintenance.

Description

technical field [0001] The invention relates to an Oracle database maintenance technology, in particular to a method for protecting consistent data and capturing a consistent state for the Oracle database. Background technique [0002] According to the 2012 global relational database market survey report released by Gartner, the most authoritative IT research and consulting company, in terms of total software revenue, Oracle continues to occupy the first position with 48.3%, and its revenue share is greater than that of the four largest databases. The sum of its closest competitors (SQL Server, Sybase, DB2, PostgreSQL). It can be seen that Oracle, the king of databases, still has the largest number of users in the world. [0003] The Oracle database is stored in the storage device of the computer, most of which are stored in the hard disk, and a few are stored in the magnetic tape. Due to the physical characteristics of the computer itself, the data stored on it will be un...

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): G06F17/30G06F11/14
CPCG06F11/1448G06F16/2365
Inventor 罗强
Owner EISOO SOFTWARE
Features
  • Generate Ideas
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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