Patent ID: 7263537

Claim:
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.