REAL TIME BACKUP SYSTEM OF DATABASE, SYSTEM OF RECOVERING DATA AND METHOD OF RECOVERING DATA

摘要

The present invention relates to a real time backup system of a database, a system of recovering data and a method of recovering data, capable of performing the real time backup of online redo log data to minimize the loss of an archive log file that can be omitted in a traditional backup method and restoring an online redo log file. To achieve the above-described purpose, the real time backup system of a database according to the present invention comprises an operation DB (210) generating information data on an online redo log (211) as an archive log file (212); an operation server (200) including a first agent (220) that captures transaction information on the online redo log (211) to back up the transaction information as a real time transaction log file on a first backup system (230) and transmits the captured transaction information via a network; a replication sever (300) having a second agent (310) that backs up the captured transaction information, transmitted from the first agent (220) via the network, as a real time transaction log file on a second backup system (320); and a backup dedicated server (400) having a third agent (410) that backs up the captured transaction information, transmitted from the first agent (220) via the network, as a real time transaction log file on a third backup system (420). [Reference numerals] (200) Operation server; (210) Operation DB; (211) Online redo log; (212) Archive log; (220) First agent; (230) First backup system; (300) Replication server; (310) Second agent; (320) Second backup system; (400) Backup dedicated server; (410) Third agent; (420) Third backup system