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

Database emergency handling method and system

An emergency processing and database technology, applied in the computer field, can solve problems such as increasing the number of database processing times, long data synchronization time, errors, etc., and achieve the effect of shortening processing time and consistent data replenishment methods

Inactive Publication Date: 2015-12-16
北京思特奇信息技术股份有限公司
View PDF4 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The existing method of synchronizing from the emergency database to the production database, because it uses sql records, increases the database processing logic, increases the number of database processing times, and the time for data synchronization is relatively long, resulting in the probability of errors during processing also relatively large

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
  • Database emergency handling method and system
  • Database emergency handling method and system
  • Database emergency handling method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0036] A database emergency processing method, comprising the following steps:

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 database emergency handling method and system. The method comprises the following steps of: detecting an operational state of a production library; when the production library is in a normal state, synchronizing data of the production library into an emergency library in real time; when the production library has a fault, switching the production library to the emergency library, and switching a database connection address of an application system to the emergency library; and when the production library returns to the normal state, switching the emergency library back to the production library, and reversely synchronizing data read-write, which is performed in the emergency library within the fault time period of the production library, into the production library. According to the method and the system, in a mode of reverse synchronization from the emergency library to the production library by use of oracle Active Data Guard, data operation records of the emergency library are reduced, and the processing time based on sql covering data in the past is effectively shortened. Furthermore, data covering modes for all services are same, so that the operation is convenient and quick, and each system is not needed to process covering data.

Description

technical field [0001] The invention relates to the field of computers, in particular to a database emergency processing method and system. Background technique [0002] Databases used by many commercial systems, including production and emergency databases. When the database is running normally, the system accesses the production database. When the production database fails due to a problem, the system will switch to the emergency database. After the production library can be used normally, switch the system to the production library. The process of database switching needs to keep the data in the production database and emergency database consistent. [0003] At present, the data in the production database is consistent with that of the emergency database. Through oracleActiveDataGuard technology, the data in the production database can be synchronized to the emergency database in real time. However, when the system uses the emergency database, it is necessary to record ...

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): G06F17/30G06F11/20
CPCG06F11/2082G06F11/2094G06F16/27
Inventor 张菲菲
Owner 北京思特奇信息技术股份有限公司
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