CN105677515A - Online backup method and system for database - Google Patents
Online backup method and system for database Download PDFInfo
- Publication number
- CN105677515A CN105677515A CN201610010364.7A CN201610010364A CN105677515A CN 105677515 A CN105677515 A CN 105677515A CN 201610010364 A CN201610010364 A CN 201610010364A CN 105677515 A CN105677515 A CN 105677515A
- Authority
- CN
- China
- Prior art keywords
- backup
- sub
- host
- host process
- backing
- 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
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
- G06F11/1461—Backup scheduling policy
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- Databases & Information Systems (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides an online backup method and system for a database. The online backup method for the database comprises the steps that a backup main progress sends a backup stage command to a backup sub-progress; whether the backup main progress reads executing operation completing information returned by the backup sub-progress or not is judged; if yes, it is determined that the backup main process reads the executing operation completing information sent by the backup sub-progress in a first preset waiting stage, it is determined that database online backup is not finished, and the backup main progress sequentially sends next backup stage commands to the backup sub-progress; if not, it is determined that the backup main progress does not read the executing operation completing information sent by the backup sub-progress in the first preset waiting stage, backed-up data is wiped, and the backup sub-progress is finished. According to the method and system, sending of the backup stage commands and executing of corresponding backup stage operation are separated in the database online backup process, specific execution is carried out in the independent backup sub-progress, and the situation that due to the fact that the specific executing process is abnormal, the system for the database is abnormal is avoided.
Description
Technical field
The present invention relates to database field, particularly relate to a kind of Online Database Backup method and system.
Background technology
At present, DB Backup is the important means that Database Systems hold calamity. Data backup is divided into online backup and off-Line backup. Online backup refers to the backup carried out when database normally runs; And off-Line backup refer to database is normally closed after the backup that carries out. Due to the development of informationization, currently very multi-database application system is all in 7*24 hour uninterrupted operation state weekly, and its backup can only adopt online backup mode.
Online backup is all finally that backup command is sent to data base management system (DBMS), carries out concrete back-up job by it. Backup environment, after receiving online backup command, is first detected by data base management system (DBMS), as whether repeated to generate backup file or increment backup, whether there is backup completely etc.; Then the data in storehouse and daily record is collected; Finally, regularly the information of collection is backed up, generate backup file, for the recovery after fault.
Database Backup operations is that a meeting takies compared with multi-system resource and operation comparatively consuming time, be generally all recommended in application system not busy time back up. If carrying out in process in backup, emergency case is had again to need to carry out the operation of mass data storehouse, it might therefore to wish to stop backup. The current operation of the termination for DB Backup is all that the process by forcing kill to carry out backup operation at operating system layer realizes. Usually also promotor process together completing back-up job owing to performing the process of backup, kill process can not stop the relevant process of all backups sometimes; In addition, it is be forced to exit and improper end due to backup process, the backup file generated cannot be cleaned, not predictable consequence can be caused even in some cases, such as corrupted data etc., on the other hand, the mistake of (data base management system (DBMS) program can not process) can not be expected if running in backup process, whole data base management system (DBMS) operation troubles may be caused, can not continue externally to provide normal service.
Summary of the invention
The present invention provides a kind of Online Database Backup method and system, meets with the mistake do not expected make backup procedure failure for solving, thus cause the problem of Database Systems exception in backup process.
The embodiment of the present invention is by the following technical solutions:
The present invention provides a kind of Online Database Backup method, and the method comprises:
Backup host process sends backup phase order to the sub-process of backup, and for ordering, the sub-process of described backup performs the backup phase operation of coupling in Online Database Backup in described backup phase order;
Judge to back up host process whether to read the backup executable operations that returns of sub-process and complete information;
If, determine that backing up host process reads when the executable operations backing up the transmission of sub-process completes information as within the default first wait period, determine that Online Database Backup does not terminate, then described backup host process order sends next backup phase order to the sub-process of backup; If not, it is determined that backup host process does not read the executable operations that the sub-process of backup sends and completes information presetting in the first wait period, then clear sky Backup Data and terminate the sub-process of described backup.
Preferably, described determine to back up host process and read executable operations that the sub-process of backup sends when completing information for, after presetting in the first wait period, also comprising, it is determined that Online Database Backup has completed, then terminate the sub-process of described backup.
Preferably, described judge to back up host process and whether read the backup executable operations that returns of sub-process and complete information, be specially, periodically judge to back up host process and whether read user intervention and back up the executable operations that sub-process returns and complete information.
Preferably, described backup host process sends backup phase order to after the sub-process of backup, also comprises, determine that backup host process detection reads the error reporting backing up sub-process, then remove Backup Data, terminate the sub-process of backup, and return sub-process failure message.
Preferably, described backup host process sends backup phase order to, after the sub-process of backup, also comprising:
Resolve the user intervention that backup host process reads;
If described user intervention is cancelled or described user intervention conversation, then clear sky Backup Data and terminate the sub-process of described backup.
Present invention also offers a kind of Online Database Backup System, this system comprises:
Sending command unit, send backup phase order to the sub-process of backup for backing up host process, for ordering, the sub-process of described backup performs the backup phase operation of coupling in Online Database Backup in described backup phase order;
Whether the first judging unit, read the backup executable operations that returns of sub-process complete information for judging to back up host process;
Wait unit, for determining that backing up host process reads when the executable operations backing up the transmission of sub-process completes information as within the default first wait period, determine that Online Database Backup does not terminate, then described backup host process order sends next backup phase order to the sub-process of backup; If not, it is determined that backup host process does not read the executable operations that the sub-process of backup sends and completes information presetting in the first wait period, then clear sky Backup Data and terminate the sub-process of described backup.
Preferably, described wait unit, specifically for: if, determine that backing up host process reads when the executable operations backing up the transmission of sub-process completes information as within the default first wait period, if determining, Online Database Backup does not terminate, then described backup host process order sends next backup phase order to the sub-process of backup, if determining, Online Database Backup completes, then terminate the sub-process of described backup; If not, it is determined that backup host process does not read the executable operations that the sub-process of backup sends and completes information presetting in the first wait period, then clear sky Backup Data and terminate the sub-process of described backup.
Preferably, described first judging unit, specifically for: periodically judge to back up host process and whether read user intervention and back up the executable operations that sub-process returns and complete information.
Preferably, also comprise error reporting unit, for determining that backup host process detection reads the error reporting backing up sub-process, then remove Backup Data, terminate the sub-process of backup, and return sub-process failure message.
Preferably, also comprise:
User intervention resolution unit, for resolving the user intervention that backup host process reads;
User intervention actuator unit, if cancelling or described user intervention conversation for described user intervention, then clear sky Backup Data and terminate the sub-process of described backup.
Preferably, also comprise sub-process reading order unit, determine to back up sub-process presetting in the first wait period do not read backup phase order for described, then clear sky Backup Data and destroy the sub-process of backup.
Compared with prior art, a kind of Online Database Backup method provided by the invention and system, have following useful effect:
Whole execution Online Database Backup process is divided into some backup phase orders, sub-process will be shifted onto by host process and often walk backup, host process initiatively sends order to sub-process according to backup logic, and the passive reception of sub-process also performs, and is convenient to the execution of the host process control sub-process of backup; The setting that stage in backup process orders is separated by the present invention with specifically performing, and by specifically performing to be put in the sub-process of independent backup, avoids because specifically performing process exception, causes Database Systems abnormal. The present invention allows to detect user intervention in the process of backup, receives the intervention instruction of user, full backup process is resolved into multiple stage, is convenient to whether have at each stage interval the inspection of user's intervention operation; Backup host process is after sending fill order to the sub-process of backup, it is possible to continue the intervention operation of periodically monitoring upper strata user, is convenient to perform user intervention operation at any time; By backing up test supervision mutual between sub-process and backup host process, it is possible to even if guaranteeing to meet with the mistake do not expected in backup process, the failure of backup also can not cause Database Systems abnormal.
Accompanying drawing explanation
Fig. 1 is the method flow diagram of first embodiment of a kind of Online Database Backup method provided by the invention.
Fig. 2 is the method flow diagram one of the 2nd embodiment of a kind of Online Database Backup method provided by the invention.
Fig. 3 is the method flow diagram two of the 2nd embodiment of a kind of Online Database Backup method provided by the invention.
Fig. 4 is the method flow diagram three of the 2nd embodiment of a kind of Online Database Backup method provided by the invention.
Fig. 5 is the method flow diagram of the 3rd embodiment of a kind of Online Database Backup method provided by the invention.
Fig. 6 is the structure block diagram of first embodiment of a kind of Online Database Backup System provided by the invention.
Fig. 7 is the structure block diagram of the 2nd embodiment of a kind of Online Database Backup System provided by the invention.
Fig. 8 is the structure block diagram of the 3rd embodiment of a kind of Online Database Backup System provided by the invention.
Fig. 9 is case method schema one in a kind of Online Database Backup method provided by the invention and system embodiment.
Figure 10 is case method flowchart 2 in a kind of Online Database Backup method provided by the invention and system embodiment.
Embodiment
For the present invention is solved technical problem, the technical scheme of employing and the technique effect that reaches clearly, below in conjunction with accompanying drawing, the technical scheme of the embodiment of the present invention is described in further detail, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those skilled in the art, not making other embodiments all obtained under creative work prerequisite, belong to the scope of protection of the invention.
Fig. 1 illustrates the method flow diagram according to a kind of Online Database Backup method first embodiment provided by the invention. A kind of Online Database Backup method of the present embodiment realizes primarily of data base management system (DBMS), and the method comprises the following steps:
Step 11: backup host process sends backup phase order to the sub-process of backup, for ordering, the sub-process of backup performs the backup phase operation of coupling in Online Database Backup in backup phase order.
Concrete, backup host process sends backup phase order to the sub-process of backup, and sub-process performs the backup phase operation of coupling in Online Database Backup. Wherein, by not corresponding for backup phase operations control each in an Online Database Backup backup phase order. Database process can be responsible for sending of order of each stage as backup host process; For ordering, the sub-process of backup performs the backup phase operation of coupling in Online Database Backup in backup phase order. A complete backup process has cooperated by a backup host process and a sub-process of backup, and backup host process initiates the process of backup phase order, i.e. Database Systems process; Backing up sub-process is receive backup phase order and perform the process of concrete phased mission. When backup starts, backup host process creates the sub-process of backup.
Wherein, back up host process and back up between sub-process by process signalling methods data interaction, it is possible to be name pipeline (PIPE) etc.
Such as, generally, a complete DB Backup process generally comprises the operation of following backup phase:
1) backup command is resolved, and resolves in backup command the parameter information carried, as backup target export path, back up whether ciphered compressed, whether be increment backup etc.;
2) backup environment verification, whether current environment meets requirement in backup command, as backup target export whether repeat, increment backup whether there is base backup etc.;
3) backup environment initialize, record backup relevant information, prepares to start backup;
4) backup data files, the data file of intended target backup, collects valid data from target data file, after encryption or processed compressed, is written in target backup file;
5) back up daily record file, from the daily record file specified, collect effective daily record data, after encryption or processed compressed, be written in target backup file;
6) generate meta-information file, will the metadata information of backup, such as backup target data file, whether backed up daily record, whether perform the information such as ciphered compressed and be written to independent meta-information file;
7) Backup end, returns to user by result.
Backing up host process and backing up adopts name pipeline (NAMED_PIPE) to realize between sub-process, can arrange a meaningful naming rule in advance, if the name of pipeline is pipe_name.
Determine current residing backup phase by backup host process, provide corresponding backup phase order. In the backup environment verification stage, backup phase order is CMD_CHECK; In the backup environment initialize stage, backup phase order is CMD_INIT; In the backup data files stage, backup phase order is CMD_DBF; Backup daily record document stage, backup phase order is CMD_LOG; Generator information document stage, backup phase order is CMD_META;Backup end, backup phase order is CMD_COMPLETE.
And the realization backing up sub-process can adopt two threads: MAIN main thread and the sub-thread of TASK. The thread that MAIN main thread directly generates when being the sub-process creation of backup; The sub-thread of TASK is the sub-thread for the treatment of specific tasks created in MAIN main thread.
At a backup sub-process inside definition task system, idle task chain table (free_lst) and wait Processing tasks chain table (wait_lst) can be comprised. Time initial, comprising two nodes in free_lst, wait_lst is empty chain table. After work starts, MAIN main thread takes out an idle task node (free_node) from free_lst, backup phase order is read from PIPE, after being converted to corresponding backup phase order operation, fill idle task node (free_node), then joined in wait_lst; The sub-thread of TASK takes out pending task node from wait_lst, processes, and after process terminates, is rejoined in free_lst by node.
It is corresponding as follows that each backup phase order operates with backup phase: the corresponding TSK_CHECK of CMD_CHECK; The corresponding TSK_INIT of CMD_INIT; The corresponding TSK_DBF of CMD_DBF; The corresponding TSK_LOG of CMD_LOG; The corresponding TSK_META of CMD_META; The corresponding task TSK_COMPLETE of CMD_COMPLETE. CMD_CONTINUE refers to continue to perform current operation, can be used as empty order, is left intact; CMD_STOP refers to stop current operation, for setting overall situation variable global_stop_flag=TRUE, after current executable operations gets this mark, stops current operation, does not also need corresponding task.
Step 12: judge to back up host process and whether read the backup executable operations that returns of sub-process and complete information.
Step 13: if, determine that backing up host process reads when the executable operations backing up the transmission of sub-process completes information as within the default first wait period, determine that Online Database Backup does not terminate, then described backup host process order sends next backup phase order to the sub-process of backup; If not, it is determined that backup host process does not read the executable operations that the sub-process of backup sends and completes information presetting in the first wait period, then clear sky Backup Data and terminate the sub-process of described backup.
Concrete, judge to back up host process whether to read the backup executable operations that returns of sub-process and complete information, if, determine that backing up host process reads when the executable operations backing up the transmission of sub-process completes information as within the default first wait period, and determine that Online Database Backup does not terminate, then described backup host process order sends next backup phase order to the sub-process of backup, wherein, backup phase order pre-sets order according to the operating process of Online Database Backup, backup host process often receives executable operations and completes information, then order sends next backup phase order to the sub-process of backup, guarantee that backup operation carries out in order. if not, it is determined that the executable operations that backup host process does not read backup sub-process transmission within the default first wait period completes information, then return sub-process failure message to user, and sub-process failure message can be error reporting etc., the data that the sub-process of clear empty backup has backed up, destroy the sub-process of backup. also Database Systems can not be caused by said process abnormal to guarantee the failure of backup.
Such as, back up between host process and sub-process and carry out communication by pipeline (PIPE) technology.Namely etc. after order is sent to the sub-process of backup by backup host process, whether test backup's host process reads the backup executable operations that returns of sub-process and completes information, and sub-process executable operations to be backed up completes the feedback of information; Backing up sub-process performs after stage orders, the pipeline (PIPE) that feds back through that executable operations completes information returns to backup host process, and wait the subsequent command of host process, if Online Database Backup does not terminate, then host process sends next backup phase order to the sub-process of backup. If host process does not read the information that the sub-process of backup returns within the default first wait period, then clear sky Backup Data, and destroys the sub-process of backup, to guarantee that the failure backed up also can not cause Database Systems abnormal.
Preferably, step 13 also comprises, if, it is determined that it is within the default first wait period that backup host process reads when the executable operations backing up the transmission of sub-process completes information, and determines that Online Database Backup has completed, then terminate the sub-process of described backup.
Concrete, whether test backup's host process reads the backup executable operations that returns of sub-process and completes information, whether judge that backup host process reads waits in the period default first when the executable operations backing up the transmission of sub-process completes letter, if, and determine that Online Database Backup completes, after online Backup end, host process sends CMD_COMPLETE order to sub-process, sub-process judges whether a front phased mission performs failure voluntarily, if failure, then remove Backup Data, exit the sub-process of backup, and return sub-process failure message; Otherwise, only exit the sub-process of backup. Also Database Systems can not be caused by said process abnormal to guarantee the failure of backup.
Fig. 2 to Fig. 4 illustrates the method flow diagram according to a kind of Online Database Backup method the 2nd embodiment provided by the invention. A kind of Online Database Backup method of the present embodiment realizes primarily of data base management system (DBMS), and the method comprises the following steps:
Step 21: backup host process sends backup phase order to the sub-process of backup, for ordering, the sub-process of backup performs the backup phase operation of coupling in Online Database Backup in backup phase order. The execution process of this step is identical with a kind of Online Database Backup method first embodiment step 11, does not repeat them here.
Step 22: periodically judge to back up host process and whether read user intervention and back up the executable operations that sub-process returns and complete information.
Concrete, periodically judge to back up host process by predetermined period T and whether read the intervention instruction of user's input and back up the executable operations that sub-process returns and complete information. Wherein, backing up sub-process executes after backup phase corresponding to backup phase order operate, then enter idle state, therefore, back up the executable operations that sub-process returns to complete information and may have the idle information of the sub-process of backup, and the intervention instruction of user's input can need, for what user inputted, the instruction carrying out the operation of mass data storehouse, as big batch data write enters the instruction of database, user inputs the order interrupting backup or exits user's session etc.
Such as, backup host process sends backup phase order to after the sub-process of backup, the mode waited by interval reads the preset instructions of user's input and the backup executable operations that returns of sub-process completes information every host processes to be backed up such as cycle T tests, wherein, function backup_wait_and_check () can be encapsulated as etc. realization to be detected, conveniently call.Wherein the realization of function backup_wait_and_check () is, first reads the sub-process of backup within the default time and is sent completely information, if not reading, then thinks that sub-process is abnormal, returns sub-process failure message to user; If reading, no matter what result, then first checking user intervention, if desired stopping, then send CMD_STOP order to sub-process, and return intervention information; If not needing to stop, then judge that the sub-process of backup returns whether idle state (whether a front stage Command Task completes), if idle, then jump out this function, send next one backup phase order by host process order; Not idle if (a front stage Command Task does not complete), then sending CMD_CONTINUE order to the sub-process of backup, the notice sub-process of backup continues to perform front stage order.
Step 23: if, determine that backing up host process reads when the executable operations backing up the transmission of sub-process completes information as within the default first wait period, determine that Online Database Backup does not terminate, then described backup host process order sends next backup phase order to the sub-process of backup; If not, it is determined that backup host process does not read the executable operations that the sub-process of backup sends and completes information presetting in the first wait period, then clear sky Backup Data and terminate the sub-process of described backup. The execution process of this step is identical with a kind of Online Database Backup method first embodiment step 13, does not repeat them here.
Preferably, step 23 also comprises: if, it is determined that it is within the default first wait period that backup host process reads when the executable operations backing up the transmission of sub-process completes information, and determines that Online Database Backup has completed, then terminate to back up sub-process.
As shown in Figure 2, preferably, whether the sub-process of backup there is which backup phase operation mistake occurs to better monitor, step 24 is also comprised: determine that backup host process detection reads the error reporting backing up sub-process after step 21, then terminate to back up sub-process, and return sub-process failure message.
Wherein, the detection backing up sub-process can be carried out by step 24 and step 22 simultaneously, continue order for backup phase order CMD_CONTINUE, continue current backup phase for ordering the sub-process of backup and operate. If backup host process detection does not read the error reporting backing up sub-process, then back up host process and send continuation order to the sub-process of backup.
Such as, determine that backup host process detection reads the error reporting backing up sub-process, then back up host process and send termination order CMD_STOP, clear sky Backup Data and terminate to back up sub-process, and return sub-process failure message, if not, the executable operations that then periodically whether test backup's host process reads user intervention and the sub-process of backup returns completes information, if backing up when the executable operations that sub-process returns completes that information does not exceed default first long, and do not read user intervention, then make the sub-process of backup continue current operation.
As shown in accompanying drawing 3 and accompanying drawing 4, in order to the user intervention better detected in the sub-process of backup, prevent user intervention in backup process and cause Backup Data abnormal, after step 22, also comprise:
Step 25: resolve the user intervention that backup host process reads.
Such as, as shown in Figure 10, information is completed when step 22 is preset the executable operations reading backup sub-process transmission in the first wait period, and backup host process does not read the error reporting in above-mentioned steps 24, now get user intervention, then need to resolve the user intervention backing up host process and reading.
Step 26: if user intervention is cancelled or user intervention conversation, then clear sky Backup Data and terminate to back up sub-process.
Preferably, after step 25, also comprise step 27: if user intervention is not cancelled and described user intervention session is not interrupted, and backup host process reads the execution information backing up sub-process and returning, then back up host process and continue to order to backup sub-process transmission.
As above example, as shown in Figure 10, after resolving the user intervention that backup host process reads in step 25, whether detection user intervention is cancelled, if it does, then backup host process sends backup abort commands CMD_STOP to the sub-process of backup, return sub-process failure message to user; The data that the sub-process of clear empty backup has backed up; Destroy the sub-process of backup. If not, then detect whether user intervention session is interrupted, if interrupted, then back up host process and send backup abort commands CMD_STOP to the sub-process of backup, return sub-process failure message to user; The data that the sub-process of clear empty backup has backed up; Destroy the sub-process of backup. If do not interrupted, then the current idle state of the sub-process of backup is read in test, if returning idle information, then thinking that a upper backup phase task completes, the idle information returned completes information as the executable operations returned, and backup host process sends next backup phase task to the sub-process of backup, if returning busy information, then thinking that the sub-process of backup is just performing current backup phase operation, busy information is as execution information, and backup host process sends to the sub-process of backup and continues order.
According to above-mentioned example, as shown in Figure 9, a kind of Online Database Backup method regular backup stages operating of the present invention (do not receive user intervention, and backup master routine situation about normally running) realizes as follows:
1) resolve backup command, from backup command, obtain backup parameter;
2) create the sub-process of backup, call pipeline (PIPE) and backup sub-process creation realization;
3) send CMD_CHECK, send CMD_CHECK order by pipeline to sub-process; Call backup_wait_and_check () simultaneously, if returning successfully, then continue next stage order, otherwise jump to CMD_COMPLETE, terminate backup process;
5) send CMD_INIT, send CMD_INIT order by pipeline to sub-process; Call backup_wait_and_check () simultaneously, if returning successfully, then continue next stage order, otherwise jump to CMD_COMPLETE, terminate backup process;
6) send CMD_DBF, send CMD_DBF order by pipeline to sub-process; Call backup_wait_and_check () simultaneously, if returning successfully, then continue next stage order, otherwise jump to CMD_COMPLETE, terminate backup process;
7) sending CMD_LOG, clearance pipeline sends CMD_LOG order to sub-process; Call backup_wait_and_check () simultaneously, if returning successfully, then continue next stage order, otherwise jump to CMD_COMPLETE, terminate backup process;
8) send CMD_META, send CMD_META order by pipeline to sub-process; Call backup_wait_and_check () simultaneously, if returning successfully, then continue next stage order, otherwise jump to CMD_COMPLETE, terminate backup process;
9) send CMD_COMPLETE, by pipeline to sub-process send CMD_COMPLETE order, and etc. to be returned after, continue the next one stage;
10) destroying sub-process, backup operation terminates.
To sum up, the present embodiment is in backup execution process, user inputs the order interrupting backup or exits user's interference such as user's session, backup process can stop and the information such as backup file or intermediate data that having generated can be eliminated, avoid because specifically performing process exception, cause Database Systems abnormal.
Fig. 5 illustrates the method flow diagram according to a kind of Online Database Backup method the 3rd embodiment provided by the invention. The method of the present embodiment and a kind of Online Database Backup method first embodiment and a kind of Online Database Backup method the 2nd the different of embodiment are, the detection decision steps 34 backing up sub-process is added after step 21, in the present embodiment, comprise the steps:
Step 31: backup host process sends backup phase order to the sub-process of backup, for ordering, the sub-process of backup performs the backup phase operation of coupling in Online Database Backup in backup phase order. The execution process of this step is identical with a kind of Online Database Backup method the 2nd embodiment step 21, does not repeat them here.
Step 32: periodically judge to back up host process and whether read user intervention and back up the executable operations that sub-process returns and complete information. The execution process of this step is identical with a kind of Online Database Backup method the 2nd embodiment step 22, does not repeat them here.
Step 33: if, determine that backing up host process reads when the executable operations backing up the transmission of sub-process completes information as within the default first wait period, determine that Online Database Backup does not terminate, then described backup host process order sends next backup phase order to the sub-process of backup; If not, it is determined that backup host process does not read the executable operations that the sub-process of backup sends and completes information presetting in the first wait period, then clear sky Backup Data and terminate the sub-process of described backup. The execution process of this step is identical with a kind of Online Database Backup method the 2nd embodiment step 23, does not repeat them here.
Step 34: determine to back up sub-process presetting in the first wait period and do not read backup phase order, then clear sky Backup Data and destroy the sub-process of backup.
Wherein, step 34, after step 31, does not all have sequencing between step 34 and step 32, step 33, and step 34 can realize by backing up sub-process or backup host process, does not limit. If realizing by backing up sub-process, especially by the backup phase order that periodically test reading backup host process sends of the sub-process of backup, if backing up sub-process not read backup phase order within the default first wait period, then assert that now backing up host process breaks down, clear sky Backup Data and destroy backup sub-process, it is possible to prevent that host process is stuck or during real fault, performs invalid backup.
Fig. 6 illustrates the structure block diagram according to a kind of Online Database Backup System first embodiment provided by the invention. A kind of Online Database Backup System of the present embodiment realizes primarily of data base management system (DBMS), comprises and sends command unit 41, first judging unit 42 and wait unit 43.
Send command unit 41, whether read the backup executable operations that returns of sub-process complete information for judging to back up host process.
Backup host process sends backup phase order to the sub-process of backup, and for ordering, the sub-process of backup performs the backup phase operation of coupling in Online Database Backup in backup phase order.
Concrete, backup host process sends backup phase order to the sub-process of backup, and sub-process performs the backup phase operation of coupling in Online Database Backup.Wherein, by not corresponding for backup phase operations control each in an Online Database Backup backup phase order. Database process can be responsible for sending of order of each stage as backup host process; For ordering, the sub-process of backup performs the backup phase operation of coupling in Online Database Backup in backup phase order.
Wherein, back up host process and back up between sub-process by process signalling methods data interaction, it is possible to be name pipeline (PIPE) etc.
Such as, generally, a complete DB Backup process generally comprises the operation of following backup phase:
1) backup command is resolved, and resolves in backup command the parameter information carried, as backup target export path, back up whether ciphered compressed, whether be increment backup etc.;
2) backup environment verification, whether current environment meets requirement in backup command, as backup target export whether repeat, increment backup whether there is base backup etc.;
3) backup environment initialize, record backup relevant information, prepares to start backup;
4) backup data files, the data file of intended target backup, collects valid data from target data file, after encryption or processed compressed, is written in target backup file;
5) back up daily record file, from the daily record file specified, collect effective daily record data, after encryption or processed compressed, be written in target backup file;
6) generate meta-information file, will the metadata information of backup, such as backup target data file, whether backed up daily record, whether perform the information such as ciphered compressed and be written to independent meta-information file;
7) Backup end, returns to user by result.
Backing up host process and backing up adopts name pipeline (NAMED_PIPE) to realize between sub-process, can arrange a meaningful naming rule in advance, if the name of pipeline is pipe_name.
Determine current residing backup phase by backup host process, provide corresponding backup phase order. In the backup environment verification stage, backup phase order is CMD_CHECK; In the backup environment initialize stage, backup phase order is CMD_INIT; In the backup data files stage, backup phase order is CMD_DBF; Backup daily record document stage, backup phase order is CMD_LOG; Generator information document stage, backup phase order is CMD_META; Backup end, backup phase order is CMD_COMPLETE.
And the realization backing up sub-process can adopt two threads: MAIN main thread and the sub-thread of TASK. The thread that MAIN main thread directly generates when being the sub-process creation of backup; The sub-thread of TASK is the sub-thread for the treatment of specific tasks created in MAIN main thread.
At a backup sub-process inside definition task system, idle task chain table (free_lst) and wait Processing tasks chain table (wait_lst) can be comprised. Time initial, comprising two nodes in free_lst, wait_lst is empty chain table. After work starts, MAIN main thread takes out an idle task node (free_node) from free_lst, backup phase order is read from PIPE, after being converted to corresponding backup phase order operation, fill idle task node (free_node), then joined in wait_lst; The sub-thread of TASK takes out pending task node from wait_lst, processes, and after process terminates, is rejoined in free_lst by node.
It is corresponding as follows that each backup phase order operates with backup phase: the corresponding TSK_CHECK of CMD_CHECK;The corresponding TSK_INIT of CMD_INIT; The corresponding TSK_DBF of CMD_DBF; The corresponding TSK_LOG of CMD_LOG; The corresponding TSK_META of CMD_META; The corresponding task TSK_COMPLETE of CMD_COMPLETE. CMD_CONTINUE refers to continue to perform current operation, can be used as empty order, is left intact; CMD_STOP refers to stop current operation, for setting overall situation variable global_stop_flag=TRUE, after current executable operations gets this mark, stops current operation, does not also need corresponding task.
Whether the first judging unit 42, read the backup executable operations that returns of sub-process complete information for judging to back up host process.
Wait unit 43, if for, determine that backing up host process reads when the executable operations backing up the transmission of sub-process completes information as within the default first wait period, it is determined that Online Database Backup does not terminate, then described backup host process sequentially sends next backup phase order to backing up sub-process; If not, it is determined that backup host process does not read the executable operations that the sub-process of backup sends and completes information presetting in the first wait period, then clear sky Backup Data and terminate the sub-process of described backup,
Concrete, judge to back up host process whether to read the backup executable operations that returns of sub-process and complete information, if, determine that backing up host process reads when the executable operations backing up the transmission of sub-process completes information as within the default first wait period, and determine that Online Database Backup does not terminate, then described backup host process order sends next backup phase order to the sub-process of backup, wherein, backup phase order pre-sets order according to the operating process of Online Database Backup, backup host process often receives executable operations and completes information, then order sends next backup phase order to the sub-process of backup, guarantee that backup operation carries out in order. if not, it is determined that the executable operations that backup host process does not read backup sub-process transmission within the default first wait period completes information, then return sub-process failure message to user, the data that the sub-process of clear empty backup has backed up, destroy the sub-process of backup. also Database Systems can not be caused by said process abnormal to guarantee the failure of backup.
Such as, back up between host process and sub-process and carry out communication by pipeline (PIPE) technology. Namely etc. after order is sent to the sub-process of backup by backup host process, whether test backup's host process reads the backup executable operations that returns of sub-process and completes information, and sub-process executable operations to be backed up completes the feedback of information; Backing up sub-process performs after stage orders, the pipeline (PIPE) that feds back through that executable operations completes information returns to backup host process, and wait the subsequent command of host process, if Online Database Backup does not terminate, then host process sends next backup phase order to the sub-process of backup. If host process does not read the information that the sub-process of backup returns within the default first wait period, then clear sky Backup Data, and destroys the sub-process of backup, to guarantee that the failure backed up also can not cause Database Systems abnormal.
Preferably, wait unit 43, specifically for: if, determine that backing up host process reads when the executable operations backing up the transmission of sub-process completes information as within the default first wait period, if determining, Online Database Backup does not terminate, then described backup host process order sends next backup phase order to the sub-process of backup, if determining, Online Database Backup completes, then terminate the sub-process of described backup; If not, it is determined that backup host process does not read the executable operations that the sub-process of backup sends and completes information presetting in the first wait period, then clear sky Backup Data and terminate the sub-process of described backup.
Concrete, whether test backup's host process reads the backup executable operations that returns of sub-process and completes information, whether judge that backup host process reads waits in the period default first when the executable operations backing up the transmission of sub-process completes letter, if, and determine that Online Database Backup completes, after online Backup end, host process sends CMD_COMPLETE order to sub-process, sub-process judges whether a front phased mission performs failure voluntarily, if failure, then remove Backup Data, exit the sub-process of backup, and return sub-process failure message;Otherwise, only exit the sub-process of backup. Also Database Systems can not be caused by said process abnormal to guarantee the failure of backup.
Fig. 7 illustrates the method flow diagram according to a kind of Online Database Backup System the 2nd embodiment provided by the invention. A kind of Online Database Backup System of the present embodiment realizes primarily of data base management system (DBMS), comprises and sends command unit 51, first judging unit 52, wait unit 53, error reporting unit 54, user intervention resolution unit 55 and user intervention actuator unit 56.
Sending command unit 51, send backup phase order to the sub-process of backup for backing up host process, for ordering, the sub-process of backup performs the backup phase operation of coupling in Online Database Backup in backup phase order. The execution process of this step is identical with a kind of Online Database Backup method first embodiment step 12, does not repeat them here.
Whether the first judging unit 52, read user intervention and back up the executable operations that sub-process returns complete information for periodically judging to back up host process.
Concrete, periodically judge to back up host process by predetermined period T and whether read the intervention instruction of user's input and back up the executable operations that sub-process returns and complete information. Wherein, backing up sub-process executes after backup phase corresponding to backup phase order operate, then enter idle state, therefore, back up the executable operations that sub-process returns to complete information and may have the idle information of the sub-process of backup, and the intervention instruction of user's input can need, for what user inputted, the instruction carrying out the operation of mass data storehouse, as big batch data write enters the instruction of database, user inputs the order interrupting backup or exits user's session etc.
Such as, backup host process sends backup phase order to after the sub-process of backup, the mode waited by interval reads the preset instructions of user's input and the backup executable operations that returns of sub-process completes information every host processes to be backed up such as cycle T tests, wherein, function backup_wait_and_check () can be encapsulated as etc. realization to be detected, conveniently call. Wherein the realization of function backup_wait_and_check () is, first reads the sub-process of backup within the default time and is sent completely information, if not reading, then thinks that sub-process is abnormal, returns sub-process failure message to user; If reading, no matter what result, then first checking user intervention, if desired stopping, then send CMD_STOP order to sub-process, and return intervention information; If not needing to stop, then judge that the sub-process of backup returns whether idle state (whether a front stage Command Task completes), if idle, then jump out this function, send next one backup phase order by host process order; Not idle if (a front stage Command Task does not complete), then sending CMD_CONTINUE order to the sub-process of backup, the notice sub-process of backup continues to perform front stage order.
Wait unit 53, if for, determine that backing up host process reads when the executable operations backing up the transmission of sub-process completes information as within the default first wait period, it is determined that Online Database Backup does not terminate, then described backup host process sequentially sends next backup phase order to backing up sub-process; If not, it is determined that backup host process does not read the executable operations that the sub-process of backup sends and completes information presetting in the first wait period, then clear sky Backup Data and terminate the sub-process of described backup. With a kind of Online Database Backup System first embodiment, the execution process of this wait unit 53 waits that unit 43 is identical, do not repeat them here.
Preferably, wait unit 53 also specifically for: if, determine that backing up host process reads when the executable operations backing up the transmission of sub-process completes information as within the default first wait period, if determining, Online Database Backup does not terminate, then described backup host process order sends next backup phase order to the sub-process of backup, if determining, Online Database Backup completes, then terminate the sub-process of described backup; If not, it is determined that backup host process does not read the executable operations that the sub-process of backup sends and completes information presetting in the first wait period, then clear sky Backup Data and terminate the sub-process of described backup.
Preferably, whether the sub-process of backup there is which backup phase operation mistake occurs to better monitor, also comprise error reporting unit 54, for determining that backup host process detection reads the error reporting backing up sub-process, then remove Backup Data, terminate the sub-process of backup, and return sub-process failure message.
Wherein, the detection of the sub-process of backup can be carried out in unit 53 by error reporting unit 54 with waiting simultaneously, and continuing order is backup phase order CMD_CONTINUE, for ordering the sub-process of backup to continue current backup phase operation. If backup host process detection does not read the error reporting backing up sub-process, then back up host process and send continuation order to the sub-process of backup.
Such as, determine that backup host process detection reads the error reporting backing up sub-process, then back up host process and send termination order CMD_STOP, terminate the sub-process of backup, and return sub-process failure message, if not, the executable operations that then periodically whether test backup's host process reads user intervention and the sub-process of backup returns completes information, if backing up when the executable operations that sub-process returns completes that information does not exceed default first long, and do not read user intervention, then make the sub-process of backup continue current operation.
In order to the user intervention better detected in the sub-process of backup, prevent user intervention in backup process and cause Backup Data abnormal, also comprise: user intervention resolution unit 55, for resolving the user intervention that backup host process reads.
Such as, as shown in Figure 10, preset the executable operations reading backup sub-process transmission in the first wait period to complete information or be also less than the default first wait period, and backup host process does not read the error reporting in above-mentioned error reporting unit 54, now get user intervention, then need to resolve the user intervention backing up host process and reading.
User intervention actuator unit 56, if cancelling or user intervention conversation for user intervention, then clear sky Backup Data and terminate to back up sub-process.
Preferably, also comprise user intervention and cancel unit 57: if user intervention is not cancelled and described user intervention session is not interrupted, and backup host process reads the execution information backing up sub-process and returning, then described backup host process sends to the sub-process of backup and continues order.
As above example, as shown in Figure 10, after resolving the user intervention that backup host process reads in user intervention resolution unit 55, whether detection user intervention is cancelled, if it does, then backup host process sends backup abort commands CMD_STOP to the sub-process of backup, return sub-process failure message to user; The data that the sub-process of clear empty backup has backed up; Destroy the sub-process of backup. If not, then detect whether user intervention session is interrupted, if interrupted, then back up host process and send backup abort commands CMD_STOP to the sub-process of backup, return sub-process failure message to user;The data that the sub-process of clear empty backup has backed up; Destroy the sub-process of backup. If do not interrupted, then the current idle state of the sub-process of backup is read in test, if returning idle information, then thinking that a upper backup phase task completes, the idle information returned completes information as the executable operations returned, and backup host process sends next backup phase task to the sub-process of backup, if returning busy information, then thinking that the sub-process of backup is just performing current backup phase operation, busy information is as execution information, and backup host process sends to the sub-process of backup and continues order.
According to above-mentioned example, as shown in Figure 9, a kind of Online Database Backup method regular backup stages operating of the present invention realizes as follows:
1) resolve backup command, from backup command, obtain backup parameter;
2) create the sub-process of backup, call pipeline (PIPE) and backup sub-process creation realization;
3) send CMD_CHECK, send CMD_CHECK order by pipeline to sub-process; Call backup_wait_and_check () simultaneously, if returning successfully, then continue next stage order, otherwise jump to CMD_COMPLETE, terminate backup process;
5) send CMD_INIT, send CMD_INIT order by pipeline to sub-process; Call backup_wait_and_check () simultaneously, if returning successfully, then continue next stage order, otherwise jump to CMD_COMPLETE, terminate backup process;
6) send CMD_DBF, send CMD_DBF order by pipeline to sub-process; Call backup_wait_and_check () simultaneously, if returning successfully, then continue next stage order, otherwise jump to CMD_COMPLETE, terminate backup process;
7) sending CMD_LOG, clearance pipeline sends CMD_LOG order to sub-process; Call backup_wait_and_check () simultaneously, if returning successfully, then continue next stage order, otherwise jump to CMD_COMPLETE, terminate backup process;
8) send CMD_META, send CMD_META order by pipeline to sub-process; Call backup_wait_and_check () simultaneously, if returning successfully, then continue next stage order, otherwise jump to CMD_COMPLETE, terminate backup process;
9) send CMD_COMPLETE, by pipeline to sub-process send CMD_COMPLETE order, and etc. to be returned after, continue the next one stage;
10) destroying sub-process, backup operation terminates.
To sum up, the present embodiment is in backup execution process, user inputs the order interrupting backup or exits user's interference such as user's session, backup process can stop and the information such as backup file or intermediate data that having generated can be eliminated, avoid because specifically performing process exception, cause Database Systems abnormal.
Fig. 8 illustrates the structure block diagram according to a kind of Online Database Backup System the 3rd embodiment provided by the invention.
The method of embodiment and a kind of Online Database Backup method first embodiment and a kind of Online Database Backup method the 2nd the different of embodiment are, also comprise and the sub-process reading order unit 64 that transmission command unit 61 is connected, in the present embodiment, comprise and send command unit 61, first judging unit 62, wait unit 63 and sub-process reading order unit 64.
Sending command unit 61: backup host process sends backup phase order to the sub-process of backup, for ordering, the sub-process of backup performs the backup phase operation of coupling in Online Database Backup in backup phase order. The execution process of this step is identical with a kind of Online Database Backup method the 2nd embodiment step 21, does not repeat them here.
First judging unit 62: periodically judge to back up host process and whether read user intervention and back up the executable operations that sub-process returns and complete information. The execution process of this unit is identical with a kind of Online Database Backup System the 2nd embodiment first judging unit 52, does not repeat them here.
Wait unit 63: if, determine that backing up host process reads when the executable operations backing up the transmission of sub-process completes information as within the default first wait period, determine that Online Database Backup does not terminate, then described backup host process order sends next backup phase order to the sub-process of backup; If not, it is determined that backup host process does not read the executable operations that the sub-process of backup sends and completes information presetting in the first wait period, then clear sky Backup Data and terminate the sub-process of described backup. With a kind of Online Database Backup System the 2nd embodiment, the execution process of this unit waits that unit 53 is identical, do not repeat them here.
Sub-process reading order unit 64, does not read backup phase order for determining to back up sub-process presetting in the first wait period, then clear sky Backup Data and destroy the sub-process of backup.
Wherein, sub-process reading order unit 64 is connected with the output terminal sending command unit 61, it is possible to realizes by backing up sub-process or backup host process, does not limit. If realizing by backing up sub-process, especially by the backup phase order that periodically test reading backup host process sends of the sub-process of backup, if backing up sub-process not read backup phase order within the default first wait period, then assert that now backing up host process breaks down, clear sky Backup Data and destroy backup sub-process, it is possible to prevent that host process is stuck to be made or during real fault, perform invalid backup.
In sum, a kind of Online Database Backup method of the present invention and system, the execution with corresponding backup phase operation that sends of backup phase order in Online Database Backup process is separated, to specifically perform to be put in the sub-process of independent backup, avoid because specifically performing process exception, cause Database Systems abnormal. As met with abnormal (the backup file as generated is standby delete or backup file write disk abnormal etc.) in Online Database Backup execution process, then Online Database Backup process stop and having generated other backup the information such as file or intermediate data be eliminated, Database Systems still can normally be run.
Above-described embodiment is the principle of illustrative the present invention and effect thereof only, but not for limiting the present invention. Above-described embodiment all under the spirit not running counter to the present invention and category, can be modified or change by any person skilled in the art scholar. Therefore, in art, tool usually intellectual, not departing under disclosed spirit and technological thought all the equivalence modifications completed or change, must be contained by the claim of the present invention such as.
Claims (12)
1. an Online Database Backup method, it is characterised in that, comprising:
Backup host process sends backup phase order to the sub-process of backup, and for ordering, the sub-process of described backup performs the backup phase operation of coupling in Online Database Backup in described backup phase order;
Judge to back up host process whether to read the backup executable operations that returns of sub-process and complete information;
If, determine that backing up host process reads when the executable operations backing up the transmission of sub-process completes information as within the default first wait period, determine that Online Database Backup does not terminate, then described backup host process order sends next backup phase order to the sub-process of backup; If not, it is determined that backup host process does not read the executable operations that the sub-process of backup sends and completes information presetting in the first wait period, then clear sky Backup Data and terminate the sub-process of described backup.
2. the method for claim 1, it is characterized in that, described determine to back up host process and read executable operations that the sub-process of backup sends when completing information for, after presetting in the first wait period, also comprising, determine that Online Database Backup completes, then terminate the sub-process of described backup.
3. the method for claim 1, it is characterized in that, described judge to back up host process and whether read the backup executable operations that returns of sub-process and complete information, be specially, periodically judge to back up host process and whether read user intervention and back up the executable operations that sub-process returns and complete information.
4. the method for claim 1, it is characterized in that, described backup host process sends backup phase order to after the sub-process of backup, also comprise, determine that backup host process detection reads the error reporting backing up sub-process, then remove Backup Data, terminate the sub-process of backup, and return sub-process failure message.
5. method as described in claim 3 or 4, it is characterised in that, described backup host process sends backup phase order to, after the sub-process of backup, also comprising:
Resolve the user intervention that backup host process reads;
If described user intervention is cancelled or described user intervention conversation, then clear sky Backup Data and terminate the sub-process of described backup.
6. such as method as described in any one in claims 1 to 3, it is characterized in that, backup host process sends backup phase order to before the sub-process of backup, also comprise: determine to back up sub-process presetting in the first wait period and do not read backup phase order, then clear sky Backup Data and destroy the sub-process of backup.
7. an Online Database Backup System, it is characterised in that, comprising:
Sending command unit, send backup phase order to the sub-process of backup for backing up host process, for ordering, the sub-process of described backup performs the backup phase operation of coupling in Online Database Backup in described backup phase order;
Whether the first judging unit, read the backup executable operations that returns of sub-process complete information for judging to back up host process;
Wait unit, for determining that backing up host process reads when the executable operations backing up the transmission of sub-process completes information as within the default first wait period, determine that Online Database Backup does not terminate, then described backup host process order sends next backup phase order to the sub-process of backup; If not, it is determined that backup host process does not read the executable operations that the sub-process of backup sends and completes information presetting in the first wait period, then clear sky Backup Data and terminate the sub-process of described backup.
8. system as claimed in claim 7, it is characterized in that, described wait unit, specifically for: if, determine that backing up host process reads for, within the default first wait period, Online Database Backup does not terminate if determining when the executable operations backing up the transmission of sub-process completes information, then described backup host process sequentially sends next backup phase order to backing up sub-process, if determining, Online Database Backup completes, then terminate the sub-process of described backup; If not, it is determined that backup host process does not read the executable operations that the sub-process of backup sends and completes information presetting in the first wait period, then clear sky Backup Data and terminate the sub-process of described backup.
9. system as claimed in claim 7, it is characterised in that, described first judging unit, specifically for: periodically judge to back up host process and whether read user intervention and back up the executable operations that sub-process returns and complete information.
10. system as claimed in claim 7, it is characterised in that, also comprise error reporting unit, for determining that backup host process detection reads the error reporting backing up sub-process, then remove Backup Data, terminate the sub-process of backup, and return sub-process failure message.
11. systems as described in claim 9 or 10, it is characterised in that, also comprise:
User intervention resolution unit, for resolving the user intervention that backup host process reads;
User intervention actuator unit, if cancelling or described user intervention conversation for described user intervention, then clear sky Backup Data and terminate the sub-process of described backup.
12. such as system as described in any one in claim 7 to 9, it is characterized in that, also comprise sub-process reading order unit, determine to back up sub-process presetting in the first wait period do not read backup phase order for described, then clear sky Backup Data and destroy the sub-process of backup.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610010364.7A CN105677515B (en) | 2016-01-08 | 2016-01-08 | A kind of Online Database Backup method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610010364.7A CN105677515B (en) | 2016-01-08 | 2016-01-08 | A kind of Online Database Backup method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105677515A true CN105677515A (en) | 2016-06-15 |
| CN105677515B CN105677515B (en) | 2018-08-07 |
Family
ID=56299428
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610010364.7A Active CN105677515B (en) | 2016-01-08 | 2016-01-08 | A kind of Online Database Backup method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105677515B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108509298A (en) * | 2018-03-22 | 2018-09-07 | 中国银联股份有限公司 | A kind of method, apparatus and storage medium of data processing |
| CN112451972A (en) * | 2020-11-20 | 2021-03-09 | 深圳点猫科技有限公司 | Game engine-based resource compression package construction method, device, system and medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6658589B1 (en) * | 1999-12-20 | 2003-12-02 | Emc Corporation | System and method for backup a parallel server data storage system |
| CN103064760A (en) * | 2012-12-19 | 2013-04-24 | 华为技术有限公司 | Backup method and backup device |
| CN103761165A (en) * | 2014-01-15 | 2014-04-30 | 北京奇虎科技有限公司 | Log backup method and log backup device |
| US8732418B1 (en) * | 2011-12-13 | 2014-05-20 | Emc Corporation | Shadow registry |
| CN105045681A (en) * | 2015-07-10 | 2015-11-11 | 上海爱数软件有限公司 | Oracle multichannel parallel backup and recovery method |
-
2016
- 2016-01-08 CN CN201610010364.7A patent/CN105677515B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6658589B1 (en) * | 1999-12-20 | 2003-12-02 | Emc Corporation | System and method for backup a parallel server data storage system |
| US8732418B1 (en) * | 2011-12-13 | 2014-05-20 | Emc Corporation | Shadow registry |
| CN103064760A (en) * | 2012-12-19 | 2013-04-24 | 华为技术有限公司 | Backup method and backup device |
| CN103761165A (en) * | 2014-01-15 | 2014-04-30 | 北京奇虎科技有限公司 | Log backup method and log backup device |
| CN105045681A (en) * | 2015-07-10 | 2015-11-11 | 上海爱数软件有限公司 | Oracle multichannel parallel backup and recovery method |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108509298A (en) * | 2018-03-22 | 2018-09-07 | 中国银联股份有限公司 | A kind of method, apparatus and storage medium of data processing |
| CN112451972A (en) * | 2020-11-20 | 2021-03-09 | 深圳点猫科技有限公司 | Game engine-based resource compression package construction method, device, system and medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105677515B (en) | 2018-08-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10152382B2 (en) | Method and system for monitoring virtual machine cluster | |
| KR20190079809A (en) | Fault injection test apparatus and method for the same | |
| US20150100829A1 (en) | Method and system for selecting and executing test scripts | |
| US20150100832A1 (en) | Method and system for selecting and executing test scripts | |
| US9612923B1 (en) | High-availability data center | |
| US7685465B1 (en) | High-availability data center | |
| US20150100830A1 (en) | Method and system for selecting and executing test scripts | |
| JP5444178B2 (en) | Backup / restore processing device, backup / restore processing method and program | |
| US20150100831A1 (en) | Method and system for selecting and executing test scripts | |
| CN113312153B (en) | Cluster deployment method and device, electronic equipment and storage medium | |
| US7600148B1 (en) | High-availability data center | |
| CN104615511A (en) | Host batch recovery processing method and device based on double centers | |
| CN115562911A (en) | Virtual machine data backup method, device, system, electronic equipment and storage medium | |
| CN105677515A (en) | Online backup method and system for database | |
| KR20150124653A (en) | System for monitoring and controling electric power system for process verification | |
| CN108804239B (en) | Platform integration method and device, computer equipment and storage medium | |
| CN114791900A (en) | Operator-based Redis operation and maintenance method, device, system and storage medium | |
| CN115687019A (en) | Database cluster fault processing method, intelligent monitoring platform, equipment and medium | |
| CN111090491B (en) | Virtual machine task state recovery method and device and electronic equipment | |
| CN110597609A (en) | Cluster migration and automatic recovery method and system | |
| KR101449202B1 (en) | System and method for data copy and restoration in steel process middleware | |
| KR102471314B1 (en) | A System and Method of Health Management for On-the-fly Repairing of Order Violation in Airborne Software | |
| CN115048244B (en) | Hardware repairing method, system, computer equipment and medium of server | |
| CN112732809B (en) | ETL system and data processing method based on ETL system | |
| CN117034366A (en) | Method for maintaining data integrity of cloud native non-shutdown upgrade and application thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |