ApsaraDB for OceanBase:Recycle bin of a tenant

Prerequisites

The recycle bin feature is enabled for the cluster instance to which the target tenant belongs. For more information, see Recycle bin of a cluster instance.

View objects in the recycle bin

1. Log on to the ApsaraDB for OceanBase console.

2. In the left-side navigation pane, click Instances.

3. In the instance list, click the name of the target cluster instance to go to the Cluster Instance Workspace page.

4. In the left-side navigation pane, click Tenant Management. In the tenant list, click the name of the target tenant to go to the Tenant Workspace page.

5. In the left-side navigation pane, click Recycle Bin.

   1. In the recycle bin of a MySQL tenant, you can view information about the dropped databases and tables. Click Delete in the Actions column to physically drop a database or table from the recycle bin, or click Restore to restore the database or table. You can select multiple databases or tables in the recycle bin for batch dropping or restoration.

      Note

      • If you physically drop or restore a database, the tables in the database are also physically dropped or restored. Physical dropping is irreversible. Proceed with caution in the production environment.

      • A restored database or table may have a duplicate name with other databases or tables. Therefore, you must rename a restored database or table when necessary.

      • When you perform a batch dropping or restoration, you can select at most 50 objects.

   2. In the recycle bin of an Oracle tenant, you can view information about the dropped tables. Click Delete in the Actions column to physically drop a table from the recycle bin, or click Restore to restore the table. You can select multiple tables in the recycle bin for batch dropping or restoration.

      Note

      • Physical dropping of tables is irreversible. Proceed with caution in the production environment.

      • A restored table may have a duplicate name with other tables. Therefore, you must rename a restored table when necessary.

      • When you perform a batch dropping or restoration, you can select at most 50 objects.

Purge the recycle bin

On the recycle bin page, click Empty Recycle Bin in the upper-right corner to physically drop the databases and tables in the recycle bin to release the occupied disk space.