Automated backup and restore of a disk group

Patent metadata

Field	Value
Publication number	US-2024248811-A1
Application number	US-202418626643-A
Country	US
Kind code	A1
Filing date	Apr 4, 2024
Priority date	Jun 8, 2018
Publication date	Jul 25, 2024
Grant date	—

Abstract

Restoring a clustered database having a plurality of nodes each having database from a failed storage device by receiving a request to restore a backup image of a failed shared storage device associated with the clustered database to a time; performing a preflight check including at least one checklist process; terminating the restore when any checklist process fails; when each checklist process succeeds completing the restore by creating at least one flashcopy associated with the backup image, mapping to each of the plurality of nodes an associated portion of the at least one flashcopy, mounting the at least one flashcopy to the node as a diskgroup, and switching the clustered database to run from the diskgroup.

First claim

What is claimed is:

1 . A computer-implemented method executed on data processing hardware that causes the data processing hardware to perform operations comprising:
receiving a request to restore a clustered database from backup storage devices to production storage devices using a backup image, the clustered database comprising a plurality of nodes, each node of the plurality of nodes comprising database data from the clustered database; performing a preflight check on the plurality of nodes of the clustered database; determining that the preflight check on the plurality of nodes of the clustered database satisfies a threshold; based on determining that the preflight check on the plurality of nodes of the clustered database satisfies the threshold, restoring the clustered database from the backup storage devices to the production storage devices using the backup image; and after restoring the clustered database:
obtaining a rebalance request comprising a power factor indicating a speed of data movement during rebalancing; and
rebalancing the database data evenly across the production storage devices based on the power factor.

2 . The computer-implemented method of claim 1 , wherein restoring the clustered database from the backup storage devices to the production storage devices comprises:
creating at least one flashcopy associated with the backup image; and mapping each node of the plurality of nodes to an associated portion of the at least one flashcopy such that the at least one flashcopy is accessible as a diskgroup by each of the plurality of nodes.

3 . The computer-implemented method of claim 2 , wherein restoring the clustered database from the backup storage devices to the production storage devices further comprises:
mounting, by each respective node of the plurality of nodes, the at least one flashcopy to the respective node as a diskgroup; and switching, by the plurality of nodes, the clustered database to run from the diskgroup.

4 . The computer-implemented method of claim 1 , wherein performing the preflight check on the plurality of nodes comprises at least one of:
checking a location of software associated with the request; checking whether requisite software is running; or checking whether the clustered database is running.

5 . The computer-implemented method of claim 1 , wherein the operations further comprise:
querying at least one of the plurality of nodes to determine an availability status of at least one disk of the clustered database; and receiving the availability status of the at least one disk of the clustered database.

6 . The computer-implemented method of claim 1 , wherein each node of the plurality of nodes form a real application cluster (RAC).

7 . The computer-implemented method of claim 1 , wherein the backup image comprises an incremental backup of the backup storage device.

8 . The computer-implemented method of claim 1 , wherein the backup image comprises a point-in-time snapshot copy of the backup storage device.

9 . The computer-implemented method of claim 1 , wherein the operations further comprise:
determining a progress of rebalancing the database data; and providing the progress of rebalancing the database data to a user associated with the request.

10 . The computer-implemented method of claim 1 , wherein the operations further comprise removing the backup storage devices after restoring the clustered database.

11 . A system comprising:
data processing hardware; and memory hardware in communication with the data processing hardware, the memory hardware storing instructions that when executed on the data processing hardware cause the data processing hardware to perform operations comprising:
receiving a request to restore a clustered database from backup storage devices to production storage devices using a backup image, the clustered database comprising a plurality of nodes, each node of the plurality of nodes comprising database data from the clustered database;
performing a preflight check on the plurality of nodes of the clustered database;
determining that the preflight check on the plurality of nodes of the clustered database satisfies a threshold;
based on determining that the preflight check on the plurality of nodes of the clustered database satisfies the threshold, restoring the clustered database from the backup storage devices to the production storage devices using the backup image; and
after restoring the clustered database:
obtaining a rebalance request comprising a power factor indicating a speed of data movement during rebalancing; and
rebalancing the database data evenly across the production storage devices based on the power factor.

12 . The system of claim 11 , wherein restoring the clustered database from the backup storage devices to the production storage devices comprises:
creating at least one flashcopy associated with the backup image; and mapping each node of the plurality of nodes to an associated portion of the at least one flashcopy such that the at least one flashcopy is accessible as a diskgroup by each of the plurality of nodes.

13 . The system of claim 12 , wherein restoring the clustered database from the backup storage devices to the production storage devices further comprises:
mounting, by each respective node of the plurality of nodes, the at least one flashcopy to the respective node as a diskgroup; and switching, by the plurality of nodes, the clustered database to run from the diskgroup.

14 . The system of claim 11 , wherein performing the preflight check on the plurality of nodes comprises at least one of:
checking a location of software associated with the request; checking whether requisite software is running; or checking whether the clustered database is running.

15 . The system of claim 11 , wherein the operations further comprise:
querying at least one of the plurality of nodes to determine an availability status of at least one disk of the clustered database; and receiving the availability status of the at least one disk of the clustered database.

16 . The system of claim 11 , wherein each node of the plurality of nodes form a real application cluster (RAC).

17 . The system of claim 11 , wherein the backup image comprises an incremental backup of the backup storage device.

18 . The system of claim 11 , wherein the backup image comprises a point-in-time snapshot copy of the backup storage device.

19 . The system of claim 11 , wherein the operations further comprise:
determining a progress of rebalancing the database data; and providing the progress of rebalancing the database data to a user associated with the request.

20 . The system of claim 11 , wherein the operations further comprise removing the backup storage devices after restoring the clustered database.

Assignees

• Google Llc

Inventors

• Zhang Xiangdong
• Palaparthi Satya Sri Kanth
• Kumar Sachindra
• Tekade Uday
• Mutalik Madhav
• Bezawada Suresh

Classifications

• G06F11/1469 Primary

  Backup restoration techniques · CPC title

• G06F2201/84

  Using snapshots, i.e. a logical point-in-time copy of the data · CPC title

• G06F2201/80

  Database-specific techniques · CPC title

• G06F11/1466 Primary

  to make the backup process non-disruptive · CPC title