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

Continuous data protection system and method based on Oracle log analysis

A continuous data protection and log technology, which is applied in the direction of data error detection, database update, structured data retrieval, etc., can solve the problem of inability to guarantee the real-time consistency and availability of Oracle database data, RPO and RTO bias problems such as large size and poor database consistency, to achieve the effect of ensuring real-time consistency and availability

Inactive Publication Date: 2020-07-17
EISOO SOFTWARE
View PDF4 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This backup method is only applicable to data protection scenarios that do not have high requirements for RPO (Recovery Point Object) and RTO (Recovery Time Objective). Big problem, and then can not guarantee the real-time consistency and availability of Oracle database data
In addition, part of the data protection mode of the Oracle database adopts the method of disk volume replication. However, this method is to protect the entire data volume, only copy the data on the disk, and cannot process the cached data, and there will be problems such as poor database consistency.

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0059] The present invention will be described in detail below in conjunction with the accompanying drawings and specific embodiments. Apparently, the described embodiments are some, not all, embodiments of the present invention. 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.

[0060] The present invention proposes a continuous data protection technology based on parsing Oracle logs. Through real-time monitoring of log data changes in the production environment, logs with data changes are captured and parsed to generate SQL statements, which are transmitted to the disaster recovery environment through the network. The backup environment loads and executes SQL statements after receiving them. Due to the real-time capture, analysis and synchronization of logs, RPO and RTO are close to 0, ensuring the real-tim...

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 analysis, which are used for protecting Oracle data and meeting the requirement scene that low RPO of a client is consistent with that of a database, and the system comprises a server and a console used as real-time copying software; the client Agent is used as an agent client for copying the software at the source end and the target end in real time; the source end Source is used as a production environment end of the user; the target end Target is used as a disaster recovery backup environment end ofthe user; the Database is used for storing the actual data of the source end Source database and the target end Target database; and the Redo log file or archived log is used for storing all operationrecords and changed data of database change. Compared with the prior art, the method has the advantages that the RPO and the RTO are close to 0, and the real-time consistency and availability of Oracle database data are guaranteed.

Description

technical field [0001] The invention relates to a data protection method, in particular to a continuous data protection system and method based on analyzing Oracle logs. Background technique [0002] The earliest Oracle database backup was offline backup, also known as cold backup. Before the backup can start, the database must be completely shut down, and every file used by the database needs to be backed up. Oracle Database Release 6 introduced the concept of hot backup. This means that the database can remain open and process transactions while the backup is being performed, but 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, perform an OS file copy backup, and finally take the tablespaces out of backup mode. [0003] Version 8 of the Oracle database introduced Oracle Recovery Manager, or RMAN, as the recomme...

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): G06F16/23G06F16/242G06F16/2455G06F16/27G06F11/14
CPCG06F11/1464G06F16/2365G06F16/2433G06F16/24552G06F16/273
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