Method for reading audit data from a remote mirrored disk for application to remote database backup copy

Abstract

In order to overcome limitations of network connections between a primary host server and a remote secondary host server, the audit file of a primary database is mirrored to an audit file of the remote secondary backup database. A special sensing program called TRACKER operates to speed up the synchronization (duplication) between the primary database and secondary remote database.

Description

CROSS-REFERENCES TO RELATED APPLICATIONS[0001]This application is related to co-pending applications listed below, which are incorporated herein by reference:[0002]U.S. Ser. No. 09 / 415,273 which issued as U.S. Pat. No. 6,430,577 and entitled “System And Method For Asynchronously Receiving Multiple Packets of Audit Data From A Source Databased Host In a Resynchronization Node And Asynchronously Writing The Data To A Target Host”.[0003]U.S. Ser. No. 09 / 415,333 which issued as U.S. Pat. No. 6,446,090 and entitled “Tracker Sensing Method For Regulating Synchronization of Audit Files Between Primary And Secondary Hosts”.[0004]U.S. Ser. No. 09 / 415,274 which issued as U.S. Pat. No. 6,408,310 and entitled “System and Method For Expediting Transfer of Sectioned Audit Files From A Primary Host to a Secondary Host”.[0005]U.S. Ser. No. 09 / 951,996 which issued as U.S. Pat. No. 6,877,016 and entitled “Method Of Capturing A Physically Consistent Mirrored Snapshot Of An Online Database”.FIELD OF TH...

AI Technical Summary

Benefits of technology

[0018]In order to achieve maximum synchronization or accurate duplication between a primary database audit file and a secondary database audit file, the audit data is transferred via the network connection to the remote location just as soon as it is written to disk at the primary location. This method of audit transfer requires a constant use of a stable network and as a result, the primary database system availability is decreased when a network communication error occurs. However, by reading audit data from the remote mirrored disk, a backup copy is maintained at the remote host that does not require network connection use for audit transfer. Further, the primary database system availability is not affected by any network communication errors.

Problems solved by technology

This temporary suspension of database activity presents problems and is counter-productive to the goal of maintaining 100% database availability.

Images