OBJECT-LEVEL DATABASE RESTORE
First Claim
1. A system for backing up and restoring database data, the system comprising:
- a computing device comprising computer hardware, the computing device having a data agent executing thereon configured to;
intercept a request from a database application executing on the computing device to read a portion of a database file, where a secondary copy of the database file resides on one or more secondary storage devices in a secondary storage subsystem and is organized on the one or more secondary storage devices as a plurality of first blocks, wherein the portion corresponds to a subset of one or more database objects of a plurality of database objects represented by the database file, wherein the request includes one or more database file offsets corresponding to the requested portion;
map the one or more database file offsets to a subset of the first blocks that correspond to the one or more requested database objects based on the one or more database file offsets included in the request; and
issue a request for the subset of the first blocks; and
one or more secondary storage controller computers comprising hardware configured to;
in response to the request for the subset of the first blocks;
access a table that maps the plurality of first blocks to storage locations on the one or more secondary storage devices;
using the table, locate the subset of the first blocks on the one or more secondary storage devices and retrieve the subset of the first blocks from the one or more secondary storage devices; and
forward the retrieved first blocks for storage in one or more primary storage devices associated with the computing device.
2 Assignments
0 Petitions
Accused Products
Abstract
According to certain aspects, a system may include a computing device configured to: intercept a request from a database application to read a portion of a database file, where a secondary copy of the database file resides on a secondary storage device(s) and is organized as a plurality of first blocks, wherein the request includes a database file offset(s) corresponding to the requested portion; and map the database file offset(s) to a subset of the first blocks that correspond to requested database object(s). The system may include a secondary storage controller computer(s) configured to: access a table that maps the plurality of first blocks to storage locations on the secondary storage device(s); using the table, locate and retrieve the subset of the first blocks on the secondary storage device(s); and forward the retrieved first blocks for storage in a primary storage device(s).
28 Citations
20 Claims
-
1. A system for backing up and restoring database data, the system comprising:
-
a computing device comprising computer hardware, the computing device having a data agent executing thereon configured to; intercept a request from a database application executing on the computing device to read a portion of a database file, where a secondary copy of the database file resides on one or more secondary storage devices in a secondary storage subsystem and is organized on the one or more secondary storage devices as a plurality of first blocks, wherein the portion corresponds to a subset of one or more database objects of a plurality of database objects represented by the database file, wherein the request includes one or more database file offsets corresponding to the requested portion; map the one or more database file offsets to a subset of the first blocks that correspond to the one or more requested database objects based on the one or more database file offsets included in the request; and issue a request for the subset of the first blocks; and one or more secondary storage controller computers comprising hardware configured to; in response to the request for the subset of the first blocks; access a table that maps the plurality of first blocks to storage locations on the one or more secondary storage devices; using the table, locate the subset of the first blocks on the one or more secondary storage devices and retrieve the subset of the first blocks from the one or more secondary storage devices; and forward the retrieved first blocks for storage in one or more primary storage devices associated with the computing device. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15)
-
-
16. A method of backing up and restoring database data, the method comprising:
-
using a computing device comprising computer hardware, the computing device having a data agent executing thereon; intercepting a request from a database application executing on the computing device to read a portion of a database file, where a secondary copy of the database file resides on one or more secondary storage devices in a secondary storage subsystem and is organized on the one or more secondary storage devices as a plurality of first blocks, wherein the portion corresponds to a subset of one or more database objects of a plurality of database objects represented by the database file, wherein the request includes one or more database file offsets corresponding to the requested portion; mapping the one or more database file offsets to a subset of the first blocks that correspond to the one or more requested database objects based on the one or more database file offsets included in the request; and issuing a request for the subset of the first blocks; and using one or more secondary storage controller computers comprising hardware; in response to the request for the subset of the first blocks; accessing a table that maps the plurality of first blocks to storage locations on the one or more secondary storage devices; using the table, locating the subset of the first blocks on the one or more secondary storage devices and retrieve the subset of the first blocks from the one or more secondary storage devices; and forwarding the retrieved first blocks for storage in one or more primary storage devices associated with the computing device. - View Dependent Claims (17, 18, 19, 20)
-
Specification