Oracle multichannel parallel backup and recovery method

Abstract

The invention relates to an Oracle multichannel parallel backup and recovery method. The method comprises the following steps: establishing a plurality of channels for sending Oracle data blocks through a media management library; opening a plurality of threads through a backup software client to be paired and connected with the channels; reading the data of a database in parallel through the channels to generate data blocks in a fixed size; sending the data blocks to the backup software client in parallel; receiving the data blocks sent by corresponding channels through the threads of the backup software client; and sending the data blocks onto a remote storage. Compared with the prior art, the Oracle multichannel parallel backup and recovery method has the advantage that parallel data transmission is utilized to improve the data transmission efficiency so that the data backup and recovery time under Oracle big data background is effectively shortened.

Description

technical field [0001] The invention relates to the field of structured data protection, in particular to an Oracle multi-channel parallel backup and recovery method. 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. It can be seen that Oracle, the king of databases, has the most users in the world. At present, the database deployed in many industries in my country is also Oracle. With the rapid development of information technology in my country and the longer and longer use time, the data volume of Oracle database users is increasing, such as the account system of the public security department and the subscription system of the railway departm...

AI Technical Summary

Problems solved by technology

When the storage performance of the back-end database is very strong, the high-performance storage IOPS cannot be fully utilized, the efficiency is low, and the time consumed for backup and recovery is very long, especially when the user’s Oracle database is damaged, it cannot be recovered quickly and in time , poor data protection

[0004] In the case of traditional serial backup, when the amount of data is not large, we can improve the backup performance by increasing the transmission speed and storage read and write performance, but when the data grows exponentially, it is obvious that the exponential growth of the backup time and the amount of data If the growth index is consistent, then it is impossible to achieve high reliability data protection. When the data reaches the TB level, the traditional backup time will exceed 24 hours, which means that if there is a problem with the data, we cannot guarantee 24 hours before that. The integrity of the data, and there is no guarantee that the data will be completely recovered within 24 hours

Images