CN104463014A - Snapshot-based Oracle database protection method - Google Patents
Snapshot-based Oracle database protection method Download PDFInfo
- Publication number
- CN104463014A CN104463014A CN201410756636.9A CN201410756636A CN104463014A CN 104463014 A CN104463014 A CN 104463014A CN 201410756636 A CN201410756636 A CN 201410756636A CN 104463014 A CN104463014 A CN 104463014A
- Authority
- CN
- China
- Prior art keywords
- snapshot
- database
- memory device
- request
- agent
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Security & Cryptography (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Health & Medical Sciences (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a snapshot-based Oracle database protection method. The method includes the steps: a host mounts a storage device and mounts an Oracle database in the storage device; a client transmits a snapshot request to the storage device according to a snapshot task; on receiving the snapshot request, the storage device transmits a corresponding file path to a snapshot agent; the snapshot agent converts the received file path into a VOLID corresponding to a storage volume according to a registration file; on receiving the VOLID, the storage device acquires a corresponding VOLNAME and transmits a Confirm request to the snapshot agent; the snapshot agent judges whether or not a current database instance can be backuped; if yes, a state of the database instance being uniform is retained, after a snapshot operation is executed, the storage device transmits a Remove request to the snapshot agent to remove the state of the database instance being uniform. Compared with the prior art, the method has the advantages of low dependence on the host, high data safety, high reliability and the like.
Description
Technical field
The present invention relates to the cross discipline technical field that computer memory technical and data management technique combine, especially relate to a kind of oracle database guard method based on snapshot.
Background technology
Data protection always is an important research field of computer memory technical and data management technique.At the beginning of the early stage mankind, utilize stone inscription, bamboo let and sheepskin volume record information, data are stored as a kind of knowledge acquisition and just pass on the means exchanged.
Data store from paper technology, the typography, laser printing, the development such as paper tape, floppy disk, hard disk, CD more finally so far, and along with the arrival of information age, the requirement of people to the safety and reliability of data is also more and more higher.Oracle database as one of the client/server of current main flow or the database of B/S architecture, for it provides a kind of safe and reliable data protection mode just to become exigence.
Make a general survey of existing data guard method, substantially can be divided three classes: remote copy, snapshot and clone.
(1) remote copy be exactly the file or blocks of data that will back up by Internet Transmission to long-distance disaster website, realize backup and the protection of data.But the method spended time is many, takies host resource.
(2) snapshot refers to the reflection of data at certain time point, is a complete usable copy of data, provides online date restoring.In addition snapshot also provides a data access channel for storing user, and when former data carry out application on site process, user can access snapshot data, and snapshot can also be utilized to carry out the work such as test.Therefore, all storage systems, no matter senior middle school's low side, as long as be applied to on-line system, so snapshot just becomes an indispensable function.
(3) clone refers to the physical replication of set of source data time point.If snapshot is the shadow of certain moment sizing, so clone is exactly out and out entity, is totally independent of set of source data.Therefore, for snapshot, the storage space of cloning needs one extra carrys out store data block.
The application of these technology in data protection is at present very large to the dependence of main frame, rarely has the protection to market demand.
Summary of the invention
Object of the present invention be exactly in order to overcome above-mentioned prior art exist defect and a kind of oracle database guard method based on snapshot is provided; adopt to store to hold and market demand is protected; solve the problem that prior art is large to host dependency; realize online real-time guard, ensure that the safety and reliability of data.Adopt snapshot agent to monitor database simultaneously, ensure that the consistance of data during snapshot operation.
Object of the present invention can be achieved through the following technical solutions:
Based on an oracle database guard method for snapshot, comprise the following steps:
1) main frame carry memory device, generates corresponding register-file, and installs oracle database on a storage device;
2) client sends snapshot request according to snapshot task to memory device;
3) memory device is according to receiving snapshot request, obtains the database instance needing snapshot, the file path of correspondence is sent to snapshot agent simultaneously;
4) file path received is converted to the volid of corresponding stored volume by snapshot agent according to register-file, and returns to memory device;
5) memory device obtains corresponding volname after receiving volid, and sends confirmation request to acting on behalf of snapshot;
6) snapshot agent judges whether current database example can back up, and if so, then keeps database instance coherency state, performs step 7), if not, then exit;
7) after performing snapshot operation, memory device sends to snapshot agent the request of releasing, removes database instance coherency state.
The mode that described main frame carry memory device adopts comprises iscsi, FC, FCoE or IB.
Described snapshot task is triggered by start button or calls triggering by the plan target cycle.
Described snapshot task comprises needs snapshot database instance name, snapshot to perform frequency, snapshot execution time, reservation record number and task names.
The database instance that one needs snapshot is at least comprised in described snapshot request.
Described step 6) in, according to database positioning, snapshot agent judges whether current database example can back up, when database normally starts under archive mode, current database example can back up.
Compared with prior art, the present invention has following beneficial effect:
1, the dependence to main frame is reduced.Protected data is stored in memory device, guarantees that Host Status does not affect data security and availability.
2, due to the data protection that the present invention is based on snapping technique, do not need extra storage space, in addition, instantaneous rollback can be realized.
3, the present invention is the protection based on application, can realize the synchronous protection of single instance or Multi-instance.
4, when protecting data, other operation of main frame is not affected.Can not because data backup will be carried out terminating operation, avoid the stand-by period of user.
5, the present invention can protect the All Files of oracle database, comprises control documents, Parameter File, journal file and Parameter File etc., ensure that the safety and reliability of data.
6, present invention employs snapshot agent mechanism, conformity provide guarantee for data.
Accompanying drawing explanation
Fig. 1 is theory diagram of the present invention;
Fig. 2 is registered application schematic flow sheet of the present invention;
Fig. 3 is that the present invention creates snapshot flow of task schematic diagram;
Fig. 4 is that the present invention performs snapshot flow of task schematic diagram.
Embodiment
Below in conjunction with the drawings and specific embodiments, the present invention is described in detail.The present embodiment is implemented premised on technical solution of the present invention, give detailed embodiment and concrete operating process, but protection scope of the present invention is not limited to following embodiment.
The present invention is by memory device carry on main frame, and the mode that carry memory device adopts comprises iscsi, FC, FCoE or IB etc.The present embodiment is described for iscsi memory technology, oracle database is built in memory device iscsi rolls up, the dependence to main frame can be reduced like this, realize the safety and integrity of data, create example and table space simultaneously, configuration oracle is archive mode, then installs the snapshot agent being used for database monitoring.
As shown in Figure 1, by memory device 2 carry on main frame 3, first client 1 sends snapshot request to memory device 2, can send request and want again the file path of snapshot after memory device 2 receives request to snapshot agent Agent.Now Agent can utilize iscsi technology, in conjunction with registry information, file path is converted to the volid of storage volume.The true path of the file wanting snapshot determined by memory device 2 according to this volid, and notifies that Agent will carry out snapshot.If data can back up, Agent to be consistent sexual state receiving these information relief data, the consistance of data when guaranteeing snapshot with this.
Before carrying out snapshot operation, need register business main frame.As shown in Figure 2, the one or more application that will protect can be determined according to the host IP address of input or the cluster of selection and type of database.Multi-instance can be had again, by realizing the protection of Multi-instance to the protection of application under this application.
Register rear establishment snapshot task, as shown in Figure 3.First determine task names, task type (snapshot) and retain recovery point.Then select snapshot object, store rear end (memory device) and call rest interface obtains all database instances from selected type on IP main frame or cluster to snapshot agent.User can select which example to carry out snapshot to voluntarily, inputs the information such as frequency, time that snapshot performs simultaneously, completes snapshot task creation.
When user clicks start button or the plan target cycle calls triggering snapshot operation, store rear end and can receive snapshot request, and send database file path to snapshot agent.Snapshot agent returns to and stores rear end after volid file path being converted to the volume that carry gets on.Now store volume just can be determined in rear end title according to the volid of volume, send request to snapshot agent simultaneously, judge whether the database instance in this snapshot task can back up.If can back up, storing end can send request to snapshot agent again, allows database instance be consistent sexual state.After storage rear end executes snapshot operation, send the solicit operation removing coherency state to snapshot agent, complete snapshot.Perform snapshot flow of task as shown in Figure 4:
Step s101, client sends snapshot request according to snapshot task to memory device.
Step s102, memory device, according to receiving snapshot request, obtains the database instance needing snapshot, the file path of correspondence is sent to snapshot agent simultaneously, at least comprise the database instance that needs snapshot in snapshot request.
Step s103, the file path received is converted to the volid of corresponding stored volume by snapshot agent according to register-file, and returns to memory device.
Realize the protection of data, the most important thing is the consistance ensureing data.The present invention is that database provides operation-interface, namely a snapshot agent.Memory device, after receiving the snapshot request from client, first can send request to snapshot agent, and transmits the database file path of wanting snapshot.This file path is the path that client is seen, instead of database true path on a storage device.Therefore must change accordingly, to realize the snapshot to storing data.
Registration table is as a set of control operation system appearance and the file how responding incoming event work.The setting being used to control system and software of depositing in its HKEY_LOCAL_MACHIN root key.The sub-key of HARDWARE/DEVICEMAP under it is used for storage equipment map.Therefore, in the present embodiment, when the storage volume carry of memory device is on main frame, under HARDWARE/DEVICEMAP/Scsi, corresponding register-file will be generated in corresponding TargetId catalogue.Can find by resolving, the information of virtual volume, comprises TargetName and volid, is all stored in the register-file under Target Id catalogue.Therefore only need to find corresponding register-file, just can obtain the volume volid matched.But the technology of existing acquisition iscsi volume information can't obtain its TargetId, can only obtain its TargetName.Therefore need, by TargetName part in contrast register-file, uniquely to determine the volid of corresponding storage volume.
Step s104, memory device obtains the title volname of respective roll after receiving volid.
Step s105, memory device sends confirmation request to acting on behalf of snapshot, according to database positioning, snapshot agent judges whether current database example can back up, if database normally starts under archive mode, then judge that current database example can back up, perform step s106, if not, then exit.
Step s106, keeps database instance coherency state.
Step s107, performs snapshot operation.
Step s108, after snapshot operation, memory device sends to snapshot agent the request of releasing, removes database instance coherency state.
Step s109, writes the result of this execution to database.
Claims (6)
1., based on an oracle database guard method for snapshot, it is characterized in that, comprise the following steps:
1) main frame carry memory device, generates corresponding register-file, and installs oracle database on a storage device;
2) client sends snapshot request according to snapshot task to memory device;
3) memory device is according to receiving snapshot request, obtains the database instance needing snapshot, the file path of correspondence is sent to snapshot agent simultaneously;
4) file path received is converted to the volid of corresponding stored volume by snapshot agent according to register-file, and returns to memory device;
5) memory device obtains corresponding volname after receiving volid, and sends confirmation request to acting on behalf of snapshot;
6) snapshot agent judges whether current database example can back up, and if so, then keeps database instance coherency state, performs step 7), if not, then exit;
7) after performing snapshot operation, memory device sends to snapshot agent the request of releasing, removes database instance coherency state.
2. the oracle database guard method based on snapshot according to claim 1, is characterized in that, the mode that described main frame carry memory device adopts comprises iscsi, FC, FCoE or IB.
3. the oracle database guard method based on snapshot according to claim 1, is characterized in that, described snapshot task is triggered by start button or calls triggering by the plan target cycle.
4. the oracle database guard method based on snapshot according to claim 1 or 3, is characterized in that, described snapshot task comprises needs snapshot database instance name, snapshot to perform frequency, snapshot execution time, reservation record number and task names.
5. the oracle database guard method based on snapshot according to claim 1, is characterized in that, at least comprises the database instance that needs snapshot in described snapshot request.
6. the oracle database guard method based on snapshot according to claim 1; it is characterized in that; described step 6) in; according to database positioning, snapshot agent judges whether current database example can back up; when database normally starts under archive mode, current database example can back up.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410756636.9A CN104463014B (en) | 2014-12-10 | 2014-12-10 | A kind of oracle database guard method based on snapshot |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410756636.9A CN104463014B (en) | 2014-12-10 | 2014-12-10 | A kind of oracle database guard method based on snapshot |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104463014A true CN104463014A (en) | 2015-03-25 |
| CN104463014B CN104463014B (en) | 2017-06-09 |
Family
ID=52909034
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410756636.9A Active CN104463014B (en) | 2014-12-10 | 2014-12-10 | A kind of oracle database guard method based on snapshot |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104463014B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106021020A (en) * | 2016-05-12 | 2016-10-12 | 中国工商银行股份有限公司 | Dual-live data site application data mounting method and apparatus |
| CN108717462A (en) * | 2018-05-28 | 2018-10-30 | 郑州云海信息技术有限公司 | A kind of database snapshot verification method and system |
| CN109597707A (en) * | 2018-10-25 | 2019-04-09 | 平安科技（深圳）有限公司 | Clone volume data copying method, device and computer readable storage medium |
| CN110990379A (en) * | 2019-11-24 | 2020-04-10 | 北京浪潮数据技术有限公司 | DB2 database disaster tolerance and control method and system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1786959A (en) * | 2004-12-08 | 2006-06-14 | 国际商业机器公司 | Method for optimizing a snapshot operation on a file basis |
| CN102012947A (en) * | 2010-12-16 | 2011-04-13 | 创新科存储技术有限公司 | Method and system for online backup of database |
| CN102419758A (en) * | 2010-09-28 | 2012-04-18 | 金蝶软件（中国）有限公司 | Data processing system and method |
| US20120110338A1 (en) * | 2010-10-27 | 2012-05-03 | Max Planck Gesellschaft Zur Foerderung Der Wissenschaften | Protecting the Integrity and Privacy of Data with Storage Leases |
| CN103765406A (en) * | 2011-06-30 | 2014-04-30 | 亚马逊科技公司 | Methods and apparatus for remotely updating executing processes |
-
2014
- 2014-12-10 CN CN201410756636.9A patent/CN104463014B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1786959A (en) * | 2004-12-08 | 2006-06-14 | 国际商业机器公司 | Method for optimizing a snapshot operation on a file basis |
| CN102419758A (en) * | 2010-09-28 | 2012-04-18 | 金蝶软件（中国）有限公司 | Data processing system and method |
| US20120110338A1 (en) * | 2010-10-27 | 2012-05-03 | Max Planck Gesellschaft Zur Foerderung Der Wissenschaften | Protecting the Integrity and Privacy of Data with Storage Leases |
| CN102012947A (en) * | 2010-12-16 | 2011-04-13 | 创新科存储技术有限公司 | Method and system for online backup of database |
| CN103765406A (en) * | 2011-06-30 | 2014-04-30 | 亚马逊科技公司 | Methods and apparatus for remotely updating executing processes |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106021020A (en) * | 2016-05-12 | 2016-10-12 | 中国工商银行股份有限公司 | Dual-live data site application data mounting method and apparatus |
| CN106021020B (en) * | 2016-05-12 | 2019-03-12 | 中国工商银行股份有限公司 | A kind of dual-active data station application data hanging method and device |
| CN108717462A (en) * | 2018-05-28 | 2018-10-30 | 郑州云海信息技术有限公司 | A kind of database snapshot verification method and system |
| CN109597707A (en) * | 2018-10-25 | 2019-04-09 | 平安科技（深圳）有限公司 | Clone volume data copying method, device and computer readable storage medium |
| CN109597707B (en) * | 2018-10-25 | 2024-04-23 | 平安科技（深圳）有限公司 | Clone volume data copying method, device and computer readable storage medium |
| CN110990379A (en) * | 2019-11-24 | 2020-04-10 | 北京浪潮数据技术有限公司 | DB2 database disaster tolerance and control method and system |
| CN110990379B (en) * | 2019-11-24 | 2022-06-17 | 北京浪潮数据技术有限公司 | DB2 database disaster tolerance and control method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104463014B (en) | 2017-06-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| USRE47852E1 (en) | Snapshot and replication of a multi-stream application on multiple hosts at near-sync frequency | |
| US10467109B2 (en) | Replication based security | |
| US9749300B1 (en) | Method and system for immediate recovery of virtual machines encrypted in the cloud | |
| US8788768B2 (en) | Maintaining mirror and storage system copies of volumes at multiple remote sites | |
| US9256605B1 (en) | Reading and writing to an unexposed device | |
| US8260747B2 (en) | System, method, and computer program product for allowing access to backup data | |
| US8020037B1 (en) | Creation of a test bed for testing failover and failback operations | |
| US10042579B1 (en) | Crash consistent snapshot | |
| US10831741B2 (en) | Log-shipping data replication with early log record fetching | |
| US20180276078A1 (en) | Reversal of the direction of replication in a remote copy environment by tracking changes associated with a plurality of point in time copies | |
| US10203904B1 (en) | Configuration of replication | |
| US9317374B2 (en) | Performing a background copy process during a backup operation | |
| US9280296B2 (en) | Recovery from failure of primary storage volumes by using mirrored data maintained with host timestamps | |
| US20230015095A1 (en) | Database information backup method and recovery method, electronic device, and computer readable storage medium | |
| US8656073B2 (en) | Methods of multi-server application synchronization without stopping I/O | |
| US20150081628A1 (en) | Flashcopy reservation for flashcopy onto a synchronously-mirrored source | |
| WO2007146519A2 (en) | Automated priority restores | |
| EP3163447B1 (en) | Data replication method, device and system | |
| US11113252B2 (en) | User selectable data source for data recovery | |
| CN112286728A (en) | Data backup method, device, equipment and computer storage medium | |
| US10725967B1 (en) | Continuous data protection snapshots | |
| JP2007323507A (en) | Storage system and data processing method using the same | |
| CN104463014B (en) | A kind of oracle database guard method based on snapshot | |
| US11176003B2 (en) | Restoration of data when point in time copy operations are performed during asynchronous copy | |
| US11656947B2 (en) | Data set recovery from a point-in-time logical corruption protection copy |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 201112 Shanghai, Minhang District, United Airlines route 1188, building second layer A-1 unit 8 Applicant after: SHANGHAI EISOO INFORMATION TECHNOLOGY CO., LTD. Address before: 201112 Shanghai, Minhang District, United Airlines route 1188, building second layer A-1 unit 8 Applicant before: Shanghai Eisoo Software Co.,Ltd. |
|
| COR | Change of bibliographic data | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |