Help Center/ GaussDB/ User Guide/ Data Restoration/ GaussDB Restoration Methods for Data Misoperations
Updated on 2025-02-17 GMT+08:00

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

Use the database and table restoration method to restore the table.

  • All databases and tables
  • Certain databases and tables

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

Use the database and table restoration method to restore the database.

  • All databases and tables
  • Certain databases and tables

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

Use the database and table restoration method to restore table data.

  • All databases and tables
  • Certain databases and tables