CN107169108A - A kind of method and apparatus that the fast quick-recovery of MySQL data is realized based on Oracle - Google Patents
A kind of method and apparatus that the fast quick-recovery of MySQL data is realized based on Oracle Download PDFInfo
- Publication number
- CN107169108A CN107169108A CN201710355396.5A CN201710355396A CN107169108A CN 107169108 A CN107169108 A CN 107169108A CN 201710355396 A CN201710355396 A CN 201710355396A CN 107169108 A CN107169108 A CN 107169108A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- mysql
- oracle
- server
- 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
- 238000011084 recovery Methods 0.000 title claims abstract description 91
- 238000000034 method Methods 0.000 title claims abstract description 24
- 238000012217 deletion Methods 0.000 claims abstract description 9
- 230000037430 deletion Effects 0.000 claims abstract description 9
- 238000013523 data management Methods 0.000 claims abstract description 7
- 230000000694 effects Effects 0.000 claims description 5
- 230000001360 synchronised effect Effects 0.000 claims description 4
- 210000003205 muscle Anatomy 0.000 claims description 2
- 238000011161 development Methods 0.000 abstract description 7
- 230000006870 function Effects 0.000 description 27
- 238000005516 engineering process Methods 0.000 description 12
- 238000007726 management method Methods 0.000 description 3
- 238000013500 data storage Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 210000001519 tissue Anatomy 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention proposes a kind of device and method that the fast quick-recovery of MySQL data is realized based on Oracle, by using the powerful data flash back function of oracle database, in the case where MySQL database causes error in data due to mistake deletion or maloperation, quick data recovery can be realized.The system architecture for including master server and data recovery services device is simple, Data Recovery Process is easy and easy to carry out, development cost is saved for the structure of data management system and convenient using simple, running, notebook data recovery system stability is strong, safe.
Description
Technical field
The present invention relates to areas of information technology, more particularly to a kind of method and apparatus for realizing the fast quick-recovery of data.
Background technology
Database (Database) be according to data structure come tissue, storage and management data warehouse, it result from away from
Before modern more than 60 years, after the development in information technology and market, particularly nineteen nineties, data management is no longer
Data are only stored and managed, and are transformed into the mode of the various data managements required for user.Database has many types
Type, form from the simplest various data that are stored with is to can carry out the large-scale database system of mass data storage all each
Individual aspect is widely used.
MySQL is a kind of Relational DBMS of open source code (RDBMS), and MySQL database system makes
With the most frequently used database management language -- SQL (SQL) carries out data base administration.Because MySQL is open-source
Code, thus anyone can be downloaded under General Public License license and according to personalization the need for
It is modified.MySQL receives much concern because of its speed, reliability and adaptability.
Oracle database system is one of current relational database management system most popular in the world, system portable
Property good, easy to use, function it is strong, it is adaptable to all kinds of large, medium and small, microcomputer environment, it be a kind of high efficiency, good reliability it is suitable
Answer the database solution of high-throughput.Oracle database provides Flashback Technology, and it is in order that oracle database
Promptly recover from any logic maloperation.
In MySQL database running, if delete table or certain some row by mistake, because mysql does not possess
Flash back function, causes to recover or cumbersome, it is necessary to by corresponding backup, pass through parsing on the basis of backup
Corresponding binary log file, at the time point before data recovery to deletion action by mistake, this process needs to judge
Backup and binlog time point, many times can be consumed and certain data loss problem is likely to result in.
The content of the invention
To solve technical problem as above, the present invention proposes one kind and realizes the fast quick-recovery of MySQL data based on Oracle
Method and system, this method gives full play to the technical advantage of oracle database, can be realized for polytype maloperation
The recovery of data, data recovery procedure is simple, and the loss of no data.
Oracle database provides Flashback Technology, and it is in order that oracle database is fast from any logic maloperation
Recover fastly.The technology is appeared in Oracle 9i versions with flashback query (Flashback Query) first, later
Oracle has carried out comprehensive extension in 10g to the technology, and there is provided flashback database, flash back deletion, flash back table, flash back things
And the functions such as version querying that flash back.
It is all relatively complicated for the data reconstruction method of MySQL database due in the prior art, and it is presently disclosed
Apparatus and method make use of Oracle Flashback Technology, complete data storage and recovery system, Neng Goutong by constructing
Cross specific system architecture of the invention and perform data restoration step, expected recover is realized in the data manipulation for MySQL
Process.
More specifically, the present invention proposes a kind of device that MySQL data recoveries are realized based on Oracle, and it includes one
Individual or multiple master servers, corresponding to the one or more from server, a data recovery of one or more of master servers
Server;
Wherein, MySQL database is accordingly deployed with one or more master servers, for supplying Client application system
Use.
Wherein, it is used to dispose from data from server corresponding to the one or more of one or more of master servers
Storehouse, using this from database ensure data safety while, realize the function of read and write abruption, slow down the database on master server
Pressure;
Wherein, data recovery services device can use low side configuration server, and dispose Oracle12c databases, and
It is only used as mysql database data recovery guaranteeing roles;Or data recovery services device uses routine or high end configuration service
Device, and Oracle12c databases are deployed with, two pdb databases are configured, the recovery guarantee of MySQL database, then root is used as
According to applicable cases configuration database quantity, so that other application is connected.
Wherein, when the MySQL database on master server because non-standard operation or maloperation cause to delete number by mistake
According to rear, data are recovered using the powerful flash back function of the oracle database on data recovery services device;
Wherein, in the device also by data synchronization service function for realizing master server and data recovery services device
Data syn-chronization between upper database, the real-time of data is ensured by real-time data duplication;
Wherein, in the device also by write back data service function for by the Oracle numbers on data recovery services device
The MySQL data that the data obtained after data recovery operation are written back on one or more of master servers again are performed according to storehouse
In storehouse, to realize the fast quick-recovery of data;
It is preferred that for realizing the data between the database on database and data recovery services device on master server
Synchronous data synchronization service function is synchronized using OGG, and OGG synchronously reaches the real-time duplication of submicrosecond one-level, ensures data
Real-time;
It is preferred that when the MySQL database on master server because non-standard operation or maloperation cause to delete by mistake
After data, data, including following situation are recovered using the powerful flash back function of oracle database:If there occurs truncate
Operation flashback database can be used to recover, if occur drop operation can by recycle bin, flashback database or
Recovered based on time point, if occurring delete operations can be recovered by flashing back deletion, flashback query etc., if there occurs
Update is operated, then can be recovered by flashback query;
It is preferred that being completed in the oracle database of data recovery services device after recovering, csv texts can be directly exported
Part, returning for data is completed by write back data service function in MySQL database by mysqlimport or insert
Write deployment.
From as above as can be seen that the Data Recapture Unit is mainly directed towards existing MySQL database because maloperation etc. is led
The mistake of cause is deleted, adds and need by mistake the data recovery procedure performed, and it can overcome traditional data recovery technology, and time-consuming, behaviour
Make cumbersome, and recover the low technical problem of accuracy rate, the recovery technology of existing database can be made full use of, by specific
System architecture realizes the recovery of data.
On the other hand, embodiments of the invention provide a kind of method that MySQL data recoveries are realized based on Oracle, and this is opened
Forwarding method may be implemented in development device as described above, comprise the following steps:
Step 1, each server and each database of operation thereon are opened, externally to provide data management service;
Step 2, the MySQL database on master server is also opened while being used for Client application system from database
Operation begin to realize the function of read and write abruption, and slows down the pressure of the database on master server;
Step 3, recover to carry out in fact between server oracle database in the Mysql master libraries and bottom data of master server
When data syn-chronization;
Step 4, when the MySQL database on master server because non-standard operation or maloperation cause to delete number by mistake
According to rear, data are recovered using the powerful flash back function of the oracle database on data recovery services device.
It is preferred that in the step 1, data recovery services device can use low side configuration server, and dispose
Oracle12c databases, and it is only used as mysql database data recovery guaranteeing roles;Or data recovery services device is used often
Rule or high end configuration server, and Oracle12c databases are deployed with, two pdb databases are configured, MySQL numbers are used as
According to the recovery guarantee in storehouse, further according to applicable cases configuration database quantity, so that other application is connected.
It is preferred that in the step 3, real-time data syn-chronization is carried out using OGG, OGG synchronously reaches the reality of submicrosecond one-level
When replicate, ensure data real-time.
It is preferred that in the step 4, MySQL database on master server is led due to non-standard operation or maloperation
Cause is deleted after data by mistake, and data, including following situation are recovered using the powerful flash back function of oracle database:If occurring
Truncate operations can use flashback database to recover, if recycle bin, flash back can be passed through by occurring drop operations
Database is recovered based on time point, if occurring delete operations can be recovered by flashing back deletion, flashback query etc.,
If there occurs, update is operated, and can be recovered by flashback query
It is preferred that further including in the step 4:Complete extensive in the oracle database of data recovery services device
After multiple, can directly export csv files, by write back data service function in MySQL database by mysqlimport or
Person insert disposes to complete the write-back of data.
As known from the above, the invention discloses the method and system for realizing the fast quick-recovery of data in MySQL database, it is led
Key point is wanted to be easy and be easy to carry out.Have the following technical effect that:Platform of the present invention, which has, changes existing MySQL data
The structure of recovery operation method, it uses existing data flash back function, quick data is realized by specific system architecture
Recover.
Have, Core Superiority one:Save development cost.Core Superiority two:Using simple, operate conveniently.Core Superiority three:
Stability is strong, safe.
Brief description of the drawings
Fig. 1 is the architectural framework figure of Data Recapture Unit in the embodiment of the present invention;
Fig. 2 is the workflow schematic diagram of data reconstruction method in the embodiment of the present invention;
Specific embodiment
Technical scheme in order to illustrate the embodiments of the present invention more clearly, below by using required in embodiment
Accompanying drawing is briefly described, it should be apparent that, drawings in the following description are only some embodiments of the present invention, for ability
For the those of ordinary skill of domain, on the premise of not paying creative work, it can also be obtained according to these accompanying drawings other attached
Figure.
Referring to Fig. 1, the present invention provides a kind of device that MySQL data recoveries are realized based on Oracle, as shown in figure 1, should
Realize the device of MySQL data recoveries based on Oracle, including one or more master servers 1, corresponding to one or many
Individual master server it is one or more from server 2, data recovery services device 3.
Wherein, MySQL database 11 is accordingly deployed with one or more master servers 1, for supplying Client application
System is used.
Wherein, it is used to dispose from data from server 2 corresponding to the one or more of one or more of master servers 1
Storehouse 22, using this from database ensure data safety while, realize the function of read and write abruption, slow down the data on master server
The pressure in storehouse;
Wherein, data recovery services device 3 can use low side configuration server, and dispose Oracle12c databases 33,
And it is only used as mysql database data recovery guaranteeing roles;Or data recovery services device is taken using routine or high end configuration
Business device, and Oracle12c databases 33 are deployed with, two pdb databases are configured, as the recovery guarantee of MySQL database,
Further according to applicable cases configuration database quantity, so that other application is connected.
Wherein, when the MySQL database 11 on master server 1 because non-standard operation or maloperation cause to delete by mistake
After data, data are recovered using the powerful flash back function of the oracle database 33 on data recovery services device 3;
Wherein, in the device also by data synchronization service function 4 for realizing master server 1 and data recovery services
Data syn-chronization on device 3 between database, the real-time of data is ensured by real-time data duplication;
Wherein, in the device also by write back data service function 5 for by the Oracle on data recovery services device 3
Database 33 performs the data obtained after data recovery operation and is written back to again on one or more of master servers 1
In MySQL database 11, to realize the fast quick-recovery of data;
It is preferred that for realizing between the database 33 on database 11 and data recovery services device 3 on master server 1
The data synchronization service function 4 of data syn-chronization synchronized using OGG, OGG synchronously reaches the real-time duplication of submicrosecond one-level, protects
Hinder the real-time of data;
It is preferred that when the MySQL database 11 on master server 1 because non-standard operation or maloperation cause to delete by mistake
After data, using the powerful flash back function of oracle database 33 recover data, including following situation:If there occurs
Truncate operations can use flashback database to recover, can be by recycle bin, flash back number if occurring drop operations
Recover according to storehouse or based on time point, if occurring delete operations can be recovered by flashing back deletion, flashback query etc., if
It there occurs that update is operated, then can be recovered by flashback query;
It is preferred that being completed in the oracle database 33 of data recovery services device 3 after recovering, csv can be directly exported
File, number is completed by write back data service function 5 in MySQL database 11 by mysqlimport or insert
According to write-back deployment.
From as above as can be seen that the Data Recapture Unit is mainly directed towards existing MySQL database because maloperation etc. is led
The mistake of cause is deleted, adds and need by mistake the data recovery procedure performed, and it can overcome traditional data recovery technology, and time-consuming, behaviour
Make cumbersome, and recover the low technical problem of accuracy rate, the recovery technology of existing database can be made full use of, by specific
System architecture realizes the recovery of data.
On the other hand, embodiments of the invention provide a kind of method that MySQL data recoveries are realized based on Oracle, referring to
Fig. 2, the development approach may be implemented in development device as described above, as shown in Fig. 2 it comprises the following steps:
Step 101, each server and each database of operation thereon are opened, externally to provide data management service;
Step 102, the MySQL database on master server for Client application system while using, from database
Bring into operation to realize the function of read and write abruption, and slow down the pressure of the database on master server;
Step 103, recover to carry out between server oracle database in the Mysql master libraries and bottom data of master server
Real-time data syn-chronization;
Step 104, when the MySQL database on master server because non-standard operation or maloperation cause to delete by mistake
After data, data are recovered using the powerful flash back function of the oracle database on data recovery services device.
It is preferred that in the step 101, data recovery services device can use low side configuration server, and dispose
Oracle12c databases, and it is only used as mysql database data recovery guaranteeing roles;Or data recovery services device is used often
Rule or high end configuration server, and Oracle12c databases are deployed with, two pdb databases are configured, MySQL numbers are used as
According to the recovery guarantee in storehouse, further according to applicable cases configuration database quantity, so that other application is connected.
It is preferred that in the step 103, real-time data syn-chronization is carried out using OGG, OGG synchronously reaches submicrosecond one-level
Replicate in real time, ensure the real-time of data.
It is preferred that in the step 104, the MySQL database on master server is due to non-standard operation or maloperation
Cause to delete after data by mistake, data, including following situation are recovered using the powerful flash back function of oracle database:If hair
Having given birth to truncate operations can use flashback database to recover, can be by recycle bin, sudden strain of a muscle if occurring drop operations
Return database or recovered based on time point, can be by flash back deletion, flashback query etc. come extensive if occurring delete operations
Multiple, if there occurs, update is operated, and can be recovered by flashback query
It is preferred that further including in the step 104:Completed in the oracle database of data recovery services device
After recovery, csv files can be directly exported, mysqlimport is passed through in MySQL database by write back data service function
Or insert disposes to complete the write-back of data.
As known from the above, the invention discloses the method and system for realizing the fast quick-recovery of data in MySQL database, it is led
Key point is wanted to be easy and be easy to carry out.Have the following technical effect that:Platform of the present invention, which has, changes existing MySQL data
The structure of recovery operation method, it uses existing data flash back function, quick data is realized by specific system architecture
Recover, and have:Save development cost;Using simple, operate conveniently;Stability is strong, the Core Superiority such as security height.
The foregoing description of the disclosed embodiments, enables those skilled in the art to realize or using the present invention.To this
A variety of modifications of a little embodiments will be apparent for a person skilled in the art, and generic principles defined herein can
Without departing from the spirit or scope of the present invention, to realize in other embodiments.Therefore, the present invention will not be limited
The embodiments shown herein is formed on, but meets the most wide model consistent with features of novelty with principles disclosed herein
Enclose.
Claims (10)
1. a kind of device that MySQL data recoveries are realized based on Oracle, it is characterised in that including one or more main services
Device, corresponding to the one or more from server, a data recovery services device of one or more of master servers;
Wherein, MySQL database is accordingly deployed with one or more master servers, for making for Client application system
With;
Wherein, it is used to dispose from database, profit from server corresponding to the one or more of one or more of master servers
With this from database ensure data safety while, realize the function of read and write abruption, slow down the pressure of the database on master server
Power;
Wherein, data recovery services device is deployed with Oracle12c databases, plays the effect of MySQL database data recovery guarantee,
Or data management effect is played simultaneously, connected for other application;
Wherein, in the present apparatus, when the MySQL database on master server because non-standard operation or maloperation cause data wrong
After by mistake, data are recovered using the flash back function of the oracle database on data recovery services device.
2. the device according to claim 1 that MySQL data recoveries are realized based on Oracle, it is characterised in that:The device
In also by data synchronization service function for realizing that the data on master server and data recovery services device between database are same
Step, the real-time of data is ensured by real-time data duplication.
3. the device according to claim 1 that MySQL data recoveries are realized based on Oracle, it is characterised in that:The device
In also by write back data service function for by data recovery services device oracle database perform data recovery grasp
The data obtained after work are written back in the MySQL database on one or more of master servers again, to realize data
Fast quick-recovery.
4. the device according to claim 1 that MySQL data recoveries are realized based on Oracle, it is characterised in that:The number
Low side configuration server can be used according to server is recovered, and disposes Oracle12c databases, and is only used as MySQL data
Storehouse data recovery guarantee effect;Or data recovery services device uses routine or high end configuration server, and it is deployed with
Oracle12c databases, configure two pdb databases, as the recovery guarantee of MySQL database, match somebody with somebody further according to applicable cases
Quantity database is put, so that other application is connected.
5. the device according to claim 2 that MySQL data recoveries are realized based on Oracle, it is characterised in that:For reality
The data synchronization service work(of the data syn-chronization between the database on database and data recovery services device on existing master server
It can be synchronized using OGG, OGG synchronously reaches the real-time duplication of submicrosecond one-level, ensure the real-time of data.
6. the device according to claim 3 that MySQL data recoveries are realized based on Oracle, it is characterised in that:When main clothes
MySQL database on business device is caused after error in data due to non-standard operation or maloperation, utilizes oracle database
Flash back function recovers data, including following situation:If there occurs, truncate operations can use flashback database to recover,
If generation drop operations can be recovered by recycle bin, flashback database or based on time point, if occurring delete
Operation can be recovered by deletions that flash back, flashback query etc., if there occurs update operations, can by flashback query come
Recover.
7. the device according to claim 6 that MySQL data recoveries are realized based on Oracle, it is characterised in that:In data
Recover after completing to recover in the oracle database of server, can directly export csv files, pass through write back data service function
The write-back deployment of data is completed by mysqlimport or insert in MySQL database.
8. a kind of method that MySQL data recoveries are realized based on Oracle, is imposed in as described in claim any one of 1-7
In device, it is characterised in that comprise the following steps:
Step 1, each server and each database of operation thereon are opened, externally to provide data management service;
Step 2, the MySQL database on master server also begins to fortune while being used for Client application system from database
Row slows down the pressure of the database on master server to realize the function of read and write abruption;
Step 3, recover to carry out in real time between server oracle database in the Mysql master libraries and bottom data of master server
Data syn-chronization;
Step 4, after the MySQL database on master server causes error in data due to non-standard operation or maloperation, profit
Recover data with the flash back function of the oracle database on data recovery services device.
9. the method according to claim 8 that MySQL data recoveries are realized based on Oracle, it is characterised in that:The step
In rapid 4, MySQL database on master server is caused after error in data due to non-standard operation or maloperation, is utilized
The flash back function of oracle database recovers data, including following situation:If there occurs, truncate operations can use sudden strain of a muscle
Database is returned to recover, can be by recycle bin, flashback database or based on time point come extensive if occurring drop operations
Multiple, if occurring delete operations can be recovered by flashing back deletion, flashback query etc., if there occurs, update is operated, can
To be recovered by flashback query.
10. the method according to claim 9 that MySQL data recoveries are realized based on Oracle, it is characterised in that:The step
Further include in rapid 4:Completed in the oracle database of data recovery services device after recovering, can directly export csv
File, data are completed by write back data service function in MySQL database by mysqlimport or insert
Write-back is disposed.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710355396.5A CN107169108B (en) | 2017-05-19 | 2017-05-19 | Method and device for realizing MySQL data quick recovery based on Oracle |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710355396.5A CN107169108B (en) | 2017-05-19 | 2017-05-19 | Method and device for realizing MySQL data quick recovery based on Oracle |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107169108A true CN107169108A (en) | 2017-09-15 |
CN107169108B CN107169108B (en) | 2020-10-20 |
Family
ID=59816501
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710355396.5A Active CN107169108B (en) | 2017-05-19 | 2017-05-19 | Method and device for realizing MySQL data quick recovery based on Oracle |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107169108B (en) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109241174A (en) * | 2018-06-26 | 2019-01-18 | 东软集团股份有限公司 | Method of data synchronization, device, readable storage medium storing program for executing and electronic equipment |
CN109241061A (en) * | 2018-09-14 | 2019-01-18 | 上海新炬网络信息技术股份有限公司 | Guard method for oracle database Truncate operation |
CN109299099A (en) * | 2018-10-11 | 2019-02-01 | 瀚高基础软件股份有限公司 | A kind of the data flashback query and restoration methods, device of PostgreSQL database |
CN110321386A (en) * | 2019-07-05 | 2019-10-11 | 中国工商银行股份有限公司 | Setting, data reconstruction method and the system of data synchronous architecture |
CN110837531A (en) * | 2019-10-12 | 2020-02-25 | 中国平安财产保险股份有限公司 | Data source read-write separation method and device and computer readable storage medium |
CN112579363A (en) * | 2020-12-30 | 2021-03-30 | 上海爱数信息技术股份有限公司 | MySQL data protection system and backup and recovery method thereof |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101136783A (en) * | 2007-10-15 | 2008-03-05 | 中兴通讯股份有限公司 | Backup, recovery method and apparatus for network management system to configure data |
CN105279045A (en) * | 2015-10-28 | 2016-01-27 | 浪潮(北京)电子信息产业有限公司 | Method and system for recovering data of database |
CN105677914A (en) * | 2016-02-29 | 2016-06-15 | 厦门市美亚柏科信息股份有限公司 | Method and system for restoring MDB file table |
US20160203054A1 (en) * | 2015-01-12 | 2016-07-14 | Actifio, Inc. | Disk group based backup |
CN106126371A (en) * | 2016-06-15 | 2016-11-16 | 腾讯科技(深圳)有限公司 | Data return a grade method, Apparatus and system |
CN106547801A (en) * | 2015-09-23 | 2017-03-29 | 北京奇虎科技有限公司 | Database data flash back method and apparatus |
-
2017
- 2017-05-19 CN CN201710355396.5A patent/CN107169108B/en active Active
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101136783A (en) * | 2007-10-15 | 2008-03-05 | 中兴通讯股份有限公司 | Backup, recovery method and apparatus for network management system to configure data |
US20160203054A1 (en) * | 2015-01-12 | 2016-07-14 | Actifio, Inc. | Disk group based backup |
CN106547801A (en) * | 2015-09-23 | 2017-03-29 | 北京奇虎科技有限公司 | Database data flash back method and apparatus |
CN105279045A (en) * | 2015-10-28 | 2016-01-27 | 浪潮(北京)电子信息产业有限公司 | Method and system for recovering data of database |
CN105677914A (en) * | 2016-02-29 | 2016-06-15 | 厦门市美亚柏科信息股份有限公司 | Method and system for restoring MDB file table |
CN106126371A (en) * | 2016-06-15 | 2016-11-16 | 腾讯科技(深圳)有限公司 | Data return a grade method, Apparatus and system |
Cited By (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109241174A (en) * | 2018-06-26 | 2019-01-18 | 东软集团股份有限公司 | Method of data synchronization, device, readable storage medium storing program for executing and electronic equipment |
CN109241174B (en) * | 2018-06-26 | 2021-04-16 | 东软集团股份有限公司 | Data synchronization method and device, readable storage medium and electronic equipment |
CN109241061A (en) * | 2018-09-14 | 2019-01-18 | 上海新炬网络信息技术股份有限公司 | Guard method for oracle database Truncate operation |
CN109241061B (en) * | 2018-09-14 | 2022-02-11 | 上海新炬网络信息技术股份有限公司 | Protection method for Oracle database trunte operation |
CN109299099A (en) * | 2018-10-11 | 2019-02-01 | 瀚高基础软件股份有限公司 | A kind of the data flashback query and restoration methods, device of PostgreSQL database |
CN109299099B (en) * | 2018-10-11 | 2020-11-06 | 瀚高基础软件股份有限公司 | Data flashback query and recovery method and device for PostgreSQL database |
CN110321386A (en) * | 2019-07-05 | 2019-10-11 | 中国工商银行股份有限公司 | Setting, data reconstruction method and the system of data synchronous architecture |
CN110837531A (en) * | 2019-10-12 | 2020-02-25 | 中国平安财产保险股份有限公司 | Data source read-write separation method and device and computer readable storage medium |
CN110837531B (en) * | 2019-10-12 | 2023-06-20 | 中国平安财产保险股份有限公司 | Data source read-write separation method and device and computer readable storage medium |
CN112579363A (en) * | 2020-12-30 | 2021-03-30 | 上海爱数信息技术股份有限公司 | MySQL data protection system and backup and recovery method thereof |
Also Published As
Publication number | Publication date |
---|---|
CN107169108B (en) | 2020-10-20 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107169108A (en) | A kind of method and apparatus that the fast quick-recovery of MySQL data is realized based on Oracle | |
CN104317843B (en) | A kind of data syn-chronization ETL system | |
CN106933703B (en) | Database data backup method and device and electronic equipment | |
CN206388502U (en) | A kind of intranet and extranet data exchange CD throw system | |
CN105373541B (en) | The processing method and system of the data operation request of database | |
CN104239073B (en) | Data maintenance system rapid prototyping development system and method | |
US20190026193A1 (en) | Method and apparatus for executing data recovery operation | |
CN103853718B (en) | Fragment data storehouse access method and Database Systems | |
CN105574187B (en) | A kind of Heterogeneous Database Replication transaction consistency support method and system | |
CN105677876B (en) | A kind of database journal method for digging based on physical level | |
CN110096476A (en) | Data back up method, device and computer readable storage medium | |
CN107391306A (en) | A kind of isomeric data library backup file access pattern method | |
CN109902125A (en) | A kind of distributed storage method based on existing database | |
CN105279285B (en) | A kind of synchronization system and method for relevant database and non-relational database | |
CN103617277A (en) | Method for restoring data table content deleted mistakenly | |
CN107992512A (en) | A kind of method of Data Migration, system and computer-readable recording medium | |
CN111752925B (en) | Visual data management method | |
CN105068888A (en) | Oracle database based data recovery method | |
CN104461670A (en) | Management method for multi-project public code | |
CN102024021A (en) | Method for logging metadata in logical file system | |
JP5412995B2 (en) | Database control apparatus, database control method, and database control program in program model checking | |
CN107346317A (en) | A kind of data query method and apparatus | |
CN107861838A (en) | Method and device of the automated back-up MySQL database from storehouse | |
CN110597821A (en) | Method and device for changing database table structure | |
CN117194385A (en) | Data migration method between different types of relational databases |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20200922 Address after: 215100 No. 1 Guanpu Road, Guoxiang Street, Wuzhong Economic Development Zone, Suzhou City, Jiangsu Province Applicant after: SUZHOU LANGCHAO INTELLIGENT TECHNOLOGY Co.,Ltd. Address before: 450000 Henan province Zheng Dong New District of Zhengzhou City Xinyi Road No. 278 16 floor room 1601 Applicant before: ZHENGZHOU YUNHAI INFORMATION TECHNOLOGY Co.,Ltd. |
|
GR01 | Patent grant | ||
GR01 | Patent grant |