Patent ID: 7472139

Claim:
A database recovery method for a computer system comprising a server having a database management system and a storage system having a control unit and a disk drive, wherein the control unit configures, by use of the disk drive, a data volume to store a database data managed by the database management system, a snapshot volume corresponding to a copy of the data volume, configured by the control unit, a database log volume storing database logs of the database data, and a journal volume storing update journals of the data volume, wherein the update journals are created by the control unit, wherein the database logs are created by the database management system, and wherein the database management system records a plurality of recovery points, each of the plurality of recovery points indicates an end point of a range to which one or a plurality of the update journals stored in the journal volume are to be applied and a starting point of the range from which one or a plurality of the database logs stored in the database log volume are to be applied, when the data volume is damaged, the database recovery method comprising: at the database management system, identifying a latest recovery point from the plurality of recovery points; at the control unit, applying a part of the update journals in the journal volume to the snapshot volume up to the end point of the range indicated by the latest recovery point; at the control unit, switching the snapshot volume to the data volume to be accessed by the server; and at the server, applying a part of the database logs from the starting point of the range indicated by the last recovery point to a point ensuring a transaction consistency of the database management system to the snapshot volume that is switched to the data volume to be accessed by the server.