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

A Method of Protecting Oracle Database Based on Snapshot

A database and snapshot technology, applied in interdisciplinary fields, can solve problems such as large host dependence, and achieve the effects of avoiding waiting time, ensuring safety and reliability, and ensuring consistency

Active Publication Date: 2017-06-09
EISOO SOFTWARE
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The purpose of the present invention is to provide a snapshot-based oracle database protection method in order to overcome the above-mentioned defects in the prior art. The storage terminal is used to protect the data application, which solves the problem of the prior art’s large dependence on the host and realizes online Real-time protection ensures data security and reliability

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
  • A Method of Protecting Oracle Database Based on Snapshot
  • A Method of Protecting Oracle Database Based on Snapshot
  • A Method of Protecting Oracle Database Based on Snapshot

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] 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.

[0036] In the present invention, the storage device is mounted on the host, and the methods used for mounting the storage device include iscsi, FC, FCoE or IB. In this embodiment, the iscsi storage technology is taken as an example to illustrate, and the oracle database is built in the storage device iscsi volume, which can reduce the dependence on the host, realize data security and integrity, create instances and table spaces, and configure oracle to archive mode, and then install the snapshot agent for database monitoring.

[0037] like figure 1 As shown, the storage device 2 is ...

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 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 [0001] The invention relates to the interdisciplinary technical field combining computer storage technology and data management technology, in particular to a snapshot-based oracle database protection method. Background technique [0002] Data protection has always been an important research field of computer storage technology and data management technology. Since early humans used stone carvings, bamboo sticks and parchment scrolls to record information, data storage has been passed down as a means of knowledge acquisition and communication. [0003] Data storage has been continuously developed from papermaking technology, printing technology, laser printing, and then paper tape, floppy disk, hard disk, and optical disk. With the advent of the information age, people have more and more requirements for data security and reliability. come higher. As one of the current mainstream client / server or B / S architecture databases, oracle database has become an urg...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F21/62
CPCG06F21/6218
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