A database online backup method and system
An online backup and database technology, applied in the database field, can solve problems such as database system abnormality and backup process failure.
Active Publication Date: 2018-08-07
SHANGHAI DAMENG DATABASE
View PDF5 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0005] The present invention provides a database online backup method and system, which are used to solve the problem that the backup process fails due to unexpected errors encountered in the backup process, thereby causing the abnormality of the database system
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0040] In order to make the technical problems solved by the present invention, the technical solutions adopted, and the technical effects achieved more clearly, the technical solutions of the embodiments of the present invention will be described in further detail below in conjunction with the accompanying drawings. Obviously, the described embodiments are only the present invention. Some embodiments, not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative work shall fall within the protection scope of the present invention.
[0041] figure 1 Shows a method flowchart of the first embodiment of a database online backup method according to the present invention. A database online backup method of this embodiment is mainly implemented by a database management system, and the method includes the following steps:
[0042] Step 11: The main backup process sends a backup phase command to the back...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More 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 [0001] The invention relates to the field of databases, in particular to a method and system for online backup of databases. Background technique [0002] At present, database backup is an important means of database system disaster recovery. Data backup is divided into online backup and offline backup. Online backup refers to the backup performed when the database is running normally; while offline backup refers to the backup performed after the database is normally closed. Due to the development of informatization, many current database application systems are in a state of uninterrupted operation 7*24 hours a week, and only online backup methods can be used for their backup. [0003] Online backup is ultimately to send backup commands to the database management system, which will perform specific backup tasks. After the database management system receives the online backup command, it first checks the backup environment, such as whether it repeatedly generates...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F11/14G06F17/30
CPCG06F11/1448G06F11/1461G06F16/27
Inventor 沈宁王海龙王学海
Owner SHANGHAI DAMENG DATABASE