CN110196787B - Data backup and recovery system and data backup and recovery method thereof - Google Patents
Data backup and recovery system and data backup and recovery method thereof Download PDFInfo
- Publication number
- CN110196787B CN110196787B CN201910487260.9A CN201910487260A CN110196787B CN 110196787 B CN110196787 B CN 110196787B CN 201910487260 A CN201910487260 A CN 201910487260A CN 110196787 B CN110196787 B CN 110196787B
- Authority
- CN
- China
- Prior art keywords
- backup
- management
- data
- database
- recovery
- 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
- 238000011084 recovery Methods 0.000 title claims abstract description 69
- 238000000034 method Methods 0.000 title claims abstract description 16
- 238000004891 communication Methods 0.000 claims abstract description 11
- 230000003993 interaction Effects 0.000 claims abstract description 4
- 238000012544 monitoring process Methods 0.000 claims description 13
- 230000014759 maintenance of location Effects 0.000 claims description 7
- 230000000717 retained effect Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
Images
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/1464—Management of the backup or restore process for networked environments
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data backup and recovery system and a data backup and recovery method thereof, belonging to the technical field of data backup, wherein the recovery system comprises front-end equipment, a communication module, a server group and a management terminal; the front-end equipment performs data interaction with the server group through the communication module and backs up data in the server group; the management terminal comprises a management system and a system management module, wherein the management system manages the work of the server group, and the system management module manages the management system; the management system is composed of an equipment management module, a backup management module, a recovery management module, a bad block management module and a query statistical module. The management terminal is connected with the server group of the backup system and manages the hardware equipment and the working state of the server, so that the backup condition of the database can be known conveniently in real time, and the database can be recovered conveniently.
Description
Technical Field
The present invention relates to the field of data backup technologies, and in particular, to a data backup and recovery system and a data backup and recovery method thereof.
Background
Data backup is an offline protection method of data, and refers to backup of data onto an inexpensive medium for data recovery when an online system medium crashes and archive protection of a large amount of historical data. The method is a relatively effective data protection measure with relatively low investment. The data backup can technically realize the online data backup of the key service system and the rapid and lossless data recovery when the system can not be used completely. Meanwhile, due to the limitation of technology and capital, under the condition that a disaster recovery system cannot be built in a short time, building a backup system is the fastest, most effective and most practical system disaster recovery means, and the backup of data can also realize the disaster recovery protection of the system in a certain range.
The traditional database has a single data backup mode, the backup mode cannot be reasonably selected according to the requirement, the data capacity is excessively occupied, the backup rate is slow, data recovery can only be integrally recovered once the database fails, the working pressure of a database server is increased, management equipment is not used for managing the database during data backup, the problem cannot be solved in time, and the normal data backup is influenced.
Disclosure of Invention
The invention aims to provide a data backup and recovery system and a data backup and recovery method thereof, aiming at solving the problems that the data backup cannot be managed in a centralized way and the data backup is low in efficiency and difficult to recover due to a single backup mode, and having the advantages of convenient management and improved backup efficiency.
The invention achieves the aim through the following technical scheme, and the data backup and recovery system comprises front-end equipment, a communication module, a server group and a management terminal;
the front-end equipment performs data interaction with the server group through the communication module and backs up data in the server group;
the management terminal comprises a management system and a system management module, wherein the management system manages the work of the server group, and the system management module manages the management system; the management system consists of an equipment management module, a backup management module, a recovery management module, a bad block management module and a query statistical module; the equipment management module comprises disk management, volume management, RAID management and directory management and is used for managing the hardware state in the server group; the backup management module comprises backup configuration, full-library backup, object backup and timing backup, wherein the full-library backup comprises a level 0 backup and a level 1 backup; the recovery management module comprises full library recovery and object recovery and is used for managing and recovering backup data in the server group; the server group management module is used for monitoring the server group internal database bad block condition, and the query statistical module is used for querying and counting the management condition of the management system internal management module;
a system management module in the management terminal configures the database server and backups various configured parameters, and data generated by a user by using front-end equipment is remotely sent to the database server through a network;
the method comprises the steps that after a database server receives data, backup is carried out, a management terminal sets whether the database server selects full-library backup or object backup, capacity management and bad block check are carried out on a disk, if a logic bad block occurs, a bad block management module carries out bad block repair, and if a physical bad block or disk fault occurs, an alarm signal is sent to the management terminal by a mailbox server;
when data stored in the database fails, full-library recovery or object recovery of the database is selected, the full-library recovery recovers the database data to a state before damage, and the object recovery recovers the specified object according to specified time.
Preferably, the server group includes a plurality of database servers, an application server and a mailbox sending server, the database servers are used for storing and backing up data information of the front-end device, the application server is used for the management terminal to call and manage the internal information of the database servers, and the mailbox sending server is used for sending mailbox reminders to the front-end device when the database servers give alarms.
Preferably, the front-end device includes a notebook and a PC used by the user.
Preferably, the communication module comprises a firewall and a network switch.
Preferably, the system management module comprises user management, role management, outbox configuration, front-end equipment configuration, database configuration, alarm configuration and monitoring data retention configuration.
Preferably, the query statistic module includes a host information query, a job information query, a session information query, a backup set information query, an alarm information query and an alarm notification information query.
A data backup and recovery method based on a data backup and recovery system comprises the following steps:
s1, a system management module in the management terminal configures a database server, including outbox configuration, front-end equipment configuration, database configuration, alarm configuration and monitoring data retention configuration, and backups each configured parameter;
s2, the data generated by the user using the front-end equipment is remotely sent to the database server through the network;
s3, the database server receives the data and performs backup, the management terminal sets the database server to select full-library backup or object backup, and performs capacity management and bad block check on the disk, if a logic bad block occurs, the bad block management module performs bad block repair, and if a physical bad block or disk fault occurs, the mailbox server sends an alarm signal to the management terminal;
s4, when the data stored in the database is in failure, full-library recovery or object recovery is selected, the full-library recovery recovers the database data to the state before damage, the object recovery recovers the designated object according to the designated time, and the supported objects comprise tablespace recovery, data file recovery and control file recovery;
s5, the manager can inquire the information of each server of the server group, job status, session information, backup set information, alarm information and alarm notification information in real time.
Compared with the prior art, the invention has the beneficial effects that:
1. the management terminal is connected with the server group of the backup system and manages the hardware equipment and the working state of the server, so that the backup condition of the database can be known conveniently in real time, and the database can be recovered conveniently.
2. The database backup data is divided into full-library backup, object backup and timing backup through the backup management module, the full-library backup adopts 0-level backup and 1-level backup to backup all data of the front-end equipment in the data, the object backup can select the data type to be backed up, both the two backup modes can adopt timing backup, the time and the strategy of each backup are flexibly specified, the backup mode is reasonably selected to ensure that the backup is more time-saving and labor-saving, the space is not occupied, and when the database fails, the management terminal can also select full-library recovery and object recovery to recover the data.
Drawings
Fig. 1 is a schematic diagram of the connection structure of the whole system module according to the present invention.
Fig. 2 is a schematic diagram of the internal system structure of the management terminal of the present invention.
FIG. 3 is a flowchart of a data backup recovery method according to the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1-2, a data backup and recovery system includes a front-end device, a communication module, a server group, and a management terminal; the front-end equipment performs data interaction with the server group through the communication module and backs up data in the server group; the management terminal comprises a management system and a system management module, wherein the management system manages the work of the server group, and the system management module manages the management system; the management system consists of an equipment management module, a backup management module, a recovery management module, a bad block management module and a query statistical module; the equipment management module comprises disk management, volume management, RAID management and directory management and is used for managing the hardware state in the server group; the backup management module comprises backup configuration, full-base backup, object backup and timing backup, wherein the full-base backup comprises 0-level backup and 1-level backup, the 0-level backup is full backup, the 0-level backup strategy is used for fully backing up the full base, the backup time is long, and the occupied space is large. The 1-level backup is incremental backup, which means that after one full backup or the last incremental backup, each backup only needs to backup files which are increased or modified compared with the previous backup; the recovery management module comprises full library recovery and object recovery and is used for managing and recovering backup data in the server group; the management module of the bad blocks is used for monitoring the bad blocks of the database in the server group, the inquiry and statistics module is used for inquiring and counting the management conditions of the management module in the management system, the server group comprises a plurality of database servers, an application server and a mailbox sending server, the database servers are used for storing and backing up the data information of the front-end equipment, the application server is used for the management terminal to call and manage the data in the database servers, the mailbox sending server is used for sending mailbox reminders to the front-end equipment when the database servers give alarms, the front-end equipment comprises a notebook and a PC (personal computer) end, the communication module comprises a firewall and a network switch, the network switch is used for the networking of the front-end equipment and the database servers, and the firewall plays a role in protecting the network safety, the system management module comprises user management, role management, outbox configuration, front-end equipment configuration, database configuration, alarm configuration and monitoring data retention configuration, wherein the user management is effective management aiming at users needing to log in the system, and different role authorities are distributed to different login users. The method comprises the steps that a user sends a mail to a mail sending mailbox server, and the mail sending mailbox server is used for sending the mail to the mail sending mailbox server. The method is convenient for each user to know the system condition in time, the configuration of the front-end equipment is the management of each front-end equipment, the information of the target host can be obtained by one key through configuring the IP address of the target host, the manual input of the index information of each host is avoided, the configuration of the database refers to the effective management of the database of each target host, the configuration management of the database is convenient for system managers to effectively classify and manage the information of the database, and the alarm configuration refers to the management of the alarm items which may appear in the system, including but not limited to the starting state setting of each alarm item, the existence of a threshold value and the threshold value setting, the need of system scheduling and scheduling rule setting, the frequency of sending emails and sending the emails and the related alarm information setting, such as Oracle database backup state alarm, disk space use size alarm, disk state alarm, data access control and data transmission, The monitoring data retention configuration refers to how many days the collected monitoring historical data is retained, for example, the historical monitoring data of the disk IO is set to be retained for 100 days, the monitoring data of the system CPU is set to be retained for 100 days, and the query statistical module comprises host information query, operation information query, session information query, backup set information query, alarm information query and alarm notification information query.
As shown in fig. 3, a data backup and recovery method of a data backup and recovery system includes the following steps:
s1, configuring the database server by the system management module in the management terminal, including outbox configuration, front-end equipment configuration, database configuration, alarm configuration and monitoring data retention configuration, and backing up each configured parameter;
s2, the data generated by the user using the front-end equipment is remotely sent to the database server through the network;
s3, the database server receives the data and performs backup, the management terminal sets the database server to select full-library backup or object backup, and performs capacity management and bad block check on the disk, if a logic bad block occurs, the bad block management module performs bad block repair, and if a physical bad block or disk fault occurs, the mailbox server sends an alarm signal to the management terminal;
s4, when data stored in the database is in fault, full-library recovery or object recovery of the database is selected, the full-library recovery recovers the database data to a state before damage, the object recovery recovers the specified object according to the specified time, and the supported objects comprise tablespace recovery, data file recovery and control file recovery;
s5, the manager can inquire the information of each server of the server group, job status, session information, backup set information, alarm information and alarm notification information in real time.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential attributes thereof. The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference sign in a claim should not be construed as limiting the claim concerned.
Furthermore, it should be understood that although the present description refers to embodiments, not every embodiment may contain only a single embodiment, and such description is for clarity only, and those skilled in the art should integrate the description, and the embodiments may be combined as appropriate to form other embodiments understood by those skilled in the art.
Claims (7)
1. A data backup and recovery system, characterized by: the system comprises front-end equipment, a communication module, a server group and a management terminal;
the front-end equipment performs data interaction with the server group through the communication module and backs up data in the server group;
the management terminal comprises a management system and a system management module, wherein the management system manages the work of the server group, and the system management module manages the management system; the management system consists of an equipment management module, a backup management module, a recovery management module, a bad block management module and a query statistical module; the equipment management module comprises disk management, volume management, RAID management and directory management and is used for managing the hardware state in the server group; the backup management module comprises backup configuration, full-library backup, object backup and timing backup, wherein the full-library backup comprises a level 0 backup and a level 1 backup; the recovery management module comprises full library recovery and object recovery and is used for managing and recovering backup data in the server group; the server group management module is used for monitoring the server group internal database bad block condition, and the query statistical module is used for querying and counting the management condition of the management system internal management module;
a system management module in the management terminal configures the database server and backups various configured parameters, and data generated by a user by using front-end equipment is remotely sent to the database server through a network;
the method comprises the steps that after a database server receives data, backup is carried out, a management terminal sets whether the database server selects full-library backup or object backup, capacity management and bad block check are carried out on a disk, if a logic bad block occurs, a bad block management module carries out bad block repair, and if a physical bad block or disk fault occurs, an alarm signal is sent to the management terminal by a mailbox server;
when data stored in the database fails, full-library recovery or object recovery of the database is selected, the full-library recovery recovers the database data to a state before damage, and the object recovery recovers the specified object according to specified time.
2. A data backup-restoration system according to claim 1, wherein: the server group comprises a plurality of database servers, an application server and a mailbox sending server, wherein the database servers are used for storing and backing up data information of the front-end equipment, the application server is used for the management terminal to call and manage the data in the database servers, and the mailbox sending server is used for sending mailbox reminders to the front-end equipment when the database servers give alarms.
3. A data backup-restoration system according to claim 1, wherein: the front-end equipment comprises a notebook and a PC end used by a user.
4. A data backup-restoration system according to claim 1, wherein: the communication module includes a firewall and a network switch.
5. A data backup-restoration system according to claim 1, wherein: the system management module comprises user management, role management, outbox configuration, front-end equipment configuration, database configuration, alarm configuration and monitoring data retention configuration.
6. A data backup-restoration system according to claim 1, wherein: the query statistic module comprises host information query, job information query, session information query, backup set information query, alarm information query and alarm notification information query.
7. A data backup-restoration method based on the data backup-restoration system according to any one of claims 1 to 6, characterized in that: the method comprises the following steps:
s1, configuring the database server by the system management module in the management terminal, including outbox configuration, front-end equipment configuration, database configuration, alarm configuration and monitoring data retention configuration, and backing up each configured parameter;
s2, the data generated by the user using the front-end equipment is remotely sent to the database server through the network;
s3, the database server receives the data and performs backup, the management terminal sets the database server to select full-library backup or object backup, and performs capacity management and bad block check on the disk, if a logic bad block occurs, the bad block management module performs bad block repair, and if a physical bad block or disk fault occurs, the mailbox server sends an alarm signal to the management terminal;
s4, when data stored in the database is in fault, full-library recovery or object recovery of the database is selected, the full-library recovery recovers the database data to a state before damage, the object recovery recovers the specified object according to the specified time, and the supported objects comprise tablespace recovery, data file recovery and control file recovery;
s5, the manager can inquire the information of each server of the server group, job status, session information, backup set information, alarm information and alarm notification information in real time.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910487260.9A CN110196787B (en) | 2019-06-05 | 2019-06-05 | Data backup and recovery system and data backup and recovery method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910487260.9A CN110196787B (en) | 2019-06-05 | 2019-06-05 | Data backup and recovery system and data backup and recovery method thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110196787A CN110196787A (en) | 2019-09-03 |
| CN110196787B true CN110196787B (en) | 2022-07-01 |
Family
ID=67754055
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910487260.9A Active CN110196787B (en) | 2019-06-05 | 2019-06-05 | Data backup and recovery system and data backup and recovery method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110196787B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110764943B (en) * | 2019-10-21 | 2023-05-05 | 中国民航信息网络股份有限公司 | Data processing method and device of Oracle database |
| CN114884661B (en) * | 2022-07-13 | 2022-10-14 | 麒麟软件有限公司 | Hybrid security service cryptographic system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN204425400U (en) * | 2015-01-04 | 2015-06-24 | 南方电网科学研究院有限责任公司 | Application server system |
| CN106776141A (en) * | 2016-12-22 | 2017-05-31 | 中国工程物理研究院总体工程研究所 | A kind of enhanced backup and recovery system of safety |
| CN106776114A (en) * | 2016-11-11 | 2017-05-31 | 安徽维德工业自动化有限公司 | A kind of disk array backup management system with Cloud Server backup |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102012789B (en) * | 2009-09-07 | 2014-03-12 | 云端容灾有限公司 | Centralized management type backup and disaster recovery system |
-
2019
- 2019-06-05 CN CN201910487260.9A patent/CN110196787B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN204425400U (en) * | 2015-01-04 | 2015-06-24 | 南方电网科学研究院有限责任公司 | Application server system |
| CN106776114A (en) * | 2016-11-11 | 2017-05-31 | 安徽维德工业自动化有限公司 | A kind of disk array backup management system with Cloud Server backup |
| CN106776141A (en) * | 2016-12-22 | 2017-05-31 | 中国工程物理研究院总体工程研究所 | A kind of enhanced backup and recovery system of safety |
Non-Patent Citations (2)
| Title |
|---|
| Backup and storage management in distributed heterogeneous environments;P. Eitel;《Proceedings Thirteenth IEEE Symposium on Mass Storage Systems. Toward Distributed Storage and Data Management Systems》;20020806;全文 * |
| 基于Oracle数据库系统的备份与恢复技术研究;刘超;《软件》;20140331;第35卷(第3期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110196787A (en) | 2019-09-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6792269B2 (en) | System, method and apparatus for tracking deployment of cellular telephone network sites | |
| CN104301413B (en) | A kind of Oracle distributions method for real-time monitoring of facing cloud database | |
| CN110535713B (en) | Monitoring management system and monitoring management method | |
| CN110196787B (en) | Data backup and recovery system and data backup and recovery method thereof | |
| CN103490917B (en) | The detection method of troubleshooting situation and device | |
| CN101408889A (en) | Method, apparatus and system for monitoring performance | |
| CN103354503A (en) | Cloud storage system capable of automatically detecting and replacing failure nodes and method thereof | |
| CN102255761A (en) | File-based configuration rollback system and configuration rollback method | |
| US11210183B2 (en) | Memory health tracking for differentiated data recovery configurations | |
| US20010034732A1 (en) | Architecture and method for deploying remote database administration | |
| CN109901969B (en) | Design method and device of centralized monitoring management platform | |
| CN103595569A (en) | Method for handling database storage of alarm information of network management system | |
| CN110677480A (en) | Node health management method and device and computer readable storage medium | |
| CN107340971A (en) | A kind of data storage is with recovering framework and method | |
| WO2023123801A1 (en) | Log aggregation system, and method for improving availability of log aggregation system | |
| CN108809729A (en) | The fault handling method and device that CTDB is serviced in a kind of distributed system | |
| CN106201772A (en) | The backup of a kind of operating system based on data center, restoration methods and device | |
| CN104679623A (en) | Server hard disk maintaining method, system and server monitoring equipment | |
| CN110161930B (en) | Data monitoring system and data monitoring method thereof | |
| CN113590049B (en) | Storage volume cross-node cloning method, device, equipment and readable medium | |
| CN111506271B (en) | Data segment unit transmission differentiation management method and distributed block storage system | |
| CN106383900A (en) | Method and system for preventing mistaken deletion of data files in Sybase database | |
| CN110620798A (en) | Control method, system, equipment and storage medium for FTP connection | |
| CN106897189A (en) | A kind of daily record monitoring system based on data real time propelling movement | |
| CN114666195B (en) | Multi-level safety protection data exchange sharing system and method thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20231220 Address after: 6/F, Building F2, Xingmengyuan Scientific Research, No. 198 Mingzhu Road, High tech Zone, Hefei City, Anhui Province, 230000 Patentee after: ANHUI SAN SHI SOFTWARE TECHNOLOGY Co.,Ltd. Address before: 230000 room 406, zone B, entrepreneurship incubation center, National University Science Park, high tech Zone, Hefei, Anhui Province Patentee before: ANHUI SANSHI INFORMATION TECHNOLOGY SERVICE CO.,LTD. |
|
| TR01 | Transfer of patent right |