International Business Machines Corporation

Kenji Seta

Takashi Saitoh

Soh Kaijima

Methods and apparatus, including computer program products, implementing and using techniques for recovering a database, distributed in two or more storage devices, based on a backup of each storage device. The backup of each storage device is acquired. In association with the backup for each storage device, a quiesce point indication is acquired. The quiesce point indication indicates backed up data of each storage device. The backed up data is based on a quiesce point. For each storage device, a recovery process is selected. For each storage device, in response to the selected recovery process being a collective copying process, recovering contents of each storage device is done by collective copying. In response to the selected recovery process being to recover based on the quiesce point indication, the contents of each storage device is recovered based on the indicated backed up data of the quiesce point indication.

Backing up and recovering a database

Various embodiments of a method, system and computer program product backup and recover a database. A database is distributed in a plurality of storage devices. A target designation designating a target database is received. One or more storage devices of the plurality of storage devices, storing at least a portion of the target database, are selected. A quiesce point is established by completing an ongoing transaction for the target database and inhibiting a further transaction. In response to establishing the quiesce point, a backup is generated by collectively copying data on each storage device of the one or more selected storage devices. The backup associated with a quiesce point indication indicating backed up data of the said each storage device of the one or more selected storage devices in accordance with the quiesce point, are recorded.

Growing community of inventors

Hiratsuk, Japan

Kenji Seta