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

Continuous data protection system and method based on Oracle log capture

A technology of data protection and logging, which is applied to data error detection, electrical digital data processing, and response error generation in the direction of redundancy in computing, and can solve problems such as the state that cannot preserve history and the inability to restore historical data. , to achieve the effect of reducing management and operation and maintenance costs

Active Publication Date: 2020-01-17
EISOO SOFTWARE
View PDF6 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The RPO / RTO of this solution is close to 0, which meets the requirements of zero data loss and high data availability. However, since the target end is consistent with the source end in real time, the historical state cannot be preserved, so historical data recovery cannot be achieved.

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
  • Continuous data protection system and method based on Oracle log capture
  • Continuous data protection system and method based on Oracle log capture

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

[0048] The invention effectively solves the problem of too large RPO of periodic Oracle data backup by adopting a continuous data protection technology based on Oracle log capture and combining traditional timing backup. During the gap between full backup and incremental backup, through continuous log backup tasks, the backup client uses self-developed log change block monitoring technology and log change block capture technology to obtain changed data in r...

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 continuous data protection system and method based on Oracle log capture, for protecting Oracle data and simultaneously meeting the requirement scene of low RPO and historical data recovery and storage of customers. The continuous data protection system comprises a storage medium and a logic unit used as backup software data storage, wherein a server serves as a management console of the backup software; the client Agent is used as an agent of the backup software on the client; the database engine Db Engine is used as a core component of the database; the actual datastorage Database of the database is used for sending backup data to the Agent end in the backup stage and receiving recovery data sent by the Agent in the recovery stage; and a log file Redo and an archived log Arch of the database are responsible for storing all operation records and changed data for database change. Compared with the prior art, the continuous data protection system has the advantages that the problem that periodic Oracle data backup RPO is large is effectively solved, and the like.

Description

technical field [0001] The invention relates to a data protection method, in particular to a continuous data protection system and method based on Oracle log capture. Background technique [0002] The earliest Oracle database backups were offline ("cold") backups. The DBA manually performs all database backups in the form of a file OS file copy after shutting down the database. Some enterprise administrators started writing UNIX shell scripts to perform tasks such as shutting down the database, copying files using OS commands, and restarting the database. [0003] Oracle Database Release 6 introduced the concept of online ("hot") backups. This means that the database can remain open and process transactions while the backup is being performed. Note, however, that each tablespace must be placed in a special backup mode before the OS files can be copied. So DBAs modify their scripts to connect to the database, get a list of tablespaces, put each tablespace in backup mode, ...

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/14
CPCG06F11/1448
Inventor 黄开德
Owner EISOO SOFTWARE
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