Data backup is one of the most important methods to protect data security. To enhance data protection, GBase 8c database offers three types of backup and recovery, with multiple strategies that ensure data reliability during the backup and recovery process.

This article introduces the backup and recovery types in GBase 8c, which can be categorized into logical backup and recovery, physical backup and recovery, and flashback recovery.

• Logical Backup and Recovery

Logical backup involves exporting data logically. It can only capture the data at the time of the backup, so the recovery process can only restore data to the state it was in when the backup was taken. Logical backup is suitable for data that changes infrequently. In cases of accidental damage, a quick recovery can be performed using a logical backup. However, if full database recovery is needed, the database usually has to be rebuilt, and the backup data imported, which may take too long for high-availability databases. Due to its platform independence, logical backup is often used for data migration and movement.

• Physical Backup and Recovery

Physical backup involves copying database files at the block level, transferring data from the primary host to a backup. Using the backed-up data files and archived logs, the database can be fully restored. Physical backup is fast and is typically used for full backups. With proper planning, backups and recovery can be done at a low cost.

• Flashback Recovery

Flashback recovery uses the recycle bin to restore deleted tables. The recycle bin function in the database works similarly to the recycle bin in Windows, where deleted table information is stored. Using the MVCC (Multi-Version Concurrency Control) mechanism, the database can flashback to a specific point in time or CSN (Commit Sequence Number).

Comparison of the Three Backup and Recovery Types

The following table compares the three backup and recovery types. When an anomaly occurs, it helps administrators quickly formulate a recovery plan.

Considerations for Backup and Recovery

When planning a backup and recovery strategy, consider the following:

• Impact on Business: Ensure that the backup process has an acceptable level of impact on business operations.
• Recovery Efficiency: Minimize recovery time to reduce the impact of database failures and maximize recovery efficiency.
• Data Recoverability: Minimize data loss in the event of database failure.
• Recovery Cost: Consider factors such as backup objects, data size, and network configuration when choosing a backup strategy for a production environment.

GBase database offers flexible and powerful backup and recovery mechanisms, including XID-based recovery and PITR recovery, supporting multiple recovery strategies to meet various data recovery needs.