Browse Prior Art Database

Method for high speed backup of online database on the network storage using GUI

IP.com Disclosure Number: IPCOM000016095D
Original Publication Date: 2002-Oct-10
Included in the Prior Art Database: 2003-Jun-21
Document File: 1 page(s) / 39K

Publishing Venue

IBM

Abstract

Disclosed is a method for high speed backup of online database on the network storage using GUI.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 82% of the total text.

Page 1 of 1

  Method for high speed backup of online database on the network storage using GUI

Disclosed is a method for high speed backup of online database on the network storage using GUI.

Network Storage such as NAS(Network Attached Storage) and SAN(Storage Area Network) have a functionality of H/W assisted high speed backup of disk volume snapshot. These are done by the logical volume level, and the backup method provided by the current database system cannot make use of the H/W assisted high speed backup functions. We disclose a method which utilizes the H/W assisted high speed backup functions for the database system which detects volumes which the specified database(s) is located and backs up the database(s) assuring the database transaction atomicity by GUI. By this method, Database Administrators, who are usually not experts of network storage management, can easily perform the high speed database backup.

This method is of the database administrators view, and does the following items:

(1) By GUI tool (this method), a user specifies the database to perform high speed backup.
(2) Detects all the network storage volumes which database files are located.
(3) Issues a signal to the database system that the backup starts in order to assure the database transaction atomicity.
(4) Issues a high speed backup command for all the volumes which are detected by (2).
(5) Issues a signal to the database system that the backup completed.

This method contributes database high availabil...