CN113360322B - Method and equipment for recovering data based on backup system - Google Patents
Method and equipment for recovering data based on backup system Download PDFInfo
- Publication number
- CN113360322B CN113360322B CN202110713961.7A CN202110713961A CN113360322B CN 113360322 B CN113360322 B CN 113360322B CN 202110713961 A CN202110713961 A CN 202110713961A CN 113360322 B CN113360322 B CN 113360322B
- Authority
- CN
- China
- Prior art keywords
- snapshot
- recovery
- data
- point
- full
- 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
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
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/11—File system administration, e.g. details of archiving or snapshots
- G06F16/128—Details of file system snapshots on the file-level, e.g. snapshot creation, administration, deletion
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Retry When Errors Occur (AREA)
Abstract
The application aims to provide a method and equipment for restoring data based on a backup system, wherein the method and equipment restore full data according to the time point of the backup system by using the backup data acquired from the backup system; performing full snapshot on the restored full data to obtain full snapshot points; the method comprises the steps of recovering an archive log at fixed time and performing incremental snapshot to obtain a plurality of incremental snapshot points; determining a recovery snapshot point according to the recovery requirement, the full snapshot point and a plurality of incremental snapshot points; cloning is carried out according to the recovery snapshot points, and data recovery is carried out according to the cloning and the corresponding archive logs. Therefore, the occupied space of data storage can be reduced, data recovery at any time point can be rapidly realized, and continuity of an archive log is verified.
Description
Technical Field
The present disclosure relates to the field of computers, and in particular, to a method and apparatus for recovering data based on a backup system.
Background
At present, for a database backup recovery scheme, for example, for backup recovery of an oracle database, a mode of recovering a full-volume backup set first, then recovering an incremental or differential backup set, and finally recovering an archive log according to a designated time point is used for completing primary database recovery and backup verification. The next time the demand requires the continuous use of the above-described process; this approach takes up the same memory space and takes the same amount of time for each recovery, making data verification and data demand delivery lengthy and difficult.
Disclosure of Invention
An object of the present application is to provide a method and apparatus for recovering data based on a backup system, which solves the problem that each recovery occupies the same storage space and takes the same long time in the prior art, so that data verification and data demand delivery become long and difficult.
According to one aspect of the present application, there is provided a method of restoring data based on a backup system, the method comprising:
the method comprises the steps of carrying out full data recovery on backup data acquired from a backup system according to a time point of the backup system;
performing full snapshot on the restored full data to obtain full snapshot points;
the method comprises the steps of recovering an archive log at fixed time and performing incremental snapshot to obtain a plurality of incremental snapshot points;
determining a recovery snapshot point according to the recovery requirement, the full snapshot point and a plurality of incremental snapshot points;
cloning is carried out according to the recovery snapshot points, and data recovery is carried out according to the cloning and the corresponding archive logs.
Optionally, after recovering the full data of the backup data acquired from the backup system according to the time point of the backup system, the method includes:
a database for storing restored backup data is set to a restored state, wherein the database includes an archive log.
Optionally, the timing recovery archive log and incremental snapshot comprises:
and (3) recovering the archive log regularly, applying the recovered archive log to the recovered full data, and performing incremental snapshot after each application.
Optionally, the time point of the backup system includes: a point in time determined by the current service and a point in time determined by the system change number.
Optionally, determining the recovery snapshot point according to the recovery requirement, the full snapshot point and the plurality of incremental snapshot points includes:
and matching one snapshot point closest to the position information from the full snapshot point and the plurality of incremental snapshot points according to the position information of the recovery requirement, and taking the matched snapshot point as the recovery snapshot point.
Optionally, the method comprises:
and if the archive log cannot be recovered, reminding an operation and maintenance personnel to check the backup corresponding to the archive log.
Optionally, performing data recovery according to the clone and the corresponding archive log, including:
and recovering all archive logs before the recovery snapshot point to the clone to obtain the data recovery of the recovery snapshot point.
According to another aspect of the present application, there is also provided an apparatus for restoring data based on a backup system, the apparatus including:
the full-quantity recovery device is used for recovering the full-quantity data of the backup data acquired from the backup system according to the time point of the backup system;
the full snapshot device is used for carrying out full snapshot on the restored full data to obtain full snapshot points;
the incremental snapshot device is used for recovering the archive log at fixed time and performing incremental snapshot to obtain a plurality of incremental snapshot points;
the determining device is used for determining a recovery snapshot point according to the recovery requirement, the full snapshot point and the plurality of incremental snapshot points;
and the fixed point recovery device is used for cloning according to the recovery snapshot points and recovering data according to the cloning and the corresponding archive logs.
According to still another aspect of the present application, there is also provided an apparatus for restoring data based on a backup system, the apparatus including:
one or more processors; and
a memory storing computer readable instructions that, when executed, cause the processor to perform operations of the method as described above.
According to yet another aspect of the present application, there is also provided a computer readable medium having stored thereon computer readable instructions executable by a processor to implement a method as described above.
Compared with the prior art, the method and the device for recovering the full data of the backup data have the advantages that the full data recovery is carried out on the backup data obtained from the backup system according to the time point of the backup system; performing full snapshot on the restored full data to obtain full snapshot points; the method comprises the steps of recovering an archive log at fixed time and performing incremental snapshot to obtain a plurality of incremental snapshot points; determining a recovery snapshot point according to the recovery requirement, the full snapshot point and a plurality of incremental snapshot points; cloning is carried out according to the recovery snapshot points, and data recovery is carried out according to the cloning and the corresponding archive logs. Therefore, the occupied space of data storage can be reduced, data recovery at any time point can be rapidly realized, and continuity of an archive log is verified.
Drawings
Other features, objects and advantages of the present application will become more apparent upon reading of the detailed description of non-limiting embodiments, made with reference to the following drawings, in which:
FIG. 1 illustrates a flow diagram of a method for restoring data based on a backup system in accordance with an aspect of the present application;
FIG. 2 is a schematic diagram of snapshot taking in an embodiment of the present application;
FIG. 3 is a schematic diagram of a continuous incremental recovery process according to one embodiment of the present application;
FIG. 4 is a schematic diagram of a data delivery flow in an embodiment of the present application;
fig. 5 is a schematic structural diagram of an apparatus for restoring data based on a backup system according to still another aspect of the present application.
The same or similar reference numbers in the drawings refer to the same or similar parts.
Detailed Description
The present application is described in further detail below with reference to the accompanying drawings.
In one typical configuration of the present application, the terminal, the devices of the service network, and the trusted party each include one or more processors (e.g., central processing units (Central Processing Unit, CPU)), input/output interfaces, network interfaces, and memory.
The Memory may include non-volatile Memory in a computer readable medium, random access Memory (Random Access Memory, RAM) and/or non-volatile Memory, etc., such as Read Only Memory (ROM) or flash RAM. Memory is an example of computer-readable media.
Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase-Change RAM (PRAM), static random access Memory (Static Random Access Memory, SRAM), dynamic random access Memory (Dynamic Random Access Memory, DRAM), other types of Random Access Memory (RAM), read-Only Memory (ROM), electrically erasable programmable read-Only Memory (Electrically Erasable Programmable Read-Only Memory, EEPROM), flash Memory or other Memory technology, read-Only optical disk read-Only Memory (Compact Disc Read-Only Memory, CD-ROM), digital versatile disks (Digital Versatile Disk, DVD) or other optical storage, magnetic cassettes, magnetic tape disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by the computing device. Computer readable media, as defined herein, does not include non-transitory computer readable media (transmission media), such as modulated data signals and carrier waves.
FIG. 1 is a flow chart of a method for restoring data based on a backup system according to one aspect of the present application, the method comprising: step S11 to step S15, wherein, step S11, the backup data obtained from the backup system is recovered according to the time point of the backup system; step S12, performing full snapshot on the restored full data to obtain full snapshot points; step S13, recovering the archive log at fixed time and performing incremental snapshot to obtain a plurality of incremental snapshot points; step S14, determining a recovery snapshot point according to the recovery requirement, the full snapshot point and a plurality of incremental snapshot points; and S15, cloning according to the recovery snapshot point, and recovering data according to the cloning and the corresponding archive log. Therefore, the occupied space of data storage can be reduced, data recovery at any time point can be realized rapidly, and continuity of the archive log is verified.
Specifically, in step S11, full-scale data recovery is performed on backup data acquired from a backup system according to a time point of the backup system; the backup system is a backup disaster recovery system, and may be netbackup (an enterprise-level data backup management software), commvault, networker, love-count, ding-Jia, etc. The backup data which is backed up is obtained from the backup system, and the backup data is subjected to full data recovery according to the time point of the backup system, namely the full data is recovered to a time point for the first time, and the time point is any time point; the backup data comprises the backup of the data files and the backup of the archive logs, and the backup of the data files is used when the total data is restored.
Specifically, in step S12, the restored full-volume data is subjected to full-volume snapshot, so as to obtain full-volume snapshot points; when the recovery of the full-volume data is completed, the recovered full-volume data is snapshot, wherein the snapshot is the full-volume snapshot, that is, one snapshot of the full-volume backup data, and the snapshot time point is the full-volume snapshot point, and the full-volume data is recovered in the data file corresponding to the full-volume snapshot point.
Specifically, in step S13, the archive log is periodically restored and incremental snapshots are performed, so as to obtain a plurality of incremental snapshot points; the archiving log is the archiving of the online redo log in the database, the online redo log is used for recording which operations, such as adding and deleting operations, are performed on the database, when the online redo log is fixed in size, such as 1G, the online redo log performs archiving when a preset condition is triggered, an archiving log is generated, and the archiving log is used for backup when the increment is recovered; thus, performing timing recovery of the archive log may enable timing delta recovery, such as the timing may be monthly, weekly, daily, every few hours, or every few minutes; and when the archive log is restored at regular time, for example, the archive log is restored every 3 hours, a data stream with a plurality of snapshots with a time interval of 3 hours is formed, each snapshot point is an incremental snapshot point, and the data restoration between the incremental snapshot points belongs to the incremental restoration.
Specifically, in step S14, a recovery snapshot point is determined according to the recovery requirement, the full snapshot point, and a plurality of incremental snapshot points; the recovery requirement is that the user needs a piece of data, the data is obtained through the recovery data, the required recovery snapshot point is determined on the data stream with a plurality of snapshot points according to the proposed recovery requirement, the obtained full snapshot points and the plurality of incremental snapshot points, and the backup data before the recovery snapshot point is the data required by the user.
Specifically, in step S15, cloning is performed according to the recovery snapshot point, and data recovery is performed according to the cloning and the corresponding archive log; and recovering all archive logs before the recovery snapshot point to the clone to obtain log data recovery of the recovery snapshot point. The method comprises the steps of cloning a determined recovery snapshot point, namely cloning backed-up data corresponding to the snapshot point to obtain a required data file, so that the data file obtained by cloning and a corresponding archive log are used for recovering at a designated time point, and the data recovery at any time point can be carried out through the method; therefore, the full recovery is not needed again, and more storage and more time are not needed to be occupied; data compression storage greatly reduces the consumption of storage by stored data.
In some embodiments of the present application, the time points of the backup system include: a point in time determined by the current service and a point in time determined by the system change number. When the recovery of the full data is performed for the first time, the data is recovered to a designated time point or a point corresponding to a system change number, wherein the designated time point can be determined according to the current service, for example, to a certain time point before the service system is upgraded or to a certain error operation time point; the system change numbers (System Change Number, scn) are oracle databases for recording time axes, each scn corresponding to a point in time, so that scn points can be used to recover full data for the first time.
In some embodiments of the present application, after full-volume data restoration is performed on backup data acquired from a backup system according to a time point of the backup system, a database for storing restored backup data is set to a restored state, where the database includes an archive log. The database is used for storing the restored backup data, and comprises a data file of the backup data and an archive log; the database is changed from other states, such as open or non state, to a recovery state (mount), and the database in the state cannot be read and written, and can only be used for recovery operation.
In some embodiments of the present application, in step S13, the archive log is periodically restored and the restored archive log is applied to the restored full data, with incremental snapshots being performed after each application. The database continuously generates an archive log, and performs timing recovery on the archive log to generate a continuous data stream, and the archive log is incrementally applied to the full-volume recovered data to complete incremental recovery, for example, 12-point recovery is completed, three hours of archive from 12 to three afternoon is applied to the full-volume data, and the increment in the three hours is recovered; and further, when the timing recovery archive log is carried out, the application carries out snapshot after each recovery. As shown in fig. 2, the first full-volume data recovery and full-volume snapshot are performed in the early 0 hours, the application archive log is performed at three afternoon, the snapshot is performed at this time, a snapshot point of one increment snapshot is obtained, the application archive log is performed at six afternoon, the snapshot is performed again, a new snapshot point of one increment snapshot is obtained, the application archive log and the snapshot are performed sequentially according to every three hours, and then a data stream with the snapshot at a fixed time interval is generated. It should be noted that, the above example is to use a fixed period to complete recovery and snapshot, the time interval of each snapshot is fixed, the time point of snapshot is not limited, and the snapshot may be triggered manually at any time.
In some embodiments of the present application, in step S14, according to the location information of the recovery requirement, one snapshot point closest to the location information is matched from the full snapshot point and the multiple incremental snapshot points, and the matched snapshot point is used as the recovery snapshot point. The location information of the recovery requirement is, for example, the required time point or other information capable of indicating the location, so that the latest snapshot point before the required time point or the position information can be found according to the required time point or the position information capable of indicating the location information, namely, the latest snapshot point before the location information of the recovery requirement is found, the snapshot point can be a full snapshot point or other increment snapshot points, so that the recovery of any time point can be realized, namely, the recovery of log data to the archive log corresponding to the snapshot point matched with the time point of any requirement is realized, the mode is that the recovery of the full data is only performed for the first time, the increment recovery is performed for each subsequent time, and the problems of occupied data storage space and occupied time brought by the full recovery in the past are avoided; the recovery data at any time point can be quickly realized for data delivery of various requirements.
In some embodiments of the present application, the method comprises: and if the archive log cannot be recovered, reminding an operation and maintenance personnel to check the backup corresponding to the archive log. Here, the continuity of the backup archive log is verified through the continuous incremental recovery of the application, if the archive log cannot be recovered, the backup is problematic, and the operation and maintenance personnel are timely reminded to check the corresponding backup.
FIG. 3 is a schematic diagram of a continuous incremental recovery process according to an embodiment of the present application, wherein full-volume data recovery of backup data is performed first, and then a snapshot is created after recovery, and the snapshot is the full-volume snapshot, then an archive log recovery application creates the snapshot again, and the snapshot is the incremental snapshot; and then, as shown in fig. 4, performing quick data delivery, searching for a snapshot according to the time point, cloning according to the searched snapshot, and searching for a required archive log, so that the database is started according to the cloning and the searched archive log to restore to the designated time point, and quick data delivery is realized.
In addition, embodiments of the present application provide a computer readable medium having computer readable instructions stored thereon, the computer readable instructions being executable by a processor to implement a method of restoring data based on a backup system as described above.
Corresponding to the above-described method, the present application further provides a terminal, which includes modules or units capable of performing the steps of the method described in fig. 1 or fig. 2 or the respective embodiments, where the modules or units may be implemented by hardware, software or a combination of hardware and software, and the present application is not limited thereto. For example, in an embodiment of the present application, there is further provided an apparatus for restoring data based on a backup system, where the apparatus includes:
one or more processors; and
a memory storing computer readable instructions that, when executed, cause the processor to perform operations of the method as described above.
For example, computer-readable instructions, when executed, cause the one or more processors to:
the method comprises the steps of carrying out full data recovery on backup data acquired from a backup system according to a time point of the backup system;
performing full snapshot on the restored full data to obtain full snapshot points;
the method comprises the steps of recovering an archive log at fixed time and performing incremental snapshot to obtain a plurality of incremental snapshot points;
determining a recovery snapshot point according to the recovery requirement, the full snapshot point and a plurality of incremental snapshot points;
cloning is carried out according to the recovery snapshot points, and data recovery is carried out according to the cloning and the corresponding archive logs.
Fig. 5 is a schematic structural diagram of an apparatus for restoring data based on a backup system according to still another aspect of the present application, where the apparatus includes: the device comprises a full-quantity restoring device 11, a full-quantity snapshot device 12, an incremental snapshot device 13, a determining device 14 and a fixed-point restoring device 15, wherein the full-quantity restoring device 11 is used for restoring the full-quantity data of the backup data acquired from the backup system according to the time point of the backup system; the full snapshot device 12 is configured to perform full snapshot on the restored full data to obtain a full snapshot point; the incremental snapshot device 13 is used for recovering the archive log at fixed time and performing incremental snapshot to obtain a plurality of incremental snapshot points; the determining means 14 is configured to determine a recovery snapshot point according to the recovery requirement, the full snapshot point, and a plurality of incremental snapshot points; the fixed point recovery device 15 is used for cloning according to the recovery snapshot point and recovering data according to the cloning and the corresponding archive log.
Preferably, the incremental snapshot device 13 is configured to periodically restore the archive log and apply the restored archive log to the restored full data, and perform an incremental snapshot after each application. For example, the method comprises the steps of performing full-volume data recovery for the first time and performing full-volume snapshot in the early 0 am, performing application archiving log at three afternoon, performing snapshot at the moment, obtaining a snapshot point of one increment snapshot, performing application archiving log at six afternoon, performing snapshot again, obtaining a snapshot point of one new increment snapshot, performing application archiving log and performing snapshot sequentially every three hours, and further generating a data stream with snapshots at fixed time intervals. Next, the determining device 14 is configured to match, according to the location information of the recovery requirement, one snapshot point closest to the location information from the full snapshot point and the plurality of incremental snapshot points, and take the matched snapshot point as the recovery snapshot point. The location information of the recovery requirement is, for example, the required time point or other information capable of indicating the location, so that the latest snapshot point before the required time point or the position information can be found according to the required time point or the position information capable of indicating the location information, namely, the latest snapshot point before the location information of the recovery requirement is found, the snapshot point can be a full snapshot point or other increment snapshot points, so that the recovery of any time point can be realized, namely, the backup data is recovered to the archive log corresponding to the snapshot point matched with the time point of any requirement, the mode is only that the full data is recovered for the first time, the increment recovery is carried out for each subsequent time, and the problems of occupied data storage space and occupied time brought by the full recovery in the past are avoided; the recovery data at any time point can be quickly realized for data delivery of various requirements.
It should be noted that, the content executed by the full-dose restoring device 11, the full-dose snapshot device 12, the incremental snapshot device 13, the determining device 14, and the fixed-point restoring device 15 is the same as or the same as the content executed by the steps S11, S12, S13, S14, and S15, respectively, and is not described herein for brevity.
It will be apparent to those skilled in the art that various modifications and variations can be made in the present application without departing from the spirit or scope of the application. Thus, if such modifications and variations of the present application fall within the scope of the claims and the equivalents thereof, the present application is intended to cover such modifications and variations.
It should be noted that the present application may be implemented in software and/or a combination of software and hardware, for example, using Application Specific Integrated Circuits (ASIC), a general purpose computer or any other similar hardware device. In one embodiment, the software programs of the present application may be executed by a processor to implement the steps or functions as described above. Likewise, the software programs of the present application (including associated data structures) may be stored on a computer readable recording medium, such as RAM memory, magnetic or optical drive or diskette and the like. In addition, some steps or functions of the present application may be implemented in hardware, for example, as circuitry that cooperates with the processor to perform various steps or functions.
Furthermore, portions of the present application may be implemented as a computer program product, such as computer program instructions, which when executed by a computer, may invoke or provide methods and/or techniques in accordance with the present application by way of operation of the computer. Program instructions for invoking the methods of the present application may be stored in fixed or removable recording media and/or transmitted via a data stream in a broadcast or other signal bearing medium and/or stored within a working memory of a computer device operating according to the program instructions. An embodiment according to the present application comprises an apparatus comprising a memory for storing computer program instructions and a processor for executing the program instructions, wherein the computer program instructions, when executed by the processor, trigger the apparatus to operate a method and/or a solution according to the embodiments of the present application as described above.
It will be evident to those skilled in the art that the present application is not limited to the details of the foregoing illustrative embodiments, and that the present application may be embodied in other specific forms without departing from the spirit or essential characteristics thereof. The present embodiments are, therefore, to be considered in all respects as illustrative and not restrictive, the scope of the application 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 is evident that the word "comprising" does not exclude other elements or steps, and that the singular does not exclude a plurality. A plurality of units or means recited in the apparatus claims can also be implemented by means of one unit or means in software or hardware. The terms first, second, etc. are used to denote a name, but not any particular order.
Claims (9)
1. A method for restoring data based on a backup system, which is applied to an oracle database, and is characterized in that the method comprises the following steps:
the method comprises the steps of carrying out full data recovery on backup data acquired from a backup system according to a time point of the backup system;
setting a database for storing the restored backup data into a restored state, wherein the database comprises data files and archive logs of the backup data;
performing full snapshot on the restored full data to obtain full snapshot points;
the method comprises the steps of recovering an archive log at fixed time and performing incremental snapshot to obtain a plurality of incremental snapshot points;
determining a recovery snapshot point according to the recovery requirement, the full snapshot point and a plurality of incremental snapshot points;
cloning is carried out according to the recovery snapshot points, and data recovery at a designated time point is carried out according to the cloning and the corresponding archive logs.
2. The method of claim 1, wherein timing recovery of the archive log and incremental snapshot comprises:
and (3) recovering the archive log regularly, applying the recovered archive log to the recovered full data, and performing incremental snapshot after each application.
3. The method of claim 1, wherein the point in time of the backup system comprises: a point in time determined by the current service and a point in time determined by the system change number.
4. The method of claim 1, wherein determining a recovery snapshot point based on recovery requirements, the full snapshot point, and a plurality of incremental snapshot points comprises:
and matching one snapshot point closest to the position information from the full snapshot point and the plurality of incremental snapshot points according to the position information of the recovery requirement, and taking the matched snapshot point as the recovery snapshot point.
5. The method according to claim 1, characterized in that the method comprises:
and if the archive log cannot be recovered, reminding an operation and maintenance personnel to check the backup corresponding to the archive log.
6. The method of claim 1, wherein performing data recovery from the clone and corresponding archive log comprises:
and recovering all archive logs before the recovery snapshot point to the clone to obtain the data recovery of the recovery snapshot point.
7. An apparatus for restoring data based on a backup system, applied to an oracle database, comprising:
the full-quantity recovery device is used for carrying out full-quantity data recovery on the backup data acquired from the backup system according to the time point of the backup system, and setting a database for storing the recovered backup data into a recovery state, wherein the database comprises data files and archive logs of the backup data;
the full snapshot device is used for carrying out full snapshot on the restored full data to obtain full snapshot points;
the incremental snapshot device is used for recovering the archive log at fixed time and performing incremental snapshot to obtain a plurality of incremental snapshot points;
the determining device is used for determining a recovery snapshot point according to the recovery requirement, the full snapshot point and the plurality of incremental snapshot points;
and the fixed point recovery device is used for cloning according to the recovery snapshot points and recovering the data at the appointed time point according to the cloning and the corresponding archive log.
8. An apparatus for restoring data based on a backup system, the apparatus comprising:
one or more processors; and
a memory storing computer readable instructions that, when executed, cause the processor to perform the operations of the method of any one of claims 1 to 6.
9. A computer readable medium having stored thereon computer readable instructions executable by a processor to implement the method of any of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110713961.7A CN113360322B (en) | 2021-06-25 | 2021-06-25 | Method and equipment for recovering data based on backup system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110713961.7A CN113360322B (en) | 2021-06-25 | 2021-06-25 | Method and equipment for recovering data based on backup system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113360322A CN113360322A (en) | 2021-09-07 |
| CN113360322B true CN113360322B (en) | 2023-06-13 |
Family
ID=77536529
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110713961.7A Active CN113360322B (en) | 2021-06-25 | 2021-06-25 | Method and equipment for recovering data based on backup system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113360322B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114036004B (en) * | 2021-11-26 | 2022-09-30 | 江苏安超云软件有限公司 | Data backup method, recovery method and device |
| CN115421968A (en) * | 2022-07-28 | 2022-12-02 | 超聚变数字技术有限公司 | Data recovery method and electronic equipment |
| CN115328704A (en) * | 2022-09-06 | 2022-11-11 | 安徽鼎甲计算机科技有限公司 | File backup method, file recovery method, device, equipment and storage medium |
| CN115509807A (en) * | 2022-09-09 | 2022-12-23 | 上海爱数信息技术股份有限公司 | Backup data index management method, storage device and medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2007140700A (en) * | 2005-11-15 | 2007-06-07 | Hitachi Ltd | Computer system, management computer, storage system and backup management method |
| CN106339274A (en) * | 2015-07-14 | 2017-01-18 | 阿里巴巴集团控股有限公司 | Method and system for obtaining data snapshot |
| CN107256182A (en) * | 2017-05-03 | 2017-10-17 | 上海上讯信息技术股份有限公司 | A kind of method and apparatus of database restoration |
| US10146631B1 (en) * | 2015-09-30 | 2018-12-04 | EMC IP Holding Company LLC | Incremental forever backups for exchange |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9558078B2 (en) * | 2014-10-28 | 2017-01-31 | Microsoft Technology Licensing, Llc | Point in time database restore from storage snapshots |
| US10657004B1 (en) * | 2015-03-23 | 2020-05-19 | Amazon Technologies, Inc. | Single-tenant recovery with a multi-tenant archive |
| CN111125260A (en) * | 2020-01-21 | 2020-05-08 | 重庆文理学院 | Data synchronization method and system based on SQL Server |
| CN112114999A (en) * | 2020-09-01 | 2020-12-22 | 阿里云计算有限公司 | Data backup method, data recovery method, data backup device, data recovery device and electronic equipment |
| CN112035298A (en) * | 2020-09-10 | 2020-12-04 | 北京城市网邻信息技术有限公司 | Data backup method and device, electronic equipment and storage medium |
| CN112269681A (en) * | 2020-10-16 | 2021-01-26 | 苏州浪潮智能科技有限公司 | Method, device and equipment for continuously protecting virtual machine data |
| CN112363807A (en) * | 2020-11-27 | 2021-02-12 | 上海爱数信息技术股份有限公司 | Production system arbitrary time pipe taking system and method thereof |
| CN112948176B (en) * | 2021-02-23 | 2023-09-15 | 上海上讯信息技术股份有限公司 | DB2 database recovery method and device |
-
2021
- 2021-06-25 CN CN202110713961.7A patent/CN113360322B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2007140700A (en) * | 2005-11-15 | 2007-06-07 | Hitachi Ltd | Computer system, management computer, storage system and backup management method |
| CN106339274A (en) * | 2015-07-14 | 2017-01-18 | 阿里巴巴集团控股有限公司 | Method and system for obtaining data snapshot |
| US10146631B1 (en) * | 2015-09-30 | 2018-12-04 | EMC IP Holding Company LLC | Incremental forever backups for exchange |
| CN107256182A (en) * | 2017-05-03 | 2017-10-17 | 上海上讯信息技术股份有限公司 | A kind of method and apparatus of database restoration |
Non-Patent Citations (3)
| Title |
|---|
| Oracle基于事务日志的数据恢复;王健 等;《内蒙古农业大学学报（自然科学版）》;第129-131页 * |
| Recovery and Backup;Brian Peasland;《Oracle DBA Mentor》;第91-114页 * |
| 电网调度控制***的备份恢复模块设计与实现;顾雯轩 等;《江苏科技信息》;第55-57页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113360322A (en) | 2021-09-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113360322B (en) | Method and equipment for recovering data based on backup system | |
| US11740974B2 (en) | Restoring a database using a fully hydrated backup | |
| CN106407356B (en) | Data backup method and device | |
| CN107256182B (en) | Method and device for restoring database | |
| US9645892B1 (en) | Recording file events in change logs while incrementally backing up file systems | |
| US7197665B2 (en) | Physical incremental backup using snapshots | |
| EP1640868B1 (en) | Method and system for synthetic backup and restore | |
| US20060149798A1 (en) | Method and apparatus for data recovery using storage based journaling | |
| EP3796174A1 (en) | Restoring a database using a fully hydrated backup | |
| US8762347B1 (en) | Method and apparatus for processing transactional file system operations to enable point in time consistent file data recreation | |
| US8918606B1 (en) | Techniques for providing incremental backups | |
| US10831706B2 (en) | Database maintenance using backup and restore technology | |
| US10146633B2 (en) | Data recovery from multiple data backup technologies | |
| US11221983B1 (en) | Multi-level indexing of backup files | |
| US9483485B1 (en) | Restore database from backup system where full and incremental backups are performed simultaneously | |
| US8595271B1 (en) | Systems and methods for performing file system checks | |
| CN114090332A (en) | Data processing method and device | |
| US10489252B2 (en) | Rotating incremental data backup | |
| US10228879B1 (en) | System and method for backup and restore of offline disks in mainframe computers | |
| US11403192B1 (en) | Enabling point-in-time recovery for databases that change transaction log recovery models | |
| CN111625396A (en) | Backup data verification method, server and storage medium | |
| CN112948176B (en) | DB2 database recovery method and device | |
| CN115658391A (en) | Backup recovery method of WAL mechanism based on QianBase MPP database | |
| CN112732489B (en) | Data desensitization method and device based on database virtualization | |
| US20130290385A1 (en) | Durably recording events for performing file system operations |
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 |