Continuous data protection method, system, device and medium for database

A data protection and database technology, applied in the database field, can solve problems such as slow recovery time and data loss, and achieve the effect of continuous data protection
CN110362429BActive Publication Date: 2021-08-06UCLOUD TECH CO LTD

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
UCLOUD TECH CO LTD
Publication Date
2021-08-06

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention particularly relates to a continuous data protection method, system, device and medium of a database. The database includes a first database and a second database, the first database is visible to users, the second database is invisible to users, the second database delays the replication of the first database, the first database is the first database at the first time, and the second database is The first database at the second time, the second time is delayed by a predetermined period of time than the first time, the method includes: receiving an instruction to retrieve the first database at the third time; according to the instruction to retrieve the first database at the third time, updating The second database, the updated second database is the first database at the third time, the third time is between the first time and the second time; switch the updated second database to be visible to users, or make the updated The second database of the database is switched to the new first database. The present invention can realize the purpose of continuous data protection under the scene of database misoperation or database damage.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention relates to the database field, in particular to a database continuous data protection method, system, equipment and medium. Background technique

[0002] At present, in the case of database misoperation or database damage, in order to retrieve the previous database, the industry usually adopts the following three methods:

[0003] The first is to perform a full cold backup of the database, combined with incremental logs, and retrieve the previous database through a rollback operation. However, this method needs to update the backup database from the full cold standby time to the time before the failure occurs, and the recovery time is relatively slow.

[0004] The second is to flash back the database through the reverse operation to retrieve the previous database. However, this method has restrictions on the operation type of the database. For example, if the operation type of the database is a DDL operation, since the DDL operation doe...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More