Granted Patent B1

US 7,263,537 · App. 10/927,384 · Granted Aug 28, 2007

Abstract

Claims (20)

1. A method in a single server, for creating multiple copies of a primary online database at a secondary database comprising the steps of:

(a) QUIESCING momentarily said primary database wherein step (a) includes the steps of:

(a1) utilizing a DMUtility program to initiate a QUIESCE database copy command;

(a2) allowing all active/update transactions to complete on said primary database;

(a3) suspending future transactions on said primary database;

(a4) writing, to a first disk means (D 1 and A 1 ), the information residing in the data buffers and audit buffers of an audit file in said primary database;

(a5) creating two control points to said audit file which are set to occur every “n” transactions whereby a set of audit files are flushed to said primary disk means (D 1 , A 1 ), during QUIESCENCE of said primary database;

(a6) setting-up information in a control file to indicate existence of the QUIESCE condition and to indicate a Time Stamp for said control point;

(b) mirroring said QUIESCED primary database to create a secondary database holding a snapshot copy of said primary database at the moment of QUIESCENCE.

2. The method of claim 1 wherein step (a) further includes the steps of:

(a7) writing, to said control file, the QUIESCE Database Copy configuration information;

(a8) completing a DMUtility program sequence with a message to said DMUtility program that said primary database is QUIESCED and is waiting for a RESUME command.

3. A method in a single server, for creating multiple copies of a primary online database at a secondary database comprising the steps of:

(a) QUIESCING momentarily said primary database;

(b) mirroring said QUIESCED primary database to create a secondary database holding a snapshot copy of said primary database at the moment of QUIESCENCE including the steps of:

(b1) developing said snapshot copy, of said primary database, on a secondary disk (D 2 ) by replicating a primary disk (D 1 );

(b2) splitting off (disconnecting) said secondary disk (D 2 ) from said primary disk (D 1 );

(b3) initiating a RESUME command to said primary database to become operational for online transaction activity;

(b4) replicating from said snapshot copy, a multiplicity of mirrored disks ( 301 , 302 , 303 ) which are designated with new family names;

(b5) initiating a ODC (QUIESCE Database Copy) CREATE command to bring online to said single server, said multiplicity of mirrored disks.

Assignments (14)