RESTORING ARCHIVED OBJECT-LEVEL DATABASE DATA
First Claim
1. An information management system for archiving and restoring database data, the system comprising:
- a data agent comprising computer hardware configured to;
process a database file residing on one or more first storage devices to identify a subset of data in the database file for archiving, the database file generated by a database application executing on a client computing device comprising computer hardware;
extract the subset of the data from the database file and store the subset of the data in an archive file on the one or more first storage devices, the archive file contained within a first volume;
delete the subset of the data from the database file;
create a snapshot of the first volume, the snapshot of the first volume being stored on the one or more first storage devices; and
divide the snapshot of the first volume into a plurality of blocks having a common size; and
at least one secondary storage controller computer comprising hardware and residing in a secondary storage subsystem, the secondary storage controller computer configured to, as part of a secondary copy operation in which the snapshot of the first volume is copied to one or more secondary storage devices in the secondary storage subsystem;
receive the plurality of blocks over a network connection;
copy the plurality of blocks to the one or more secondary storage devices to create a secondary copy of the first volume; and
create a table that provides a mapping between the copied plurality of blocks and corresponding locations in the one or more secondary storage devices.
2 Assignments
0 Petitions
Accused Products
Abstract
According to certain aspects, a system may include a data agent configured to: process a database file residing on a primary storage device(s) to identify a subset of data in the database file for archiving, the database file generated by a database application; and extract the subset of the data from the database file and store the subset of the data in an archive file on the primary storage device(s) as a plurality of blocks having a common size; and at least one secondary storage controller computer configured to, as part of a secondary copy operation in which the archive file is copied to a secondary storage device(s): copy the plurality of blocks to the secondary storage devices to create a secondary copy of the archive file; and create a table that provides a mapping between the copied plurality of blocks and corresponding locations in the secondary storage device(s).
-
Citations
19 Claims
-
1. An information management system for archiving and restoring database data, the system comprising:
-
a data agent comprising computer hardware configured to; process a database file residing on one or more first storage devices to identify a subset of data in the database file for archiving, the database file generated by a database application executing on a client computing device comprising computer hardware; extract the subset of the data from the database file and store the subset of the data in an archive file on the one or more first storage devices, the archive file contained within a first volume; delete the subset of the data from the database file; create a snapshot of the first volume, the snapshot of the first volume being stored on the one or more first storage devices; and divide the snapshot of the first volume into a plurality of blocks having a common size; and at least one secondary storage controller computer comprising hardware and residing in a secondary storage subsystem, the secondary storage controller computer configured to, as part of a secondary copy operation in which the snapshot of the first volume is copied to one or more secondary storage devices in the secondary storage subsystem; receive the plurality of blocks over a network connection; copy the plurality of blocks to the one or more secondary storage devices to create a secondary copy of the first volume; and create a table that provides a mapping between the copied plurality of blocks and corresponding locations in the one or more secondary storage devices.
-
-
2. An information management system for archiving and restoring database data, the system comprising:
-
a data agent comprising computer hardware configured to; process a database file residing on one or more primary storage devices in a primary storage subsystem to identify a subset of data in the database file for archiving, the database file generated by a database application executing on a client computing device comprising computer hardware; extract the subset of the data from the database file and store the subset of the data in an archive file on one or more of the primary storage devices as a plurality of blocks having a common size; and delete the subset of the data from the database file; and at least one secondary storage controller computer comprising hardware and residing in a secondary storage subsystem, the secondary storage controller computer configured to, as part of a secondary copy operation in which the archive file is copied to one or more secondary storage devices in the secondary storage subsystem; receive the plurality of blocks over a network connection; copy the plurality of blocks to the one or more secondary storage devices to create a secondary copy of the archive file; and create a table that provides a mapping between the copied plurality of blocks and corresponding locations in the one or more secondary storage devices; wherein the archive file is deleted from the primary storage devices subsequent to the creation of the secondary copy of the archive file. - View Dependent Claims (3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A method of archiving and restoring database data, the method comprising:
-
using a data agent comprising computer hardware; processing a database file residing on one or more primary storage devices in a primary storage subsystem to identify a subset of the data in the database file for archiving, the database file generated by a database application executing on a client computing device comprising computer hardware; extracting the subset of the data from the database file and storing the subset of the data in an archive file on one or more of the primary storage devices as a plurality of blocks having a common size; and deleting the subset of the data from the database file; and using at least one secondary storage controller computer comprising hardware and residing in a secondary storage subsystem, as part of a secondary copy operation in which the archive file is copied to one or more secondary storage devices in the secondary storage subsystem; receiving the plurality of blocks over a network connection; copying the plurality of blocks to the one or more secondary storage devices to create a secondary copy of the archive file; and creating a table that provides a mapping between the copied plurality of blocks and corresponding locations in the one or more secondary storage devices; wherein the archive file is deleted from the primary storage devices subsequent to the creation of the secondary copy of the archive file. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19)
-
Specification