CN108255994A - A kind of database version management method based on database snapshot - Google Patents
A kind of database version management method based on database snapshot Download PDFInfo
- Publication number
- CN108255994A CN108255994A CN201711476815.7A CN201711476815A CN108255994A CN 108255994 A CN108255994 A CN 108255994A CN 201711476815 A CN201711476815 A CN 201711476815A CN 108255994 A CN108255994 A CN 108255994A
- Authority
- CN
- China
- Prior art keywords
- database
- snapshot
- data
- client computer
- restored
- 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.)
- Pending
Links
- 238000007726 management method Methods 0.000 title claims abstract description 11
- 238000000034 method Methods 0.000 claims abstract description 7
- 238000011084 recovery Methods 0.000 claims description 14
- 230000008859 change Effects 0.000 claims description 6
- 241000208340 Araliaceae Species 0.000 claims 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 claims 1
- 235000003140 Panax quinquefolius Nutrition 0.000 claims 1
- 235000008434 ginseng Nutrition 0.000 claims 1
- 238000005516 engineering process Methods 0.000 description 12
- 238000010586 diagram Methods 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 230000002265 prevention Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 150000001875 compounds Chemical class 0.000 description 1
- 230000006378 damage Effects 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 238000000151 deposition Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 230000003612 virological effect Effects 0.000 description 1
Classifications
-
- 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/21—Design, administration or maintenance of databases
- G06F16/219—Managing data history or versioning
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/84—Using snapshots, i.e. a logical point-in-time copy of the data
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of database version management methods based on database snapshot, include the following steps：During the operation for being updated or changing to database, the snapshot of database is created；The database snapshot closest to needs is selected from multiple snapshot points, data clone using file sharing protocol, is mounted to client computer by the data clone catalogue before rollback；It determines the data of the snapshot point needed, selects immediate database positioning, create the data clone catalogue of correspondence database snapshot, specify the client computer restored, using file sharing protocol, data clone is mounted to client computer.The present invention compares more traditional database restoring method, database is restored by creating database snapshot, it being capable of quick turn-on data library, reduce and restore the required time, save memory space, the workload of database administrator is alleviated, simplifies operation and the flow of database distribution.
Description
Technical field
The present invention relates to field of information security technology more particularly to a kind of database version management based on database snapshot
Method.
Background technology
In today that information technology is constantly reformed, continued to develop, computer technology has had been applied to all trades and professions, each
Field, at all using information as the present of exchange basis, database technology has played huge effect.All digital informations are deposited
Dependent on database technology, in the current information age, the safety of data is particularly important, therefore is studied prevention data and lost for storage
Mistake, prevention method and its database recovery technology become an important subject, and database recovery technology is exactly database peace
Complete vital function.
With the proposition of big data concept, big data industry is using big data as core resource, and the data of generation are passed through
Acquisition, storage, processing, analysis and application and displaying, the final value for realizing data.And what is needed to pay attention to is exactly depositing for big data
These features of Chu great, data distribution inconvenience solve the problems, such as that these are also feasible using database recovery technology.
Traditional database recovery technology is exactly data file, journal file to be come using source database backup etc., is led to
It crosses and realizes the recovery of database using some recovery orders.Traditional mode is to restore database to need long time, and
And equal storage size is also needed to, and need to input some recovery orders etc, that is, need many manpowers, object
Power, financial resources.
The version management of database be when database breaks down or be need some version database be used for into
Necessary step when row exploitation and test.The reason of causing the problem has, first, hardware fault, causes data corruption；Second is that number
Cause the inconsistency of data according to the concurrent operations in library；Third, artificial destruction, such as catches fire, and it is stolen, it is viral and artificial intentional
Altered data；Fourth, the update operation to database manipulation is wrong, such as the data of input error during operation or access database
Program is wrong；Fifth, exploitation test needs the database of version.Therefore, the version management of database has many important researchs
Value and significance.
Invention content
The technical problems to be solved by the invention are to provide a kind of database version management method based on database snapshot,
Memory space occupies less and being capable of quick-recovery database soon.
In order to solve the above technical problems, the technical scheme is that：A kind of database version based on database snapshot
Management method includes the following steps：
Create database snapshot：When the operation for being updated or changing to database, the snapshot of the database, institute are created
State the recovery catalogue that snapshot includes data file, journal file and database；
Database before rollback：The database snapshot closest to needs is selected from multiple snapshot points；Utilize the number of selection
According to the data clone catalogue before the snapshot rollback of library；Using file sharing protocol, data clone is mounted to client computer, in client
Restore available database on machine.
Restoring data library：It determines the data of the snapshot point needed, selects immediate database positioning；Create corresponding data
The data clone catalogue of library snapshot；The specified client computer restored；Using file sharing protocol, data clone is mounted to client
Machine restores available database on a client；The specified database name restored, sid, parameter；Change the configuration text of database
Part and Parameter File.
As preferred technical solution, the method is further comprising the steps of：The database restored is opened, checks the number
Whether be available mode according to library, data content whether be selection snapshot point data.
By adopting the above-described technical solution, the beneficial effects of the invention are as follows：The present invention is extensive compared to more traditional database
On the one hand compound method is the reduction of and restores the required time, traditional database recovery needs to carry out original document establishment, control
Series of operation steps, the present invention such as document creation processed, restore processes, journal recovery process are fast by creating database
Restore according to database, only need to change the parameter that user wants to set up, it being capable of quick turn-on data library；Second is that it saves
Memory space, stores corresponding each database positioning using database snapshot, every time only the data content of change
It stores, greatly reduces the occupancy of memory space in this way；Third, the workload of database administrator is alleviated, according to difference
Demand of the personnel to disparate databases version, restored one by one, simplify operation and the flow of distribution.
Description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, to embodiment or will show below
There is attached drawing needed in technology description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention, for those of ordinary skill in the art, without having to pay creative labor, may be used also
To obtain other attached drawings according to these attached drawings.
Fig. 1 is the flow chart of the embodiment of the present invention；
Fig. 2 is the schematic diagram of the database before the embodiment of the present invention retracts；
Fig. 3 is the schematic diagram in restoring data of embodiment of the present invention library.
Specific embodiment
If Fig. 1 to Fig. 3 is jointly shown, a kind of database version management method based on database snapshot, including following step
Suddenly：
Create database snapshot：When the operation for being updated or changing to database, the snapshot of database, snapshot packet are created
Include the recovery catalogue of data file, journal file and database；
Database before rollback：The database snapshot closest to needs is selected from multiple snapshot points；Utilize the number of selection
According to the data clone catalogue before the snapshot rollback of library；Using file sharing protocol, data clone is mounted to client computer, in client
Restore available database on machine.
Restoring data library：It determines the data of the snapshot point needed, selects immediate database positioning；Create corresponding data
The data clone catalogue of library snapshot；The specified client computer restored；Using file sharing protocol, data clone is mounted to client
Machine restores available database on a client；The specified database name restored, sid, parameter；Change the configuration text of database
Part and Parameter File.
Open the database restored, check whether database is available mode, data content whether be selection snapshot point
Data.
Wherein, in attached drawing 1, source database is the database in the embodiment of the present invention, and target database is on a client
The database of recovery, host is corresponding with the client computer in the embodiment of the present invention, during file-sharing, by server by target data
On the carry to client computer of library.
Example：The database version of target machine a（That is source database）In 13:00 creates snapshot 1；In 14:00 creates snapshot
2；In 15:00 creates snapshot 3；
If the database of target machine a is accidentally 14:30 accidentally delete data or loss of data, then using rollback operation step, choosing
Select nearest snapshot（That is snapshot 2）It retracts, return back to 14:Database version when 00, i.e. target database.
If another user needs 13:00 data carry out exploitation test job, and provide a target machine
B then using restoring operation step, selects snapshot 1 to be restored, and the target database restored on target machine b corresponds to
In 13:00 database positioning.
Basic principle, main feature and the advantages of the present invention of the present invention has been shown and described above.The technology of the industry
Personnel are it should be appreciated that the present invention is not limited to the above embodiments, and the above embodiments and description only describe this
The principle of invention, without departing from the spirit and scope of the present invention, various changes and improvements may be made to the invention, these changes
Change and improvement all fall within the protetion scope of the claimed invention.The claimed scope of the invention by appended claims and its
Equivalent thereof.
Claims (2)
1. a kind of database version management method based on database snapshot, which is characterized in that include the following steps：
Create database snapshot：When the operation for being updated or changing to database, the snapshot of the database, institute are created
State the recovery catalogue that snapshot includes data file, journal file and database；
Database before rollback：The database snapshot closest to needs is selected from multiple snapshot points；Utilize the number of selection
According to the data clone catalogue before the snapshot rollback of library；Using file sharing protocol, data clone is mounted to client computer, in client
Restore available database on machine；
Restoring data library：It determines the data of the snapshot point needed, selects immediate database positioning；It is fast to create correspondence database
According to data clone catalogue；The specified client computer restored；Using file sharing protocol, data clone is mounted to client computer,
Restore available database in client computer；The specified database name restored, sid, parameter；Change the configuration file and ginseng of database
Number file.
2. a kind of database version management method based on database snapshot as described in claim 1, it is characterised in that：It is described
Method is further comprising the steps of：The database restored is opened, checks whether the database is available mode, and whether is data content
It is the snapshot point data of selection.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711476815.7A CN108255994A (en) | 2017-12-29 | 2017-12-29 | A kind of database version management method based on database snapshot |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711476815.7A CN108255994A (en) | 2017-12-29 | 2017-12-29 | A kind of database version management method based on database snapshot |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108255994A true CN108255994A (en) | 2018-07-06 |
Family
ID=62725321
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711476815.7A Pending CN108255994A (en) | 2017-12-29 | 2017-12-29 | A kind of database version management method based on database snapshot |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108255994A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109918386A (en) * | 2019-01-31 | 2019-06-21 | 北京明略软件系统有限公司 | A kind of data reconstruction method and device, computer readable storage medium |
| CN110633265A (en) * | 2019-08-22 | 2019-12-31 | 达疆网络科技(上海)有限公司 | Method for realizing ES (ES) cross-multi-version data migration |
| CN111177260A (en) * | 2019-12-19 | 2020-05-19 | 上海上讯信息技术股份有限公司 | Database remote copying method and device and electronic equipment |
| CN111190878A (en) * | 2019-12-29 | 2020-05-22 | 北京浪潮数据技术有限公司 | Method, device, equipment and storage medium for sharing access NAS snapshot |
| CN112380058A (en) * | 2020-11-12 | 2021-02-19 | 上海上讯信息技术股份有限公司 | File recovery method and equipment |
| CN112765129A (en) * | 2021-01-11 | 2021-05-07 | 上海上讯信息技术股份有限公司 | Method and equipment for realizing database data version management |
| CN113485871A (en) * | 2021-06-30 | 2021-10-08 | 南京壹进制信息科技有限公司 | Infinite snapshot method for oracle database |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105608150A (en) * | 2015-12-17 | 2016-05-25 | 浪潮电子信息产业股份有限公司 | Business data processing method and system |
| CN105843707A (en) * | 2016-03-28 | 2016-08-10 | 上海上讯信息技术股份有限公司 | Quick recovery method and equipment of database |
| CN107066357A (en) * | 2017-05-31 | 2017-08-18 | 广州鼎甲计算机科技有限公司 | A kind of database synthetic backup and carry restoration methods |
| CN107256182A (en) * | 2017-05-03 | 2017-10-17 | 上海上讯信息技术股份有限公司 | A kind of method and apparatus of database restoration |
| US20170300548A1 (en) * | 2012-07-20 | 2017-10-19 | Commvault Systems, Inc. | Systems and methods for database archiving |
-
2017
- 2017-12-29 CN CN201711476815.7A patent/CN108255994A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170300548A1 (en) * | 2012-07-20 | 2017-10-19 | Commvault Systems, Inc. | Systems and methods for database archiving |
| CN105608150A (en) * | 2015-12-17 | 2016-05-25 | 浪潮电子信息产业股份有限公司 | Business data processing method and system |
| CN105843707A (en) * | 2016-03-28 | 2016-08-10 | 上海上讯信息技术股份有限公司 | Quick recovery method and equipment of database |
| CN107256182A (en) * | 2017-05-03 | 2017-10-17 | 上海上讯信息技术股份有限公司 | A kind of method and apparatus of database restoration |
| CN107066357A (en) * | 2017-05-31 | 2017-08-18 | 广州鼎甲计算机科技有限公司 | A kind of database synthetic backup and carry restoration methods |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109918386A (en) * | 2019-01-31 | 2019-06-21 | 北京明略软件系统有限公司 | A kind of data reconstruction method and device, computer readable storage medium |
| CN109918386B (en) * | 2019-01-31 | 2021-04-30 | 北京明略软件系统有限公司 | Data recovery method and device and computer readable storage medium |
| CN110633265A (en) * | 2019-08-22 | 2019-12-31 | 达疆网络科技(上海)有限公司 | Method for realizing ES (ES) cross-multi-version data migration |
| CN111177260A (en) * | 2019-12-19 | 2020-05-19 | 上海上讯信息技术股份有限公司 | Database remote copying method and device and electronic equipment |
| CN111190878A (en) * | 2019-12-29 | 2020-05-22 | 北京浪潮数据技术有限公司 | Method, device, equipment and storage medium for sharing access NAS snapshot |
| CN112380058A (en) * | 2020-11-12 | 2021-02-19 | 上海上讯信息技术股份有限公司 | File recovery method and equipment |
| CN112765129A (en) * | 2021-01-11 | 2021-05-07 | 上海上讯信息技术股份有限公司 | Method and equipment for realizing database data version management |
| CN113485871A (en) * | 2021-06-30 | 2021-10-08 | 南京壹进制信息科技有限公司 | Infinite snapshot method for oracle database |
| CN113485871B (en) * | 2021-06-30 | 2024-05-24 | 航天壹进制(江苏)信息科技有限公司 | Infinite snapshot method of oracle database |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11768848B1 (en) | Retrieving, modifying, and depositing shared search configuration into a shared data store | |
| US11748394B1 (en) | Using indexers from multiple systems | |
| CN108255994A (en) | A kind of database version management method based on database snapshot | |
| CN109493076B (en) | Kafka message unique consumption method, system, server and storage medium | |
| JP7389793B2 (en) | Methods, devices, and systems for real-time checking of data consistency in distributed heterogeneous storage systems | |
| US20180018241A1 (en) | Visualizing restoration operation granularity for a database | |
| US10445186B1 (en) | Associating a guest application within a virtual machine to create dependencies in backup/restore policy | |
| CN111095219A (en) | File system point-in-time restore using recycle bin and version history | |
| US8438130B2 (en) | Method and system for replicating data | |
| US20090228530A1 (en) | Separating file data streams to enhance progressive incremental processing | |
| US10067836B1 (en) | Configuration based intelligent protection modeling | |
| US11212175B2 (en) | Configuration management for cloud storage system and method | |
| US12259798B2 (en) | Automatically implementing a specification of a data protection intent | |
| US7069270B1 (en) | Automated method and mechanism for converting a single instance application to a multiple instance application | |
| US11500738B2 (en) | Tagging application resources for snapshot capability-aware discovery | |
| US11522966B2 (en) | Methods, devices and systems for non-disruptive upgrades to a replicated state machine in a distributed computing environment | |
| US11042454B1 (en) | Restoration of a data source | |
| CN116955006A (en) | Data backup method, export method, recovery method, device, equipment and medium | |
| US20130073824A1 (en) | Copying segments of a virtual resource definition | |
| US12026056B2 (en) | Snapshot capability-aware discovery of tagged application resources | |
| CN114153858B (en) | Method and device for automatically updating tenant under MySQL table space | |
| CN118939472A (en) | A data management method and related equipment | |
| US11520668B2 (en) | Vendor-neutral models of vendors' application resources | |
| US11675931B2 (en) | Creating vendor-neutral data protection operations for vendors' application resources | |
| CN116974983A (en) | Data processing method, device, computer readable medium and electronic equipment |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180706 |