Granted Patent B1

US 6,983,295 · App. 10/280,717 · Granted Jan 3, 2006

Abstract

Claims (23)

1. In a single host server which operates under a Master Control Program (MCP), said single host server holding a normally active database means having a data disk file means (D 1 ) which is mirrored to an auxiliary database means having an auxiliary data disk file means (D 2 ), a method for establishing recovery operations upon failure of said active database means comprising the steps of:

(a) utilizing a DMUTILITY program to QUIESCE said active database means (D 1 ) and to transfer its data, at a Time Stamp starting point, over to said auxiliary database means (D 2 ) wherein step (a) includes the step of:

(a1) setting up a REBUILDINFO file to store starting time and ending condition Time Stamps plus multiple information files to supply file locations and relevant Time Stamps;

(b) utilizing said Time Stamp starting point to initiate an audit file disk means to update said auxiliary database means (D 2 );

(c) making said auxiliary database means (D 2 ) immediately available for access by user applications.

2. In a single host server operating system under a Master Control Program (MCP) and holding an online active database means having a data disk file means (D 1 ) which is mirrored to an auxiliary database means having an auxiliary data disk file means (D 2 ), a method upon failure of said online active database means for Database recovery utilizing a mirrored snapshot of said online database means wherein said online database means (D 1 ) services a plurality of User-applications, and is mirrored to an auxiliary database means (D 2 ), said method comprising the steps of:

(a) bringing online for Application-Users, a mirrored snapshot set of files on said auxiliary data disk file means disk (D 2 ) which replicates said data disk means (D 1 );

(b) utilizing a DMUTILITY REBUILD program, initiated by a QUIESCE database command, to select that portion of said data disk file means (D 1 ) which needs to be recovered and the logical stopping point of the recovery;

(c) verifying that said auxiliary data disk file means (D 2 ) now has all data files resident in it which were originally on said data disk means (D 1 ) at the time of the beginning Time Stamp;

(d) storing, by said DMUTILITY program, of a QUIESCE Time Stamp in a REBUILDINFO file to indicate when said data disk means (D 1 ) was taken off-line to enable it to transfer (REBUILD) its data to said auxiliary data disk means (D 2 );

(e) reading of data changes in said audit trail file (A 1 ) to make updating changes to said auxiliary data disk means (D 2 );

(f) transmitting of all data from said data disk file means (D 1 ) and audit trail images in said audit trail file (A 1 ) onto said auxiliary data disk file means (D 2 );

(g) enabling said updated auxiliary data disk file means to operate as an active database.

3. In a single host server operating under a Master Control Program (MCP) and holding an online active data disk file (D 1 ) with an audit disk file (A 1 ) and holding an auxiliary data disk file (D 2 ) which is mirrored to said active data disk file (D 1 ), a system for rapid database recovery during failure of said online active database disk (D 1 ) comprising:

(a) database system means holding said online active database disk (D 1 ) and an audit file disk (A 1 );

(b) disk mirroring connecting means whereby said online active database disk (D 1 ) is replicated at an auxiliary database disk (D 2 );

(c) means, using a Database Utility program, to initiate a QUIESCE command to momentarily QUIESCE said active database disk (D 1 ) to start a recovery action and store a QUIESCE Time Stamp in a REBUILDINFO file;

(d) means to transfer said files on said database disk (D 1 ), at the Time Stamp point of QUIESCE, to said auxiliary database disk (D 2 );

(e) means to update the data files on said auxiliary database disk (D 2 ) with the audit trail on said audit file disk (A 1 ) starting with the Time Stamp point of said QUIESCE; said means to update including:

(e1) means to utilize said REBUILDINFO file to access said QUIESCE Time Stamp indicating the point in time to begin audit image application from audit disk (A 1 ) to auxiliary data disk (D 2 );

(e2) means to scan the audit file in disk (A 1 ) backwards to locate the starting point Time Stamp;

(e3) means to store in said REBUILDINFO file a Time Stamp value at which the application of audit images will terminate;

(f) means to enable said auxiliary data disk file (D 1 ) as an online database.

Assignments (7)