Method for reducing database recovery time

• US 7,222,133 B1
• Filed: 02/05/2004
• Issued: 05/22/2007
• Est. Priority Date: 02/05/2004
• Status: Active Grant

• Current Assignee: Unisys Corporation
• Original Assignee: Unisys Corporation
• Inventors: Hart, Donald Ralph, de Jesus, Alma Navarro, Raipurkar, Anagha
• Primary Examiner(s): Gaffin; Jeffrey
• Assistant Examiner(s): SYED, FARHAN M
• Application Number:
  US10/772,567
• Time in Patent Office: 1,202 Days
• Field of Search: 707/200, 707/201, 707/202, 707/203, 707/204
• US Class Current: 707/642
• CPC Class Codes: G06F 11/1458 Management of the backup or restore process
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A method is provided to automatically select the correct order of backups from selected DUMP files in order to recover and rebuild a complete database in reduced time without requiring the user to search, find and select the correct order of items for the backup.

Claims

1. A system for reducing time in a server-database network where various types of dump operations are categorized in a dump directory for automatic sequential selection to execute a recovery operation comprising:

(a) data storage means for providing disk means for holding database files available for read-write access by a server means;

(b) means to initiate and to enable operations with said disk means to create special sets of backup dump files on a tape storage means, wherein said means to initiate and create special sets of backup dump files includes;

(b1) means for creating a FULL dump file;

(b2) means for creating a set of ACCUMULATED dump files;

(b3) means for creating a set of INCREMENTAL dump files;

(c) said tape storage means for holding said special set of backup dump files;

(d) means for creating a Main Directory in a correct sequential order and which has a log of the special sets of backup dump files from said tape means, said correct sequential order involving dumps which are accessed in the following order;

(i) a most recent FULL DUMP;

(ii) a most recent ACCUMULATED dump;

(iii) a most recent set of INCREMENTAL dumps;

(e) recovery means for selecting and placing said special sets of backup dump files into said disk means to establish an updated and operable database.

2. The system of claim 1 wherein said means (d) additionally creates a Disk Directory which provides detailed disk sub directories of said dump files for each dump logged in said Main Directory.

3. The system of claim 2 wherein said recovery means utilizes said sub-directories for restoring updated data files in said disk means.

4. The system of claim 2 wherein said disk sub-directories of each dump logged in said Main Directory include:

(i) a Full Dump;

(ii) ACCUMULATED dumps;

(iii) INCREMENTAL dumps.

5. The system of claim 2 wherein said recovery means (e) includes:

(e1) SYSTEM RECOVERY program means to enable the production of an updated database including;

(e1a) said DUMP DIR Library means for accessing said sets of dump files from said Main Directory and said Disk Directories for conveyance to said recovery means;

(e1b) said means for conveying said sets of dump files from said Disk Directories to said recovery means;

(e1c) means for transporting said dump files to said recovery disk to provide an updated database.

6. The system of claim 4 wherein said dumps (i), (ii), and (iii) are placed in the correct sequential order so that the said recovery means will automatically restore said database in the correct sequential order onto disk means.

7. The system of claim 6 wherein said correct sequential order operates such that the most-recently created dump file is the first to be restored, then sequentially the next more recently dump file and so on until the last created dump file (earliest in time) has been restored.

8. The system of claim 6 wherein said correct sequential order of any dump recovery operates by accessing the sequence from the last item to the first item in the dump.