Database recovery method applying update journal and database log
First Claim
1. A database recovery method for a computer system, the computer system comprising:
- a computer having a database management system; and
a storage system for storing data accessed from the computer, the computer comprising;
a port connected to the storage system;
a processor connected to the port; and
a memory connected to the processor, the storage system comprising;
a port connected to the computer;
a control unit connected to the port and including a processor and a memory; and
a disk drive for storing data which is a target of a write request issued by the computer, the disk drive including;
a data volume for storing the data;
a snapshot volume corresponding to a copy of the data volume;
a database log for storing an update log of the data; and
an update journal for storing update information of the data volume, the database management system recording a recovery point for indicating an end point of a range to which the update journal is to be applied and a starting point of a range to which the database log is to be applied when the data volume is damaged, the database recovery method comprising;
applying the update journal to the snapshot volume up to the recovery point;
switching the updated snapshot volume to the data volume; and
applying the database log after the recovery point to the data volume that is set by switching.
2 Assignments
0 Petitions
Accused Products
Abstract
A database recovery method including a computer and a storage system, in which: the storage system includes a disk drive for storing data; the disk drive includes a data volume, a snapshot volume, a database log for storing an update log, and an update journal for storing update information of the data volume; a recovery point for indicating an end point of a range to which the update journal is to be applied and a starting point of a range to which the database log is to be applied is recorded to recover the data volume; and when the database is to be recovered, the update journal is applied to the snapshot volume up to the recovery point, the snapshot volume after the update is switched to the data volume, and the database log after the recovery point is applied to the data volume that is set by switching.
-
Citations
12 Claims
-
1. A database recovery method for a computer system,
the computer system comprising: - a computer having a database management system; and
a storage system for storing data accessed from the computer,the computer comprising;
a port connected to the storage system;
a processor connected to the port; and
a memory connected to the processor,the storage system comprising;
a port connected to the computer;
a control unit connected to the port and including a processor and a memory; and
a disk drive for storing data which is a target of a write request issued by the computer,the disk drive including;
a data volume for storing the data;
a snapshot volume corresponding to a copy of the data volume;
a database log for storing an update log of the data; and
an update journal for storing update information of the data volume,the database management system recording a recovery point for indicating an end point of a range to which the update journal is to be applied and a starting point of a range to which the database log is to be applied when the data volume is damaged, the database recovery method comprising;
applying the update journal to the snapshot volume up to the recovery point;
switching the updated snapshot volume to the data volume; and
applying the database log after the recovery point to the data volume that is set by switching. - View Dependent Claims (2, 3, 4, 5, 6)
- a computer having a database management system; and
-
7. A computer system, comprising:
-
a computer having a database management system; and
a storage system for storing data accessed from the computer, wherein;
the computer comprises a port connected to the storage system, a processor connected to the port and a memory connected to the processor;
the storage system comprises a port connected to the computer, a control unit connected to the port and including a processor and a memory and a disk drive for storing data which is a target of a write request issued by the computer;
the disk drive includes a data volume for storing the data, a snapshot volume corresponding to a copy of the data volume, a database log for storing an update log of the data and an update journal for storing update information of the data volume; and
the database management system records a recovery point for indicating an end point of a range to which the update journal is to be applied and a starting point of a range to which the database log is to be applied when the data volume is damaged during a normal operation of the computer system, applies the update journal to the snapshot volume up to the recovery point when an error occurs in the data volume, switches the updated snapshot volume to the data volume, and applies the database log after the recovery point to the data volume that is set by switching. - View Dependent Claims (8, 9, 10, 11, 12)
-
Specification