Techniques to perform system management processing for database systems

Patent metadata

Field	Value
Publication number	US-10055305-B2
Application number	US-201615141468-A
Country	US
Kind code	B2
Filing date	Apr 28, 2016
Priority date	Apr 28, 2016
Publication date	Aug 21, 2018
Grant date	Aug 21, 2018

Abstract

Various embodiments are generally directed an apparatus and method for performing a discovery operation to determine a system layout for a database and one or more files for a dataset stored in the database and performing a backup operation on the dataset to cause storage of a backup copy of each of the one or more files and collect metadata associated with the backup copy of each of the one or more files, the metadata to enable restoration of the one or more files.

First claim

What is claimed is:

1. An apparatus, comprising:
memory;
logic, at least partially implemented in circuitry coupled with the memory, the logic to:
perform a discovery operation by a plurality of plugins to determine a system layout for a database and one or more files for a dataset stored in the database;
validate the database as a candidate for centralized management by a server based on information provided by the plurality of plugins; and
perform by using the plurality of plugins, a backup operation on the dataset to cause storage of a backup copy of each of the one or more files and collect metadata associated with the backup copy of each of the one or more files, the metadata stored in a relational scheme to enable restoration of the one or more files; wherein the relational scheme stores static metadata data and dynamic transactional metadata related to the static metadata.

2. The apparatus of claim 1 , the logic to cause the database to enter a quiesced state prior to performing the backup operation and exit the quiesced state subsequent to performing the backup operation.

3. The apparatus of claim 1 , the one or more files comprising at least one of data files, control files, online redo log files, and archived redo log files, and the backup operation to cause storage of the backup copy for at least one of the data files, the control files, the online redo log files, and the archived redo log files.

4. The apparatus of claim 1 , the system layout comprising a storage type, a filesystem, and one or more system settings comprising at least one of an automatic storage management setting, a data guard setting, and a virtualization setting.

5. The apparatus of claim 1 , the logic to perform the backup operation on the dataset stored on the database comprising at least two different system layouts.

6. The apparatus of claim 1 , the logic to perform the backup operation on a dataset stored on two or more databases comprising at least two different system layouts.

7. The apparatus of claim 1 , the logic to collect the static metadata during an initial backup operation and the dynamic transactional metadata during one or more subsequent backup operations, the dynamic transactional metadata comprising transactions associated with the one or more files.

8. The apparatus of claim 1 , the logic to restore the backup copy of each of the one or more files in a database having at least two different system layouts.

9. The apparatus of claim 1 , the logic to clone the database via generating a new database having a same system layout as the system layout and utilizing the backup copy of each of the one or more files.

10. A computer-implemented method, comprising:
performing a discovery operation by a plurality of plugins to determine a system layout for a database and one or more files for a dataset stored in the database;
validating the database as a candidate for centralized management by a server based on information provided by the plurality of plugins; and
performing by using the plurality of plugins, a backup operation on the dataset to cause storage of a backup copy of each of the one or more files and collect metadata associated with the backup copy of each of the one or more files, the metadata stored in a relational scheme to enable restoration of the one or more files; wherein the relational scheme stores static metadata data and dynamic transactional metadata related to the static metadata.

11. The computer-implemented method of claim 10 , comprising causing the database to enter a quiesced state prior to performing the backup operation and exit the quiesced state subsequent to performing the backup operation.

12. The computer-implemented method of claim 10 , the one or more files comprising at least one of data files, control files, online redo log files, and archived redo log files, and the backup operation to cause storage of the backup copy for at least one of the data files, the control files, the online redo log files, and the archived redo log files.

13. The computer-implemented method of claim 10 , the system layout comprising a storage type, a filesystem, and one or more system settings comprising at least one of an automatic storage management setting, a data guard setting, and a virtualization setting.

14. The computer-implemented method of claim 10 , comprising performing the backup operation on the dataset stored on the database comprising at least two different system layouts.

15. The computer-implemented method of claim 10 , comprising performing the backup operation on a dataset stored on two or more databases comprising at least two different system layouts.

16. The computer-implemented method of claim 10 , comprising collecting the static metadata during an initial backup operation and the dynamic transactional metadata during one or more subsequent backup operations, the dynamic transactional metadata comprising transactions associated with the one or more files.

17. The computer-implemented method of claim 10 , comprising restoring the backup copy of each of the one or more files in a database having at least two different system layouts.

18. The computer-implemented method of claim 10 , comprising cloning the database via generating a new database having a same system layout as the system layout and utilizing the backup copy of each of the one or more files.

19. A non-transitory computer-readable storage medium comprising a plurality of instructions that, when executed by processing circuitry, enable the processing circuitry to:
perform a discovery operation by a plurality of plugins to determine a system layout for a database and one or more files for a dataset stored in the database;
validate the database as a candidate for centralized management by a server based on information provided by the plurality of plugins; and
perform by using the plurality of plugins, a backup operation on the dataset to cause storage of a backup copy of each of the one or more files and collect metadata associated with the backup copy of each of the one or more files, the metadata stored in a relational scheme to enable restoration of the one or more files; wherein the relational scheme stores static metadata data and dynamic transactional metadata related to the static metadata.

20. The non-transitory computer-readable storage medium of claim 19 , comprising instructions that when executed enable the processing circuitry to cause the database to enter a quiesced state prior to performing the backup operation and exit the quiesced state subsequent to performing the backup operation.

21. The non-transitory computer-readable storage medium of claim 19 , the one or more files comprising at least one of data files, control files, online redo log files, and archived redo log files, and the backup operation to cause storage of the backup copy for at least one of the data files, the control files, the online redo log files, and the archived redo log files.

22. The non-transitory computer-readable storage medium of claim 19 , the system layout comprising a storage type, a filesystem, and one or more system settings comprising at least one of an automatic storage management setting, a data guard setting, and a virtualization setting.

23. The non-transitory computer-readable storage medium of claim 19 , comprising instructions that when executed enable the processing circuitry to perform the backup operation on the dataset stored on the database comprising at least

Assignees

• Netapp Inc

Inventors

• Kaplingat Nikhil
• Kumar Praveen
• G Deepa
• Shee Shaswati
• Ramachandra Suman
• Chandrashekar Krishnan
• Subbareddy Lokesha
• Thorat Vrishali

Classifications

• G06F11/1469

  Backup restoration techniques · CPC title

• G06F16/13

  File access structures, e.g. distributed indices (arrangements of input from, or output to, record carriers G06F3/06) · CPC title

• G06F11/1471

  involving logging of persistent data for recovery · CPC title

• G06F16/1865

  Transactional file systems · CPC title

• G06F11/1458 Primary

  Management of the backup or restore process · CPC title