Oracle multichannel parallel backup and recovery method

A recovery method and multi-channel technology, applied in the field of Oracle multi-channel parallel backup and recovery, can solve the problems of poor data protection effect, long time consumption for backup and recovery, and inability to recover quickly and in time, so as to solve the problem of data protection , Improve data throughput and shorten the protection period

CN105045681AInactive Publication Date: 2015-11-11EISOO SOFTWARE
6 Cites 19 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Publication Date
2015-11-11
Estimated Expiration
Not applicable · inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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...

Examples

Embodiment Construction

[0033] The present invention will be described in detail below in conjunction with the accompanying drawings and specific embodiments. This embodiment is carried out on the premise of the technical solution of the present invention, and detailed implementation and specific operation process are given, but the protection scope of the present invention is not limited to the following embodiments.

[0034] By using the media manager, RMAN (Recovery Manager) backs up data to tape or remote storage (hereinafter collectively referred to as remote storage). Media Manager (MediaManager) is provided by a third-party software vendor, and it transfers the data stream in the data block from the RMAN channel process to the corresponding tape.

[0035] The computer system must have the Media Management (MM) client installed to use Media Manager. The media management client can connect to the media management server and transmit data through the network. The Oracle module must also be inst...