Granted Patent B2

US 11,966,297 · App. 17/075,108 · Granted Apr 23, 2024

Inventors: Navneet Upadhyay (Ghaziabad, IN); Rejith Mohan M (Thiruvanathapuram, IN); Amith Ramachandran (Bangalore, IN); Shelesh Chopra (Bangalore, IN)

Assignee: EMC IP Holding Company LLC

G06F11/1448G06F16/219

Abstract

Claims (36)

1. A system for identifying database archive log dependencies and backup copy recoverability, comprising:

one or more processors; and

a non-transitory computer readable medium storing a plurality of instructions, which when executed, cause the one or more processors to:

extract backup metadata for backup copies, the metadata comprising system committed change numbers, system change numbers, types, database version identifiers, and details, the backup copies including at least a full backup copy and archive log backup copies;

generate a data structure for the archive log backup copies, comprising start system change numbers, based on minimums of the system committed change numbers, end system change numbers, based on maximums of the system change numbers, the database version identifiers, and identifiers including the details, of the archive log backup copies based on the extracted backup metadata, the data structure providing a mapping to identify dependencies of the archive log backup copies;

identify dependent system change numbers for archive logs that the full backup copy depends on, based on a start system change number to an end system change number for the full backup copy corresponding to a database version identifier;

identify, in the data structure, backed-up system change numbers, for archive log backup copies that correspond to the database version identifier and are included in the dependent system change numbers, based on the start system change numbers to the end system change numbers; and

store the backup copy, with each archive log backup copy which corresponds to the backed-up system change numbers, in recovery storage and protect the backup copy from being modified by any updates, in response to a determination that the backed-up system change numbers include all of the dependent system change numbers.

2. The system of claim 1 , wherein the plurality of instructions further causes the processor to retrieve information about the backup copies, wherein retrieving information about the backup copies comprises communicating a discovery request for application resources between a backup server and an application host, the backup copy comprises one of a full backup copy, an incremental cumulative backup copy, and an incremental differential backup copy, and storing in recovery storage comprises at least one of replicating and moving to the recovery storage.

3. The system of claim 1 , wherein the plurality of instructions further causes the processor to prevent storing the backup copy to the recovery storage, in response to a determination that the backed-up system change numbers do not include all of the dependent system change numbers.

4. The system of claim 1 , wherein the plurality of instructions further causes the processor to at least one of enable the backup copy to be modified by any updates received for the backup copy, and suggest a corrective action to a system user, in response to a determination that the backed-up system change numbers do not include all of the dependent system change numbers.

5. The system of claim 1 , wherein the plurality of instructions further causes the processor to output identifiers of the dependent system change numbers that are missing from the backed-up system change numbers as missing system change numbers, in response to a determination that the backup system change numbers do not include all of the dependent system change numbers.

6. The system of claim 5 , wherein the plurality of instructions further causes the processor to protect archive logs corresponding to the missing system change numbers from being deleted until one of a creation and a deletion of a backup copy that includes the corresponding archive logs.

7. A computer-implemented method for identifying database archive log dependencies and backup copy recoverability, the computer-implemented method comprising:

extracting backup metadata for backup copies, the metadata comprising system committed change numbers, system change numbers, types, database version identifiers, and details, the backup copies including at least a full backup copy and archive log backup copies;

generating a data structure for the archive log backup copies, comprising start system change numbers, based on minimums of the system committed change numbers, end system change numbers, based on maximums of the system change numbers, the database version identifiers, and identifiers including the details, of the archive log backup copies based on the extracted backup metadata, the data structure providing a mapping to identify dependencies of the archive log backup copies;

identifying dependent system change numbers for archive logs that the full backup copy depends on, based on a start system change number to an end system change number for the full backup copy corresponding to a database version identifier;

identifying, in the data structure, backed-up system change numbers, for archive log backup copies that correspond to the database version identifier and are included in the dependent system change numbers, based on the start system change numbers to the end system change numbers; and

