CN102541694A - Method and device for database backup - Google Patents
Method and device for database backup Download PDFInfo
- Publication number
- CN102541694A CN102541694A CN2012100155963A CN201210015596A CN102541694A CN 102541694 A CN102541694 A CN 102541694A CN 2012100155963 A CN2012100155963 A CN 2012100155963A CN 201210015596 A CN201210015596 A CN 201210015596A CN 102541694 A CN102541694 A CN 102541694A
- Authority
- CN
- China
- Prior art keywords
- backup
- database
- policy
- information
- module
- 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
Images
Abstract
The invention discloses a method and device for database backup, relating to the field of databases. The database backup device disclosed by the invention at least comprises a backup policy formulation module and a data backup module, wherein the backup policy formulation module sets a backup policy of a database according to a user command and sends the backup policy to the database backup module, and the backup policy at least comprises backup time, backup position and backup type; and the database backup module stores the data of the database in the backup position according to the backup type of the backup policy when the backup time of the backup policy arrives. The invention also discloses a database backup method. The way of separated policy, backup and storage is adopted for the technical scheme of the invention, the flow of user backup is simplified, and more flexible backup way is provided.
Description
Technical field
The present invention relates to database field, be specifically related to a kind of method and device of DB Backup.
Background technology
Loss of data all is bad dream concerning big small enterprise, and business datum operates with the enterprise day to day operation and is as close as lips and teeth, and loses these data, even temporaryly also can bring irremediable loss to enterprise.For the backup of key business information in the database, the backup tool that adopts database itself to provide mostly, but there is following shortcoming in these instruments: 1, backup policy is not sufficiently complete, and needs the manual work intervention.2, in general the backup set data all are very big, and the user needs the manual migration work of carrying out the backup set data, wastes time and energy.3, if data set is stored on the local client computer, can bring resource waste to local client computer.
Summary of the invention
Technical matters to be solved by this invention is a kind of method and device of DB Backup to be provided, to simplify the flow process of user ID.
In order to solve the problems of the technologies described above, the invention discloses a kind of DB Backup device, comprise backup policy formulation module and data backup module at least, wherein:
Said backup policy is formulated module, the Database Backup strategy is set and sends to said database backup module according to user instruction, and wherein, said backup policy comprises BACKUP TIME, backup location and type of backup at least;
Said database backup module when the BACKUP TIME of said backup policy arrives, is saved in the type of backup of said data of database according to said backup policy in the backup location.
Preferably, in the said apparatus, said database backup module is also obtained the information of said database, provides corresponding backup policy that option is set according to the information of said database to the user, and the user is provided with said Database Backup strategy through the said option that is provided with.
Preferably, in the said apparatus, the information of said database is instance information or table space information.
Preferably, in the said apparatus, said backup policy also comprises management information, and wherein, said management information comprised the update mode and the update cycle of Backup Data.
Preferably, said apparatus also comprises: backup management module, according to the management information in the said backup policy backed up data is upgraded operation.
The invention also discloses a kind of Database Backup method, comprising:
According to user instruction the Database Backup strategy is set, said backup policy comprises BACKUP TIME, backup location and type of backup at least;
When the BACKUP TIME of said backup policy arrives, the type of backup of said data of database according to said backup policy is saved in the backup location.
Preferably, said method also comprises:
Obtain the information of said database, provide corresponding backup policy that option is set according to the information of said database to the user, the user is provided with said Database Backup strategy through the said option that is provided with.
Preferably, in the said method, the information of said database is instance information or table space information.
Preferably, in the said method, said backup policy also comprises management information, and wherein, said management information comprised the update mode and the update cycle of Backup Data.
Preferably, said method also comprises:
According to the management information in the said backup policy backed up data is upgraded operation
The present techniques scheme adopts strategy, backup, storage spaced manner, has simplified the flow process of user ID, and backup mode more flexibly is provided.
Description of drawings
Fig. 1 is the structural representation of DB Backup device in the present embodiment;
Fig. 2 is a DB Backup process flow diagram in the present embodiment.
Embodiment
For making the object of the invention, technical scheme and advantage clearer, hereinafter will combine accompanying drawing that technical scheme of the present invention is done further explain.Need to prove, under the situation of not conflicting, the combination each other arbitrarily of the application's embodiment and the characteristic among the embodiment.
Embodiment 1
Present embodiment provides a kind of DB Backup device, and the framework of this device is as shown in Figure 1, comprises backup policy formulation module and data backup module at least.Introduce the function of each module below.
Backup policy is formulated module; The Database Backup strategy is set and sends to database backup module according to user instruction; Wherein, Backup policy comprises BACKUP TIME (the for example BACKUP TIME of timed backup, perhaps the BACKUP TIME interval of cycle backup), backup location and type of backup (for example full dose, increment or differential backup) at least;
Whether certainly, above-mentioned backup policy can also comprise other guide, for example, management information, encrypt and information such as whether compress.Wherein, management information comprises update mode to Backup Data, update cycle etc.Update mode refers to backed up data is deleted operations such as management.Database backup module when the BACKUP TIME of backup policy arrives, is saved in the type of backup of data of database according to this backup policy in the backup location.
On the basis of said apparatus; Some preferred versions propose, and backup policy is formulated the information that module can be obtained database in advance, provide corresponding backup policy that option is set according to the information of database to the user; Like this, the user is provided with option through these Database Backup strategy can be set.Wherein, the information of database is instance information or table space information.
Need to prove, in preferred version, why provide corresponding backup policy that option is set according to the information of database to the user, is because the characteristic of disparate databases is different, and its backup policy should come concrete the selection according to the characteristic of database.For example for the database of sql, backup policy formulation module can be the user provides three kinds of type of backups, i.e. full backup, differential backup and transaction log backup.And for oracle instance information or table space information, backup policy is formulated module then can provide full backup, difference incremental backup and accumulative total incremental backup.How backup policy specifically is set, then by the user according to the demand setting.
Also have in some schemes, also increased backup management module, this module can be upgraded operation to backed up data according to the management information in the backup policy.Renewal as herein described comprises that the deletion management waits operation.
In addition, consider that system resource is limited, so database backup module after storing the backup set data (being data to back up) that generate the backup location of appointment into, can also be cleared up local backup set data, to improve the resource utilization of system.
Embodiment 2
This enforcement provides a kind of Database Backup method, and this method mainly comprises:
According to user instruction the Database Backup strategy is set, wherein, backup policy comprises BACKUP TIME, backup location and type of backup at least;
When the BACKUP TIME of set backup policy arrives, the type of backup of data of database according to this backup policy is saved in the backup location.
Some preferred versions are arranged, can obtain the information of database in advance, the information according to database provides corresponding backup policy that option is set to the user then, and like this, the user is provided with option through these can be provided with the Database Backup strategy.The flow process of this preferred version fulfillment database backup is as shown in Figure 2.Wherein, the information of database is instance information or table space information.
Also have in some schemes, backup policy except BACKUP TIME, backup location and type of backup, information such as can also comprising management information, whether encrypt and whether compress.Wherein, management information comprises update mode to Backup Data, update cycle etc.Update mode refers to backed up data is deleted operations such as management.
At this moment, said method carries out in the data backup process, also can encrypt accordingly and/or squeeze operation according to information such as whether encrypting and whether compress in the backup policy.In addition, after said method carries out data backup, can also upgrade operation to backed up data according to the management information in the backup policy.
One of ordinary skill in the art will appreciate that all or part of step in the said method can instruct related hardware to accomplish through program, said program can be stored in the computer-readable recording medium, like ROM (read-only memory), disk or CD etc.Alternatively, all or part of step of the foregoing description also can use one or more integrated circuit to realize.Correspondingly, each the module/unit in the foregoing description can adopt the form of hardware to realize, also can adopt the form of software function module to realize.The application is not restricted to the combination of the hardware and software of any particular form.
Can find out from the foregoing description; The present techniques scheme is according to the information and the user's request customization backup strategy of database; Carry out data backup according to this backup policy again, thereby avoided losing or backup set being stored in the system resource that takies client computer too much on the client computer of backup set data.And; Because the backup policy that is proposed in the present techniques scheme has combined BACKUP TIME, backup location (also can think storage mode) and type of backup etc.; For the user provides a complete flow process, do not need the user to know wherein data flow and storage mode.
The above is merely preferred embodiments of the present invention, is not to be used to limit protection scope of the present invention.All within spirit of the present invention and principle, any modification of being made, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a DB Backup device is characterized in that, this device comprises backup policy formulation module and data backup module at least, wherein:
Said backup policy is formulated module, the Database Backup strategy is set and sends to said database backup module according to user instruction, and wherein, said backup policy comprises BACKUP TIME, backup location and type of backup at least;
Said database backup module when the BACKUP TIME of said backup policy arrives, is saved in the type of backup of said data of database according to said backup policy in the backup location.
2. device as claimed in claim 1 is characterized in that,
Said database backup module is also obtained the information of said database, provides corresponding backup policy that option is set according to the information of said database to the user, and the user is provided with said Database Backup strategy through the said option that is provided with.
3. device as claimed in claim 2 is characterized in that,
The information of said database is instance information or table space information.
4. like each described device of claim 1 to 3, it is characterized in that said backup policy also comprises management information, wherein, said management information comprised the update mode and the update cycle of Backup Data.
5. device as claimed in claim 4 is characterized in that, this device also comprises:
Backup management module is upgraded operation according to the management information in the said backup policy to backed up data.
6. a Database Backup method is characterized in that, this method comprises:
According to user instruction the Database Backup strategy is set, said backup policy comprises BACKUP TIME, backup location and type of backup at least;
When the BACKUP TIME of said backup policy arrives, the type of backup of said data of database according to said backup policy is saved in the backup location.
7. method as claimed in claim 6 is characterized in that, said method also comprises:
Obtain the information of said database, provide corresponding backup policy that option is set according to the information of said database to the user, the user is provided with said Database Backup strategy through the said option that is provided with.
8. method as claimed in claim 7 is characterized in that,
The information of said database is instance information or table space information.
9. like each described method of claim 6 to 8, it is characterized in that,
Said backup policy also comprises management information, and wherein, said management information comprised the update mode and the update cycle of Backup Data.
10. method as claimed in claim 9 is characterized in that, this method also comprises:
According to the management information in the said backup policy backed up data is upgraded operation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210015596.3A CN102541694B (en) | 2012-01-18 | 2012-01-18 | Method and device for database backup |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210015596.3A CN102541694B (en) | 2012-01-18 | 2012-01-18 | Method and device for database backup |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102541694A true CN102541694A (en) | 2012-07-04 |
| CN102541694B CN102541694B (en) | 2015-05-13 |
Family
ID=46348644
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210015596.3A Active CN102541694B (en) | 2012-01-18 | 2012-01-18 | Method and device for database backup |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102541694B (en) |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103176867A (en) * | 2013-04-02 | 2013-06-26 | 浪潮电子信息产业股份有限公司 | Fast file differential backup method |
| CN103473151A (en) * | 2013-09-10 | 2013-12-25 | 中国银行股份有限公司 | Database table backup method and device |
| CN103853827A (en) * | 2014-03-07 | 2014-06-11 | 浪潮电子信息产业股份有限公司 | Database backup method capable of guaranteeing data consistency |
| CN104182302A (en) * | 2014-09-15 | 2014-12-03 | 北京国双科技有限公司 | Database backup method and device |
| CN104850598A (en) * | 2015-04-28 | 2015-08-19 | 江苏瑞中数据股份有限公司 | Method for recovering backup of real-time database |
| CN105630626A (en) * | 2014-11-03 | 2016-06-01 | 中兴通讯股份有限公司 | Transaction backup processing method and device |
| CN105930226A (en) * | 2015-12-30 | 2016-09-07 | 中国银联股份有限公司 | Data processing method and apparatus |
| CN106354588A (en) * | 2016-09-13 | 2017-01-25 | 郑州云海信息技术有限公司 | Database automatic backup method and device |
| CN106569920A (en) * | 2016-11-09 | 2017-04-19 | 腾讯科技（深圳）有限公司 | Database backup method and device |
| CN106569911A (en) * | 2016-10-14 | 2017-04-19 | 深圳前海微众银行股份有限公司 | Data backup method and device |
| CN106648980A (en) * | 2016-12-12 | 2017-05-10 | 北京雷石天地电子技术有限公司 | Backup and recovery method and backup and recovery device for high-availability server databases in offline places |
| CN107193687A (en) * | 2017-04-18 | 2017-09-22 | 北京潘达互娱科技有限公司 | Database backup method and controlling equipment |
| CN108121793A (en) * | 2017-12-20 | 2018-06-05 | 北京搜狐新媒体信息技术有限公司 | A kind of DB Backup dispositions method and device |
| CN108153613A (en) * | 2016-12-06 | 2018-06-12 | 中标软件有限公司 | the backup method of data |
| CN110008066A (en) * | 2019-04-11 | 2019-07-12 | 苏州浪潮智能科技有限公司 | A kind of database backup method, system and electronic equipment and storage medium |
| CN111104247A (en) * | 2018-10-25 | 2020-05-05 | 伊姆西Ip控股有限责任公司 | Method, apparatus and computer program product for managing data replication |
| CN111611104A (en) * | 2020-05-14 | 2020-09-01 | 华云数据有限公司 | InfluxDB data backup method, system and terminal equipment |
| WO2023165226A1 (en) * | 2022-03-02 | 2023-09-07 | 苏州浪潮智能科技有限公司 | Application resource backup method and apparatus, electronic device, and storage medium |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107239369A (en) * | 2017-04-19 | 2017-10-10 | 中国建设银行股份有限公司 | A kind of database filing standby system and method |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1517918A (en) * | 2003-01-17 | 2004-08-04 | 深圳市中兴通讯股分有限公司 | Method for back-up and restoring important data |
| CN1549128A (en) * | 2003-05-15 | 2004-11-24 | 深圳市中兴通讯股份有限公司南京分公 | Databank back-up method |
| US20050193236A1 (en) * | 2004-02-04 | 2005-09-01 | Alacritus, Inc. | Method and apparatus for managing backup data |
| CN101354713A (en) * | 2008-09-08 | 2009-01-28 | 大唐软件技术股份有限公司 | Method and system for storing data |
| CN101610303A (en) * | 2008-06-17 | 2009-12-23 | 中兴通讯股份有限公司 | Multi-medium data automatic backup method and system |
| CN101887388A (en) * | 2010-06-18 | 2010-11-17 | 中兴通讯股份有限公司 | Data backup system and method based on memory database |
-
2012
- 2012-01-18 CN CN201210015596.3A patent/CN102541694B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1517918A (en) * | 2003-01-17 | 2004-08-04 | 深圳市中兴通讯股分有限公司 | Method for back-up and restoring important data |
| CN1549128A (en) * | 2003-05-15 | 2004-11-24 | 深圳市中兴通讯股份有限公司南京分公 | Databank back-up method |
| US20050193236A1 (en) * | 2004-02-04 | 2005-09-01 | Alacritus, Inc. | Method and apparatus for managing backup data |
| CN101610303A (en) * | 2008-06-17 | 2009-12-23 | 中兴通讯股份有限公司 | Multi-medium data automatic backup method and system |
| CN101354713A (en) * | 2008-09-08 | 2009-01-28 | 大唐软件技术股份有限公司 | Method and system for storing data |
| CN101887388A (en) * | 2010-06-18 | 2010-11-17 | 中兴通讯股份有限公司 | Data backup system and method based on memory database |
Cited By (24)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103176867A (en) * | 2013-04-02 | 2013-06-26 | 浪潮电子信息产业股份有限公司 | Fast file differential backup method |
| CN103176867B (en) * | 2013-04-02 | 2017-12-01 | 浪潮电子信息产业股份有限公司 | A kind of fast file differential backup method |
| CN103473151A (en) * | 2013-09-10 | 2013-12-25 | 中国银行股份有限公司 | Database table backup method and device |
| CN103473151B (en) * | 2013-09-10 | 2016-04-06 | 中国银行股份有限公司 | The backup method of database table and device |
| CN103853827A (en) * | 2014-03-07 | 2014-06-11 | 浪潮电子信息产业股份有限公司 | Database backup method capable of guaranteeing data consistency |
| CN104182302A (en) * | 2014-09-15 | 2014-12-03 | 北京国双科技有限公司 | Database backup method and device |
| CN105630626A (en) * | 2014-11-03 | 2016-06-01 | 中兴通讯股份有限公司 | Transaction backup processing method and device |
| CN104850598A (en) * | 2015-04-28 | 2015-08-19 | 江苏瑞中数据股份有限公司 | Method for recovering backup of real-time database |
| CN104850598B (en) * | 2015-04-28 | 2017-11-14 | 江苏瑞中数据股份有限公司 | A kind of real-time data base back-up restoring method |
| CN105930226A (en) * | 2015-12-30 | 2016-09-07 | 中国银联股份有限公司 | Data processing method and apparatus |
| CN105930226B (en) * | 2015-12-30 | 2019-01-01 | 中国银联股份有限公司 | A kind of data processing method and device |
| CN106354588A (en) * | 2016-09-13 | 2017-01-25 | 郑州云海信息技术有限公司 | Database automatic backup method and device |
| CN106569911A (en) * | 2016-10-14 | 2017-04-19 | 深圳前海微众银行股份有限公司 | Data backup method and device |
| CN106569920A (en) * | 2016-11-09 | 2017-04-19 | 腾讯科技（深圳）有限公司 | Database backup method and device |
| CN106569920B (en) * | 2016-11-09 | 2020-12-11 | 腾讯科技（深圳）有限公司 | Database backup method and device |
| CN108153613A (en) * | 2016-12-06 | 2018-06-12 | 中标软件有限公司 | the backup method of data |
| CN106648980A (en) * | 2016-12-12 | 2017-05-10 | 北京雷石天地电子技术有限公司 | Backup and recovery method and backup and recovery device for high-availability server databases in offline places |
| CN107193687A (en) * | 2017-04-18 | 2017-09-22 | 北京潘达互娱科技有限公司 | Database backup method and controlling equipment |
| CN108121793A (en) * | 2017-12-20 | 2018-06-05 | 北京搜狐新媒体信息技术有限公司 | A kind of DB Backup dispositions method and device |
| CN111104247A (en) * | 2018-10-25 | 2020-05-05 | 伊姆西Ip控股有限责任公司 | Method, apparatus and computer program product for managing data replication |
| CN110008066A (en) * | 2019-04-11 | 2019-07-12 | 苏州浪潮智能科技有限公司 | A kind of database backup method, system and electronic equipment and storage medium |
| CN111611104A (en) * | 2020-05-14 | 2020-09-01 | 华云数据有限公司 | InfluxDB data backup method, system and terminal equipment |
| CN111611104B (en) * | 2020-05-14 | 2022-11-29 | 华云数据有限公司 | InfluxDB data backup method, system and terminal equipment |
| WO2023165226A1 (en) * | 2022-03-02 | 2023-09-07 | 苏州浪潮智能科技有限公司 | Application resource backup method and apparatus, electronic device, and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102541694B (en) | 2015-05-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102541694A (en) | Method and device for database backup | |
| US20200226098A1 (en) | Transferring or migrating portions of data objects, such as block-level data migration or chunk-based data migration | |
| CN101253484B (en) | Method for storing data from client and the client | |
| JP5931973B2 (en) | Virtual database system | |
| KR101150127B1 (en) | Method, system and apparatus for creating an archive routine for protecting data in a data protection system | |
| US8121981B2 (en) | Database snapshot management | |
| US9672126B2 (en) | Hybrid data replication | |
| US7698319B2 (en) | Database system management method, database system, database device, and backup program | |
| EP2535815B1 (en) | Consistent backup of a distributed database system | |
| US20060206507A1 (en) | Hierarchal data management | |
| CN106021016A (en) | Virtual point in time access between snapshots | |
| CN102142024A (en) | Logical data backup and rollback using incremental capture in a distributed database | |
| CN104541252A (en) | Server-based hierarchical mass storage system | |
| MXPA05009273A (en) | Method, system, and apparatus for creating an architectural model for generating robust and easy to manage data protection applications in a data protection system. | |
| EP3575968A1 (en) | Method and device for synchronizing active transaction lists | |
| CN102272751B (en) | Data integrity in a database environment through background synchronization | |
| CN103870600A (en) | Data table backup method and device based on Oracle database | |
| CN103605585A (en) | Intelligent backup method based on data discovery | |
| CN103106271B (en) | A kind of DB Backup based on mass data and restoration methods and system | |
| US9207966B2 (en) | Method and system for providing a high-availability application | |
| CN104765651A (en) | Data processing method and device | |
| US20190034294A1 (en) | Restore points based on milestone versions | |
| CN103365740B (en) | A kind of data cold standby method and device | |
| CN103197987A (en) | Data backup method, data recovery method and cloud storage system | |
| CN103793382A (en) | Data processing method and system of database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |