CN113360322A - Method and equipment for recovering data based on backup system - Google Patents

Method and equipment for recovering data based on backup system Download PDF

Info

Publication number
CN113360322A
CN113360322A CN202110713961.7A CN202110713961A CN113360322A CN 113360322 A CN113360322 A CN 113360322A CN 202110713961 A CN202110713961 A CN 202110713961A CN 113360322 A CN113360322 A CN 113360322A
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.)
Granted
Application number
CN202110713961.7A
Other languages
Chinese (zh)
Other versions
CN113360322B (en
Inventor
李天泽
光志龙
王倪彬
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shanghai Suninfo Technology Co ltd
Original Assignee
Shanghai Suninfo Technology Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Shanghai Suninfo Technology Co ltd filed Critical Shanghai Suninfo Technology Co ltd
Priority to CN202110713961.7A priority Critical patent/CN113360322B/en
Publication of CN113360322A publication Critical patent/CN113360322A/en
Application granted granted Critical
Publication of CN113360322B publication Critical patent/CN113360322B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1446Point-in-time backing up or restoration of persistent data
    • G06F11/1448Management of the data involved in backup or backup restore
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/11File system administration, e.g. details of archiving or snapshots
    • G06F16/128Details 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 method comprises the steps of performing full data recovery on backup data acquired from a backup system according to the time point of the backup system; carrying out full snapshot on the restored full data to obtain full snapshot points; restoring the filing log at regular time and performing incremental snapshot to obtain a plurality of incremental snapshot points; determining a recovery snapshot point according to recovery requirements, the full snapshot point and the plurality of incremental snapshot points; and cloning according to the recovery snapshot point, and recovering data according to the cloning and the corresponding filing log. Therefore, the occupied space of data storage can be reduced, data recovery at any time point can be rapidly realized, and the continuity of the filed log can be verified.

Description

Method and equipment for recovering data based on backup system
Technical Field
The present application relates to the field of computers, and in particular, to a method and an apparatus for restoring 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 full backup set is recovered first, then an incremental or differential backup set is recovered, and finally a filing log is recovered according to a specified time point, thereby completing recovery and backup verification of the database once. The next demand requires the continuous use of the flow; this approach takes the same storage space and the same amount of time per 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 an apparatus for recovering data based on a backup system, which solve the problems in the prior art that each recovery occupies the same storage space and consumes the same long time, 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 for restoring data based on a backup system, the method comprising:
performing full data recovery on the backup data acquired from the backup system according to the time point of the backup system;
carrying out full snapshot on the restored full data to obtain full snapshot points;
restoring the filing log at regular time and performing incremental snapshot to obtain a plurality of incremental snapshot points;
determining a recovery snapshot point according to recovery requirements, the full snapshot point and the plurality of incremental snapshot points;
and cloning according to the recovery snapshot point, and recovering data according to the cloning and the corresponding filing log.
Optionally, after performing full data recovery on the backup data acquired from the backup system according to the time point of the backup system, the method includes:
setting a database for storing restored backup data to a restored state, wherein the database includes an archive log.
Optionally, the periodically restoring the archive log and performing an incremental snapshot includes:
and recovering the filing log at regular time, applying the recovered filing 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 a recovery snapshot point according to the recovery requirement, the full snapshot point, and the plurality of incremental snapshot points, including:
and according to the position information required for recovery, matching a snapshot point which is closest to the position information from the full snapshot point and the plurality of incremental snapshot points, and taking the matched snapshot point as a recovery snapshot point.
Optionally, the method comprises:
and if the filing log cannot be restored, reminding operation and maintenance personnel to check the backup corresponding to the filing log.
Optionally, performing data recovery according to the clone and the corresponding archive log, including:
and restoring all the archived logs before the snapshot point recovery to the clone to obtain the data recovery of the snapshot point recovery.
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 recovery device is used for performing full data recovery on the backup data acquired from the backup system according to the time point of the backup system;
the full snapshot device is used for performing full snapshot on the restored full data to obtain full snapshot points;
the incremental snapshot device is used for recovering the filing log at regular 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 point and recovering data according to the cloning and the corresponding filing log.
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:
one or more processors; and
a memory storing computer readable instructions that, when executed, cause the processor to perform the operations of the method as previously described.
According to yet another aspect of the present application, there is also provided a computer readable medium having computer readable instructions stored thereon, the computer readable instructions being executable by a processor to implement the method as described above.
Compared with the prior art, the method and the device have the advantages that the backup data acquired from the backup system are subjected to full data recovery according to the time point of the backup system; carrying out full snapshot on the restored full data to obtain full snapshot points; restoring the filing log at regular time and performing incremental snapshot to obtain a plurality of incremental snapshot points; determining a recovery snapshot point according to recovery requirements, the full snapshot point and the plurality of incremental snapshot points; and cloning according to the recovery snapshot point, and recovering data according to the cloning and the corresponding filing log. Therefore, the occupied space of data storage can be reduced, data recovery at any time point can be rapidly realized, and the continuity of the filed log can be verified.
Drawings
Other features, objects and advantages of the present application will become more apparent upon reading of the following detailed description of non-limiting embodiments thereof, made with reference to the accompanying drawings in which:
FIG. 1 illustrates a flow diagram of a method for restoring data based on a backup system, provided in accordance with an aspect of the present application;
FIG. 2 is a schematic diagram illustrating snapshot in an embodiment of the present application;
FIG. 3 is a schematic diagram illustrating a continuous incremental recovery process according to an embodiment of the present application;
FIG. 4 is a schematic diagram illustrating a data delivery process according to an embodiment of the present application;
fig. 5 is a schematic structural diagram illustrating 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 identify the same or similar elements.
Detailed Description
The present application is described in further detail below with reference to the attached figures.
In a typical configuration of the present application, the terminal, the device serving the network, and the trusted party each include one or more processors (e.g., Central Processing Units (CPUs)), input/output interfaces, network interfaces, and memory.
The Memory may include volatile Memory in a computer readable medium, Random Access Memory (RAM), and/or nonvolatile Memory such as Read Only Memory (ROM) or flash Memory (flash RAM). Memory is an example of a computer-readable medium.
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 computer storage media include, but are not limited to, Phase-Change RAM (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read-Only Memory (EEPROM), flash Memory or other Memory technology, Compact Disc Read-Only Memory (CD-ROM), Digital Versatile Disc (DVD) or other optical storage, magnetic cassette tape, magnetic tape storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, computer readable media does not include non-transitory computer readable media (transient media), such as modulated data signals and carrier waves.
Fig. 1 is a flowchart illustrating a method for restoring data based on a backup system according to an aspect of the present application, where the method includes: step S11 to step S15, wherein, in step S11, the backup data acquired from the backup system is subjected to full data recovery according to the time point of the backup system; step S12, carrying out full snapshot on the restored full data to obtain full snapshot points; step S13, restoring the filing log at regular time and carrying out 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 the plurality of incremental snapshot points; and step 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 quickly realized, and the continuity of the filed log is verified.
Specifically, in step S11, performing full data recovery on the backup data acquired from the backup system according to the time point of the backup system; here, the backup system is a backup disaster recovery system, and may be netbackup (an enterprise-level data backup management software), commvault, network, love number, tripod head, and the like. Acquiring backed-up backup data from a backup system, and performing full data recovery on the backup data according to the time point of the backup system, namely recovering the full data to a time point for the first time, wherein the time point is any time point; the backup data includes a backup of a data file and a backup of an archive log, and the backup of the data file is used for restoring the entire data.
Specifically, in step S12, performing a full snapshot on the restored full data to obtain a full snapshot point; after the recovery of the full-volume data is completed, taking a snapshot of the recovered full-volume data, where the snapshot at this time is a full-volume snapshot, that is, a snapshot of the full-volume backup data, and a time point of taking the snapshot is a full-volume snapshot point, where a data file corresponding to the full-volume snapshot point is the recovered full-volume data.
Specifically, in step S13, the archive log is restored at regular time and an incremental snapshot is performed, so as to obtain a plurality of incremental snapshot points; the archiving log is used for archiving an online redo log in the database, the online redo log is used for recording which operations are performed on the database, such as addition and deletion operations, when the size of the online redo log is fixed, such as 1G, when a preset condition is triggered, the online redo log executes archiving, an archiving log is generated, and an archiving log backup is used during incremental recovery; thus, timing recovery of the archive log may enable timing incremental recovery, such as timing may be monthly, weekly, daily, every few hours, or every few minutes; therefore, snapshot is performed after the archive log is restored at regular time, for example, the archive log is restored once every 3 hours, a data stream with a plurality of snapshots is formed at the time interval of 3 hours, each snapshot point is an incremental snapshot point, and data restoration occurring between the incremental snapshot points belongs to incremental restoration.
Specifically, in step S14, a recovery snapshot is determined according to the recovery requirement, the full snapshot, and the plurality of incremental snapshots; the data recovery method comprises the steps that a recovery requirement indicates that a user needs a part of data, the part of data is obtained by recovering the data, a required recovery snapshot point is determined on a data stream with a plurality of snapshot points according to the proposed recovery requirement, the obtained full snapshot point and the plurality of incremental snapshot points, and backup data before the recovery snapshot point is the data required by the user.
Specifically, in step S15, cloning according to the recovery snapshot point, and performing data recovery according to the clone and the corresponding archive log; all the archived logs before the snapshot point can be restored to the clone, so that the log data restoration of the snapshot point can be obtained. The determined recovery snapshot point is cloned, namely the backup data corresponding to the snapshot point is cloned to obtain a required data file, so that the data file obtained by cloning and a corresponding filing log are utilized to recover at a specified time point, and the data recovery at any time point can be carried out through the method; therefore, the full recovery is not needed to be carried out again, and more storage and more time are not needed to be occupied; data compression and storage greatly reduce the consumption of storage by stored data.
In some embodiments of the present application, 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. When the recovery of the full data is performed for the first time, the data is recovered to a specified time point or a point corresponding to the system change number, where the specified time point may be determined according to the current service, for example, the data is recovered to a time point before the service system is upgraded, or a certain error operation time point; the System Change Number (scn) is an oracle database for recording the time axis, and each scn corresponds to a time point, so that the scn can be used for recovering the full data for the first time.
In some embodiments of the present application, after performing full data recovery on backup data acquired from a backup system according to a time point of the backup system, a database for storing the recovered backup data is set to a recovery state, where the database includes an archive log. Here, the database is used for storing the restored backup data, including the data file of the backup data, and also including the archive log; the database is changed from other states, such as an open state or a nomount state, into a recovery state (mount), the database in the state cannot be read and written, can only be used for recovery operation, and after the database state is changed into the recovery state, subsequent data recovery work can be carried out quickly.
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 volume of data, and an incremental snapshot is taken after each application. The database continuously generates an archive log, and performs timing recovery on the archive log, so as to generate a continuous data stream, and incrementally applies the archive log to the full-volume recovered data to complete incremental recovery, for example, 12 o 'clock recovery is completed, and archive from 12 o' clock to three pm hours is applied to the full-volume data, so as to recover the increment in the three hours; and when the archival log is restored at regular time, the application takes a snapshot after each restoration. As shown in fig. 2, a first full data recovery is performed at 0 am, a full snapshot is performed, an application filing log is performed at three pm, a snapshot of an incremental snapshot is obtained at this time, an application filing log is performed at six pm, a snapshot is performed again to obtain a new snapshot of the incremental snapshot, and subsequently, an application filing log and a snapshot are performed every three hours in sequence, so that a data stream with snapshots at fixed time intervals is generated. It should be noted that, in the above example, the recovery and snapshot are completed by using a fixed period, a time interval of each snapshot is fixed, a time point of the snapshot is not limited, and the snapshot may also be triggered manually at any time.
In some embodiments of the present application, in step S14, a snapshot point closest to the location information is matched from the full snapshot point and one of the incremental snapshot points according to the location information of the recovery requirement, and the matched snapshot point is used as the recovery snapshot point. Here, the location information of the recovery requirement is, for example, the required time point or other location information that can explain the location, so that the latest snapshot before the required time point or the location information that can explain the location is found according to the required time point or the location information that can explain the location, that is, the latest snapshot before the location information of the recovery requirement is found, and the snapshot may be a full snapshot or other incremental snapshots after the snapshot, so that recovery at any time point can be achieved, that is, the log data is recovered to the archive log corresponding to the snapshot that is matched to the arbitrary required time point, in this way, only the first time is recovery of the full data, and each subsequent time is incremental recovery, thereby avoiding the problems of occupied data storage space and occupied time caused by the full recovery in the past; and the quick recovery data at any time point is realized for data delivery with various requirements.
In some embodiments of the present application, the method comprises: and if the filing log cannot be restored, reminding operation and maintenance personnel to check the backup corresponding to the filing log. The continuity of the backup filing log is verified through the continuous incremental recovery of the application, if the filing log cannot be recovered, the backup is indicated to be problematic, and operation and maintenance personnel are reminded to check the corresponding backup in time.
Fig. 3 is a schematic diagram illustrating a continuous incremental restore process in an embodiment of the present application, where a full data restore of backup data is performed first, a snapshot is created after the restore, where the snapshot is the full snapshot, a log restore application is archived, and a snapshot is created again, where the snapshot is an incremental snapshot; then, as shown in fig. 4, fast data delivery is performed, snapshots are searched for according to the time points, cloning is performed according to the searched snapshots, and a required filing log is searched for, so that the specified time point is restored according to the cloning and the searched filing log, a database is opened, and fast data delivery is realized.
In addition, a computer readable medium is provided in an embodiment of the present application, and computer readable instructions are stored thereon, and the computer readable instructions can be executed by a processor to implement the foregoing method for restoring data based on a backup system.
In correspondence with the method described above, the present application also provides a terminal, which includes modules or units capable of executing the method steps described in fig. 1 or fig. 2 or various embodiments, and these modules or units can 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 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 the operations of the method as previously described.
For example, the computer readable instructions, when executed, cause the one or more processors to:
performing full data recovery on the backup data acquired from the backup system according to the time point of the backup system;
carrying out full snapshot on the restored full data to obtain full snapshot points;
restoring the filing log at regular time and performing incremental snapshot to obtain a plurality of incremental snapshot points;
determining a recovery snapshot point according to recovery requirements, the full snapshot point and the plurality of incremental snapshot points;
and cloning according to the recovery snapshot point, and recovering data according to the cloning and the corresponding filing log.
Fig. 5 is a schematic structural diagram of an apparatus for restoring data based on a backup system according to another aspect of the present application, where the apparatus includes: the system comprises a full recovery device 11, a full snapshot device 12, an incremental snapshot device 13, a determination device 14 and a fixed point recovery device 15, wherein the full recovery device 11 is used for performing full data recovery on backup data acquired from a backup system according to a 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 filing log at regular time and performing incremental snapshot to obtain a plurality of incremental snapshot points; the determining device 14 is configured to determine a recovery snapshot point according to the recovery requirement, the full snapshot point, and the plurality of incremental snapshot points; the fixed point recovery device 15 is configured to clone according to the recovery snapshot point, and perform data recovery according to the clone and a corresponding archive log.
Preferably, the incremental snapshot device 13 is configured to restore the archive log at regular time and apply the restored archive log to the restored full amount of data, and perform the incremental snapshot after each application. For example, at 0 a.m., a first full data recovery is performed and a full snapshot is performed, at three pm, an application filing log is performed, at this time, a snapshot of an incremental snapshot is obtained, at six pm, an application filing log is performed, a snapshot is performed again to obtain a new snapshot of an incremental snapshot, and subsequently, an application filing log and a snapshot are performed every three hours in sequence, so as to generate a data stream with snapshots at fixed time intervals. Then, the determining device 14 is configured to match a snapshot point closest to the location information from the full snapshot point and the multiple incremental snapshot points according to the location information of the recovery requirement, and use the matched snapshot point as a recovery snapshot point. Here, the location information of the restore demand is, for example, the required time point or other location information that can explain the location, so that the latest snapshot before the required time point or the location information that can explain the location is found according to the required time point or the location information that can explain the location, that is, the latest snapshot before the location information of the restore demand is found, and the snapshot may be a full snapshot or other incremental snapshots after the snapshot, so that the restore at any time point can be realized, that is, the backup data is restored to the archive log corresponding to the snapshot that is matched to the arbitrary required time point, in this way, only the restore of the full data is performed for the first time, and each subsequent time is incremental restore, thereby avoiding the problems of occupying data storage space and occupying time caused by the full restore in the past; and the quick recovery data at any time point is realized for data delivery with various requirements.
It should be noted that the content executed by the full volume restoring apparatus 11, the full volume snapshot apparatus 12, the incremental snapshot apparatus 13, the determining apparatus 14, and the fixed point restoring apparatus 15 is the same as or corresponding to the content in the above steps S11, S12, S13, S14, and S15, and for brevity, no further description is given here.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present application without departing from the spirit and scope of the application. Thus, if such modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is intended to include such modifications and variations as well.
It should be noted that the present application may be implemented in software and/or a combination of software and hardware, for example, implemented using Application Specific Integrated Circuits (ASICs), general purpose computers or any other similar hardware devices. In one embodiment, the software programs of the present application may be executed by a processor to implement the steps or functions described above. Likewise, the software programs (including associated data structures) of the present application may be stored in a computer readable recording medium, such as RAM memory, magnetic or optical drive or diskette and the like. Additionally, some of the 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.
In addition, some 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 through the operation of the computer. Program instructions which invoke the methods of the present application may be stored on a fixed or removable recording medium and/or transmitted via a data stream on a broadcast or other signal-bearing medium and/or stored within a working memory of a computer device operating in accordance with 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 perform a method and/or a solution according to the aforementioned embodiments of the present application.
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 attributes 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 obvious that the word "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. A plurality of units or means recited in the apparatus claims may also be implemented by one unit or means in software or hardware. The terms first, second, etc. are used to denote names, but not any particular order.

Claims (10)

1. A method for restoring data based on a backup system, the method comprising:
performing full data recovery on the backup data acquired from the backup system according to the time point of the backup system;
carrying out full snapshot on the restored full data to obtain full snapshot points;
restoring the filing log at regular time and performing incremental snapshot to obtain a plurality of incremental snapshot points;
determining a recovery snapshot point according to recovery requirements, the full snapshot point and the plurality of incremental snapshot points;
and cloning according to the recovery snapshot point, and recovering data according to the cloning and the corresponding filing log.
2. The method of claim 1, wherein after performing full data recovery on the backup data acquired from the backup system according to the time point of the backup system, the method comprises:
setting a database for storing restored backup data to a restored state, wherein the database includes an archive log.
3. The method of claim 1, wherein timing recovery of archive logs and taking incremental snapshots comprises:
and recovering the filing log at regular time, applying the recovered filing log to the recovered full data, and performing incremental snapshot after each application.
4. 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.
5. The method of claim 1 or 2, wherein determining a recovery snapshot based on recovery requirements, the full snapshot, and a plurality of incremental snapshots comprises:
and according to the position information required for recovery, matching a snapshot point which is closest to the position information from the full snapshot point and the plurality of incremental snapshot points, and taking the matched snapshot point as a recovery snapshot point.
6. The method according to claim 1, characterized in that it comprises:
and if the filing log cannot be restored, reminding operation and maintenance personnel to check the backup corresponding to the filing log.
7. The method of claim 1, wherein performing data recovery from the clone and corresponding archive log comprises:
and restoring all the archived logs before the snapshot point recovery to the clone to obtain the data recovery of the snapshot point recovery.
8. An apparatus for restoring data based on a backup system, the apparatus comprising:
the full recovery device is used for performing full data recovery on the backup data acquired from the backup system according to the time point of the backup system;
the full snapshot device is used for performing full snapshot on the restored full data to obtain full snapshot points;
the incremental snapshot device is used for recovering the filing log at regular 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 point and recovering data according to the cloning and the corresponding filing log.
9. 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 of claims 1 to 7.
10. A computer readable medium having computer readable instructions stored thereon which are executable by a processor to implement the method of any one of claims 1 to 7.
CN202110713961.7A 2021-06-25 2021-06-25 Method and equipment for recovering data based on backup system Active CN113360322B (en)

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 true CN113360322A (en) 2021-09-07
CN113360322B 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)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114036004A (en) * 2021-11-26 2022-02-11 江苏安超云软件有限公司 Data backup method, data recovery method and data recovery device
CN115328704A (en) * 2022-09-06 2022-11-11 安徽鼎甲计算机科技有限公司 File backup method, file recovery method, device, equipment and storage medium
WO2024021861A1 (en) * 2022-07-28 2024-02-01 超聚变数字技术有限公司 Data recovery method and electronic device
WO2024051090A1 (en) * 2022-09-09 2024-03-14 上海爱数信息技术股份有限公司 Data index management method, storage device, and medium

Citations (12)

* Cited by examiner, † Cited by third party
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
US20160117228A1 (en) * 2014-10-28 2016-04-28 Microsoft Corporation Point in Time Database Restore from Storage Snapshots
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
CN111125260A (en) * 2020-01-21 2020-05-08 重庆文理学院 Data synchronization method and system based on SQL Server
US10657004B1 (en) * 2015-03-23 2020-05-19 Amazon Technologies, Inc. Single-tenant recovery with a multi-tenant archive
CN112035298A (en) * 2020-09-10 2020-12-04 北京城市网邻信息技术有限公司 Data backup method and device, electronic equipment and storage medium
CN112114999A (en) * 2020-09-01 2020-12-22 阿里云计算有限公司 Data backup method, data recovery method, data backup device, data recovery device and electronic equipment
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
CN112948176A (en) * 2021-02-23 2021-06-11 上海上讯信息技术股份有限公司 DB2 database recovery method and device

Patent Citations (12)

* Cited by examiner, † Cited by third party
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
US20160117228A1 (en) * 2014-10-28 2016-04-28 Microsoft Corporation 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
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
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
CN112948176A (en) * 2021-02-23 2021-06-11 上海上讯信息技术股份有限公司 DB2 database recovery method and device

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
BRIAN PEASLAND: "Recovery and Backup", 《ORACLE DBA MENTOR》, pages 91 - 114 *
王健 等: "Oracle基于事务日志的数据恢复", 《内蒙古农业大学学报(自然科学版)》, pages 129 - 131 *
顾雯轩 等: "电网调度控制系统的备份恢复模块设计与实现", 《江苏科技信息》, pages 55 - 57 *

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114036004A (en) * 2021-11-26 2022-02-11 江苏安超云软件有限公司 Data backup method, data recovery method and data recovery device
WO2024021861A1 (en) * 2022-07-28 2024-02-01 超聚变数字技术有限公司 Data recovery method and electronic device
CN115328704A (en) * 2022-09-06 2022-11-11 安徽鼎甲计算机科技有限公司 File backup method, file recovery method, device, equipment and storage medium
WO2024051090A1 (en) * 2022-09-09 2024-03-14 上海爱数信息技术股份有限公司 Data index management method, storage device, and medium

Also Published As

Publication number Publication date
CN113360322B (en) 2023-06-13

Similar Documents

Publication Publication Date Title
CN113360322B (en) Method and equipment for recovering data based on backup system
US9348827B1 (en) File-based snapshots for block-based backups
US9645892B1 (en) Recording file events in change logs while incrementally backing up file systems
CN106407356B (en) Data backup method and device
CN107256182B (en) Method and device for restoring database
US8229896B1 (en) Method and apparatus for identifying data blocks required for restoration
US8868507B2 (en) Method and apparatus for data recovery using storage based journaling
US6665815B1 (en) Physical incremental backup using snapshots
US6871271B2 (en) Incrementally restoring a mass storage device to a prior state
US7334098B1 (en) Producing a mass storage backup using a log of write commands and time information
US20070185936A1 (en) Managing deletions in backup sets
US20090043826A1 (en) Method for Reliably Updating A Data Group In A Read-Before-Write Data Replication Environment Using A Comparison File
US20080162599A1 (en) Optimizing backup and recovery utilizing change tracking
US10146633B2 (en) Data recovery from multiple data backup technologies
US20080162600A1 (en) Optimizing backup and recovery utilizing change tracking
CN102609337A (en) Rapid data recovery method for memory database
WO2018107792A1 (en) Method and apparatus for incremental recovery of data
US10831706B2 (en) Database maintenance using backup and restore technology
CN103838645B (en) Remote difference synthesis backup method based on Hash
CN115328704A (en) File backup method, file recovery method, device, equipment and storage medium
US8595271B1 (en) Systems and methods for performing file system checks
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
CN111581016B (en) Copy data management system and method for modern application

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