CN104850598B - A kind of real-time data base back-up restoring method - Google Patents
A kind of real-time data base back-up restoring method Download PDFInfo
- Publication number
- CN104850598B CN104850598B CN201510210322.3A CN201510210322A CN104850598B CN 104850598 B CN104850598 B CN 104850598B CN 201510210322 A CN201510210322 A CN 201510210322A CN 104850598 B CN104850598 B CN 104850598B
- Authority
- CN
- China
- Prior art keywords
- backup
- file
- time
- data
- real
- 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.)
- Active
Links
Abstract
Description
Claims (4)
- A kind of 1. real-time data base back-up restoring method, it is characterised in that:The real-time data base back-up restoring method includes:Offline full backup under database run-stopping status and its extensive Multiple, full backup and full dose in the case of solution real-time data base is out of service recover;Under database normal operating condition Line full backup and its recovery, solve real-time data base opens and provide the full backup in the case of user's queried access and entirely Amount is recovered;Incremental backup and its recovery, in the case that solution real-time data base is opened and provides normal service, to newly increasing or newly The physical file of renewal is backed up and its recovered;The data store organisation of the real-time data base meets:Physical file include control file, cache file, index file, Data file, journal file;Index file, data file are without time marking;Data structure in data file includes file header With some evenly sized blocks of files, some back end are included in each blocks of files;The offline full backup and its recovery comprise the following steps:Step A:Stop the real-time data base being currently running, copy physical file successively to backup directory;Step B:Control file is opened, reads index file and data file list, catalogue where more new file is backup directory;Step C:Full backup information record file is created, is stored in full backup catalogue;Open the maximum number of reference number of a document According to file, File header information is read out, the time of blocks of files is distributed according to acquisition of information database last time, by the time Filename, document number with this document, write it is standby for increment in the deviation post write-in full backup information record files of data Part uses;Step D:Backup History file is updated, record includes the information of BACKUP TIME, type of backup and backup directory, backup Terminate;Step E:When offline full dose is recovered, the inherently complete a set of database of physical file that is gone out due to offline full backup File, therefore directly use the physical file log-on data storehouse in full backup catalogue.
- 2. real-time data base back-up restoring method according to claim 1, it is characterised in that:The online full backup and Its recovery comprises the following steps:Step A:To real-time data base plus write lock, it is ensured that externally still provide and look into without new data processing, database in backup procedure Inquiry business;Step B:Perform step B, C, D of offline full backup and its recovery scheme;Step C:Lock is write to real-time data base solution, recovers real-time data base and submits processing business;Step D:Recover the same with offline full dose, during online full dose recovery, the physical file gone out due to full backup is inherently Complete a set of database file, therefore directly use the physical file log-on data storehouse in full backup catalogue.
- 3. real-time data base back-up restoring method according to claim 1, it is characterised in that:The incremental backup is included such as Lower step:Step A:Obtain incremental backup mode and beginning, end time:Three kinds of incremental backup modes are provided:Parameter is the end time EndTime, that is, the All Files block of late allocation between backing up from Last Backup time point to endTime;Parameter is number of days N, Back up the All Files block from distribution in N days after Last Backup time point;Printenv, that is, back up from Last Backup time point to The All Files block distributed between current time in system;Step B:Standby control file:Incremental backup catalogue is created, is named with the time;Database is controlled into file copy to increment Under backup directory;Step C:Backup cache file:Call database interface that data cached taking-up is write into the cache file of user-defined format In;Step D:Backup log file:Database log file is copied under incremental backup catalogue;Step E:Backup incremental data file:Backup information log file is read, obtains the maximum file recorded during Last Backup Number and skew, order reads blocks of files to the Backup end time since the position, and the blocks of files of reading is write into self-defined lattice In formula data file;Step F:Incremental backup information record file is created, is stored in this incremental backup catalogue:It is maximum to open reference number of a document Data file, read out File header information, according to the acquisition of information database last time distribute blocks of files time, by this The filename of time and this document, document number, write data deviation post write-in incremental backup information record file in supply down Secondary incremental backup uses;Step G:Backup History file is updated, record includes the information of BACKUP TIME, type of backup and backup directory, backup Terminate.
- 4. real-time data base back-up restoring method according to claim 1, it is characterised in that:The increment recovery is included such as Lower step:Step A:Recovery time point, sequential search incremental backup catalogue, when selection is less than or equal to recover are obtained by input parameter Between all the incremental backup catalogues and full backup catalogue put as recovering to use catalogue;Step B:Based on the control file F1 under incremental backup catalogue n, wherein, 1≤n≤N, N are the increment that step A is obtained Backup directory number, by being relatively adjusted entirely for the control file F2 under catalogue, if the measuring point in F1 exists in F2, It is that root node is corresponding root node pointer in F2 then to adjust the measuring point, is easy to connect full backup data;If the survey in F1 Point is not present in F2, then it is newly-increased measuring point to illustrate the measuring point, and its root node pointer is set into 0, is easy to follow-up data to add;Such as Measuring point in fruit F2 is not present in F1, then illustrates that the measuring point is deleted, delete the measuring point data;Make the control text ultimately generated Part F3 is the control file at point A moment recovery time;Step C:On the basis of the data in the control file of step B generations and complete standby catalogue, index file, interim log-on data Storehouse DB_T;Step D:The user-defined format cache file under incremental backup catalogue n is read, wherein, 1≤n≤N, N are what step A was obtained Incremental backup catalogue number, is sequentially written back to DB_T;Step E:The user-defined format data file under incremental backup catalogue n is read, wherein, 1≤n≤N, N are what step A was obtained Incremental backup catalogue number, is sequentially written back to DB_T;Step F:Incremental backup catalogue n journal file is read, wherein, 1≤n≤N, N are the incremental backup catalogue that step A is obtained Number, deletion data message therein is obtained, delete the data in DB_T;Step G:Recurrence realizes the file access pattern of whole increment catalogues, closes database D B_T to step B.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510210322.3A CN104850598B (en) | 2015-04-28 | 2015-04-28 | A kind of real-time data base back-up restoring method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510210322.3A CN104850598B (en) | 2015-04-28 | 2015-04-28 | A kind of real-time data base back-up restoring method |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104850598A CN104850598A (en) | 2015-08-19 |
CN104850598B true CN104850598B (en) | 2017-11-14 |
Family
ID=53850243
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510210322.3A Active CN104850598B (en) | 2015-04-28 | 2015-04-28 | A kind of real-time data base back-up restoring method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104850598B (en) |
Families Citing this family (27)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105389335B (en) * | 2015-10-15 | 2018-08-28 | 佛山市云端容灾信息技术有限公司 | It is a kind of based on the data mining analysis method and apparatus drilled automatically |
CN106802895B (en) * | 2015-11-26 | 2020-06-02 | 阿里巴巴集团控股有限公司 | Method and device for repairing database backup data |
CN106844363B (en) * | 2015-12-03 | 2021-01-29 | 阿里巴巴集团控股有限公司 | Method and equipment for physical hot standby and data recovery of database |
CN106445738B (en) * | 2016-09-13 | 2020-10-16 | 苏州浪潮智能科技有限公司 | Database backup method and device |
CN108228617A (en) * | 2016-12-14 | 2018-06-29 | 北京国双科技有限公司 | Ensure the method and device of database manipulation atomicity |
CN108241555B (en) * | 2016-12-26 | 2022-03-01 | 阿里巴巴集团控股有限公司 | Backup and recovery method and device of distributed database and server |
CN106951341A (en) * | 2017-01-20 | 2017-07-14 | 天翼阅读文化传播有限公司 | A kind of database backup method for realizing distributed structure/architecture |
CN107342944B (en) * | 2017-06-15 | 2019-09-17 | 烽火通信科技股份有限公司 | A kind of distribution of ID mark and persistence method and system |
CN109257404B (en) * | 2017-07-14 | 2022-04-05 | 迈普通信技术股份有限公司 | Data backup method, device and system |
CN107515801A (en) * | 2017-09-13 | 2017-12-26 | 绿金在线电子商务有限公司 | A kind of data self-repairing method based on relevant database |
CN107819870A (en) * | 2017-11-21 | 2018-03-20 | 广州视睿电子科技有限公司 | Increment pulling data method, apparatus, storage medium, terminal device and server |
CN108920301B (en) * | 2018-05-16 | 2021-03-30 | 京信通信系统(中国)有限公司 | Data backup method and system, and data recovery method and system |
CN110716825B (en) * | 2018-07-12 | 2023-04-28 | 阿里巴巴集团控股有限公司 | Data disaster recovery processing method, device and system |
CN111221678B (en) * | 2018-11-27 | 2023-04-11 | 阿里巴巴集团控股有限公司 | Hbase data backup/recovery system, method and device and electronic equipment |
CN110209527B (en) * | 2018-11-30 | 2023-05-05 | 腾讯科技(深圳)有限公司 | Data recovery method, device, server and storage medium |
CN109558455A (en) * | 2018-12-03 | 2019-04-02 | 上海热璞网络科技有限公司 | A kind of database backup method, device and server |
CN111309516B (en) * | 2018-12-12 | 2023-03-31 | 深圳市云海物联科技有限公司 | Method for recovering management data of intelligent household equipment and terminal equipment |
CN111078465A (en) * | 2019-11-08 | 2020-04-28 | 苏州浪潮智能科技有限公司 | Data recovery method and device and computer readable storage medium |
CN110941509A (en) * | 2019-11-08 | 2020-03-31 | 北京浪潮数据技术有限公司 | Database backup method, device, equipment and storage medium of cloud platform |
CN112286901A (en) * | 2019-11-19 | 2021-01-29 | 中建材信息技术股份有限公司 | Database fusion association system |
CN111176889A (en) * | 2019-12-11 | 2020-05-19 | 天翼电子商务有限公司 | Automatic backup recovery device and method |
CN111159313B (en) * | 2019-12-31 | 2020-11-13 | 广州鼎甲计算机科技有限公司 | Method, system, device and storage medium for database rapid synthesis backup |
CN111176903B (en) * | 2019-12-31 | 2020-10-02 | 云汉芯城(上海)互联网科技股份有限公司 | Commodity data recovery method, system, equipment and readable storage medium |
CN113434516A (en) * | 2021-08-03 | 2021-09-24 | 深圳华锐金融技术股份有限公司 | Market data storage method and device, computer equipment and readable storage medium |
CN114721881B (en) * | 2022-06-09 | 2022-11-04 | 苏州浪潮智能科技有限公司 | Database management method, system, electronic device and storage medium |
CN115146003B (en) * | 2022-08-30 | 2022-11-18 | 江苏数瑞信息技术有限公司 | Method and system for realizing real-time synchronous processing of incremental data of database in non-invasive manner |
CN116361076B (en) * | 2023-06-01 | 2023-11-14 | 杭州费尔斯通科技有限公司 | Domestic database backup method |
Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102541694A (en) * | 2012-01-18 | 2012-07-04 | 浪潮(北京)电子信息产业有限公司 | Method and device for database backup |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7840539B2 (en) * | 2006-01-24 | 2010-11-23 | International Business Machines Corporation | Method and system for building a database from backup data images |
-
2015
- 2015-04-28 CN CN201510210322.3A patent/CN104850598B/en active Active
Patent Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102541694A (en) * | 2012-01-18 | 2012-07-04 | 浪潮(北京)电子信息产业有限公司 | Method and device for database backup |
Non-Patent Citations (1)
Title |
---|
大规模归档流数据的备份恢复技术的研究与实现;夏斌;《中国优秀硕士学位论文全文数据库信息科技辑》;20090715(第07期);I138-26 * |
Also Published As
Publication number | Publication date |
---|---|
CN104850598A (en) | 2015-08-19 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104850598B (en) | A kind of real-time data base back-up restoring method | |
US20210208973A1 (en) | Generating snapshots and an associated index | |
AU2009324800C1 (en) | Method and system for managing replicated database data | |
US9002785B2 (en) | Stubbing systems and methods in a data replication environment | |
US8352422B2 (en) | Data restore systems and methods in a replication environment | |
CN104040481B (en) | Method and system for merging, storing and retrieving incremental backup data | |
AU2018324425A1 (en) | Restoring a database using a fully hydrated backup | |
CN102339321A (en) | Network file system with version control and method using same | |
US20140025638A1 (en) | Method, system and serving node for data backup and restoration | |
US11093387B1 (en) | Garbage collection based on transmission object models | |
US20110246429A1 (en) | Stub file prioritization in a data replication system | |
CN101777017B (en) | Rapid recovery method of continuous data protection system | |
JP6178859B2 (en) | Database storage system based on optical disk and method of using the same | |
CN106021016A (en) | Virtual point in time access between snapshots | |
CN107798130A (en) | A kind of Snapshot Method of distributed storage | |
JP2016529633A (en) | Snapshot and clone replication | |
CN103530290A (en) | Method and system for data migration among databases | |
US8825653B1 (en) | Characterizing and modeling virtual synthetic backup workloads | |
CN104714859A (en) | Rapid backup and recovery method of mass files | |
CN102024016A (en) | Rapid data restoration method for distributed file system (DFS) | |
CN103605585A (en) | Intelligent backup method based on data discovery | |
CN100504800C (en) | Method for snapshot of magnetic disc | |
CN102722450B (en) | Storage method for redundancy deletion block device based on location-sensitive hash | |
CN113704217A (en) | Metadata and data organization architecture method in distributed persistent memory file system | |
CN104142943B (en) | A kind of data-base capacity-enlarging method and a kind of database |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
EXSB | Decision made by sipo to initiate substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CB03 | Change of inventor or designer information | ||
CB03 | Change of inventor or designer information |
Inventor after: Jiang Yuanchen Inventor after: You Feng Inventor after: Shi Yingjie Inventor after: Zhu Heng Inventor after: Su Yong Inventor after: Zhou Chun Inventor before: Shi Yingjie Inventor before: Zhu Heng Inventor before: Su Yong Inventor before: Zhou Chun |
|
CP02 | Change in the address of a patent holder | ||
CP02 | Change in the address of a patent holder |
Address after: 210012 No. 180 Software Avenue, Yuhuatai District, Nanjing City, Jiangsu Province Patentee after: CHINA REALTIME DATABASE Co.,Ltd. Address before: 210003, 5 new model street, Gulou District, Jiangsu, Nanjing Patentee before: CHINA REALTIME DATABASE Co.,Ltd. |