Patent ID: 11966297
Assignee: EMC IP HOLDING COMPANY LLC
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
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.