US 11,755,424 B2
Restoring archived object-level database data
Paramasivam Kumarasamy, Morganville, NJ (US); Brahmaiah Vallabhaneni, Marlboro, NJ (US); Rahul S. Pawar, Marlboro, NJ (US); Henry Wallace Dornemann, Eatontown, NJ (US); Jun H. Ahn, Manalapan, NJ (US); Amey Vijaykumar Karandikar, Marlboro, NJ (US); Amit Mitkar, Manalapan, NJ (US); Muthusamy Senthilnathan, Holmdel, NJ (US); and Satish Chandra Kilaru, Manalapan, NJ (US)
Assigned to Commvault Systems, Inc., Tinton Falls, NJ (US)
Filed by Commvault Systems, Inc., Tinton Falls, NJ (US)
Filed on Apr. 23, 2021, as Appl. No. 17/239,406.
Application 17/239,406 is a continuation of application No. 16/235,212, filed on Dec. 28, 2018, granted, now 11,030,058.
Application 16/235,212 is a continuation of application No. 14/717,950, filed on May 20, 2015, granted, now 10,223,212, issued on Mar. 5, 2019.
Claims priority of provisional application 62/106,109, filed on Jan. 21, 2015.
Prior Publication US 2021/0311839 A1, Oct. 7, 2021
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 11/14 (2006.01); G06F 16/27 (2019.01); G06F 16/11 (2019.01); G06F 16/182 (2019.01); G06F 16/21 (2019.01); G06F 16/17 (2019.01); G06F 16/22 (2019.01); G06F 16/23 (2019.01); G06F 3/06 (2006.01); G06F 11/30 (2006.01); G06F 11/34 (2006.01)
CPC G06F 11/1464 (2013.01) [G06F 3/061 (2013.01); G06F 3/064 (2013.01); G06F 3/065 (2013.01); G06F 3/067 (2013.01); G06F 3/0619 (2013.01); G06F 3/0643 (2013.01); G06F 11/14 (2013.01); G06F 11/1448 (2013.01); G06F 11/1451 (2013.01); G06F 11/1458 (2013.01); G06F 11/1469 (2013.01); G06F 11/3034 (2013.01); G06F 11/3476 (2013.01); G06F 16/113 (2019.01); G06F 16/1727 (2019.01); G06F 16/184 (2019.01); G06F 16/1827 (2019.01); G06F 16/214 (2019.01); G06F 16/2282 (2019.01); G06F 16/2358 (2019.01); G06F 16/27 (2019.01); G06F 16/275 (2019.01); G06F 2201/80 (2013.01); G06F 2201/84 (2013.01)] 18 Claims
OG exemplary drawing
 
1. A system for restoring archived database data, the system comprising:
one or more computing devices comprising computer hardware configured to:
process a database file residing on one or more storage devices to identify a subset of data in the database file for archiving, the database file generated by a database application executing on the one or more computing devices;
copy the subset of the data from the database file to a volume, wherein the volume is organized as a plurality of volume blocks having a volume block size;
delete the subset of the data from the database file;
create a snapshot of the volume comprising the copied subset of data; and
divide the snapshot into a plurality of blocks having a common size;
transmit the plurality of blocks over a network connection to a secondary storage subsystem,
wherein the plurality of blocks are copied to create a secondary copy of the plurality of blocks,
wherein mapping between the plurality of blocks and corresponding locations in the secondary storage subsystem are stored in a table;
intercept a read operation by the database application to access one or more database blocks that have been removed;
determine an offset of the one or more database blocks accessed by the read operation;
identify a database block that corresponds to the offset;
initiate a request to restore the database block from the secondary storage subsystem; and
receive and restore the database block from the secondary storage subsystem,
wherein, the database block was retrieved from the secondary storage subsystem using location information stored in the table.