Help Center/ GaussDB/ User Guide/ Data Restoration/ GaussDB Restoration Methods for Data Misoperations
Updated on 2024-11-11 GMT+08:00
View PDF
Share

GaussDB Restoration Methods for Data Misoperations

You can choose an appropriate data restoration method based on the site requirements.

Table 1 Restoration methods for misoperations

Scenario

Recovery Method

Restoration Scope

Restore To

Operation Guide

An instance is deleted by mistake.

Recycle bin: Locate the deleted instance in the recycle bin and rebuild the instance to restore it.

All databases and tables

Current instance

Rebuilding a GaussDB Instance

Instance backup: If a manual backup has been created before the instance is deleted, restore the instance on the Backups page.

All databases and tables
  • A new instance
  • An existing instance
  • Current instance

A table is deleted by mistake.

Restore the tables that are deleted by mistake by referring to the methods of restoring an instance.

All databases and tables
  • A new instance
  • An existing instance
  • Current instance

A database is deleted by mistake.

Restore the databases that are deleted by mistake by referring to the methods of restoring an instance.

All databases and tables
  • A new instance
  • An existing instance
  • Current instance

An entire table is overwritten, or the columns, rows, or data in a table is deleted or modified by mistake.

Restore the data that is deleted by mistake by referring to the methods of restoring an instance.

All databases and tables
  • A new instance
  • An existing instance
  • Current instance
Parent Topic: Data Restoration