storing the backup copy, with each archive log backup copy which corresponds to the backed-up system change numbers, in recovery storage and protect the backup copy from being modified by any updates, in response to a determination that the backed-up system change numbers include all of the dependent system change numbers.

8. The computer-implemented method of claim 7 , wherein the computer-implemented method further comprises retrieving information about the backup copies, wherein retrieving information about the backup copies comprises communicating a discovery request for application resources between a backup server and an application host, the backup copy comprises one of a full backup copy, an incremental cumulative backup copy, and an incremental differential backup copy, and storing in recovery storage comprises at least one of replicating and moving to the recovery storage.

9. The computer-implemented method of claim 7 , wherein the computer-implemented method further comprises preventing storing the backup copy to the recovery storage, in response to a determination that the backed-up system change numbers do not include all of the dependent system change numbers.

10. The computer-implemented method of claim 7 , wherein the computer-implemented method further comprises at least one of enabling the backup copy to be modified by any updates received for the backup copy, and suggesting a corrective action to a system user, in response to a determination that the backed-up system change numbers do not include all of the dependent system change numbers.

11. The computer-implemented method of claim 7 , wherein the computer-implemented method further comprises outputting identifiers of the dependent system change numbers that are missing from the backed-up system change numbers as missing system change numbers, in response to a determination that the backup system change numbers do not include all of the dependent system change numbers.

12. The computer-implemented method of claim 11 , wherein the computer-implemented method further comprises protecting archive logs corresponding to the missing system change numbers from being deleted until one of a creation and a deletion of a backup copy that includes the corresponding archive logs.

13. A computer program product, comprising a non-transitory computer-readable medium having a computer-readable program code embodied therein to be executed by one or more processors, the program code including instructions to:

extract backup metadata for backup copies, the metadata comprising system committed change numbers, system change numbers, types, database version identifiers, and details, for the backup copies including at least a full backup copy and archive log backup copies;

generate a data structure for the archive log backup copies, comprising start system change numbers, based on minimums of the system committed change numbers, end system change numbers, based on maximums of the system change numbers, the database version identifiers, and identifiers including the details, of the archive log backup copies based on the extracted backup metadata, the data structure providing a mapping to identify dependencies of the archive log backup copies;

identify dependent system change numbers for archive logs that the full backup copy depends on based on a start system change number to an end system change number for the full backup copy corresponding to a database version identifier;

identify, in the data structure, backed-up system change numbers, for archive log backup copies that correspond to the database version identifier and are included in the dependent system change numbers, based on the start system change numbers to the end system change numbers; and

store the backup copy, with each archive log backup copy which corresponds to the backed-up system change numbers, in recovery storage and protect the backup copy from being modified by any updates, in response to a determination that the backed-up system change numbers include all of the dependent system change numbers.

14. The computer program product of claim 13 , wherein the program code includes further instructions to retrieve information about the backup copies, wherein retrieving information about the backup copies comprises communicating a discovery request for application resources between a backup server and an application host, the backup copy comprises one of a full backup copy, an incremental cumulative backup copy, and an incremental differential backup copy, and storing in recovery storage comprises at least one of replicating and moving to the recovery storage.

15. The computer program product of claim 13 , wherein the program code includes further instructions to prevent storing the backup copy to the recovery storage, in response to a determination that the backed-up system change numbers do not include all of the dependent system change numbers.

16. The computer program product of claim 13 , wherein the program code includes further instructions to at least one of enable the backup copy to be modified by any updates received for the backup copy, and suggest a corrective action to a system user, in response to a determination that the backed-up system change numbers do not include all of the dependent system change numbers.

17. The computer program product of claim 13 , wherein the program code includes further instructions to:

output identifiers of the dependent system change numbers that are missing from the backed-up system change numbers as missing system change numbers, in response to a determination that the backup system change numbers do not include all of the dependent system change numbers; and

protect archive logs corresponding to the missing system change numbers from being deleted until one of a creation and a deletion of a backup copy that includes the corresponding archive logs.

Assignments (9)

Continuity (1)

Cited By (1)

US 12,408,019