Backup optimization in hybrid storage environment

Abstract

A means for assigning database objects to a backup storage group proceeds by collecting information related to a plurality of backup devices. The information collected includes speed of recovery, time to backup, and a recovery rank for each device. A backup pool is defined, using a database configuration parameter, to contain one or more of the plurality of backup devices. A determination is made to store a backup of a data object in a first device of the plurality of backup devices based on the collected information and a priority rank associated with the data object.

What is claimed is: 
     
         1 . A system comprising:
 a computing device having a processor; and   a computer readable storage medium having program instructions embodied therewith, the program instructions executable by the processor to cause the system to perform a method, for assigning database objects to a backup storage group, the method comprising:   collecting information related to a plurality of backup devices, wherein the plurality of backup devices includes backup devices representing a plurality of media types and the information includes speed of recovery, time to backup, a media identifier, and a resource indicator,   calculating a recovery rank for each device based on the device's speed of recovery, media identifier, and resource indicator;   defining a backup pool of the plurality of backup devices using a database configuration parameter, wherein a database is to access the backup pool via the database configuration parameter and wherein the database cannot individually access a backup device of the plurality of backup devices;   modifying the database configuration parameter to redefine the backup pool to add a backup device to the plurality of backup devices;   modifying the database configuration parameter to redefine the backup pool to remove a backup device from the plurality of backup devices;   determining to store a backup of a data object in a first device of the plurality of backup devices based on the collected information and a priority rank associated with the data object, the priority rank determined according to the data object's role in database recovery;   detecting a first failure in the first device;   analyzing the first failure in the first device;   identifying a first hardware failure as causing the first failure in the first device;   determining, in response to identifying the hardware failure, to store the backup of the data object in a second device of the plurality of backup devices based on the collected information and the priority rank associated with the data object;   detecting a second failure in the second device;   analyzing the second failure in the second device;   determining the second failure was not caused by a second hardware failure;   reinitiating storing the backup of the data object in the second device; and   determining that the backup is complete.