The tenant database and table recycle bin manages databases and tables deleted within the current tenant. This topic describes how to manage the recycle bin, including viewing recycled objects and clearing the recycle bin.
Prerequisites
The recycle bin is enabled for the instance to which the tenant belongs. For details, see Instance database and table recycle bin.
Manage the tenant database and table recycle bin
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
In the instance list, find the target cluster and click the expand icon to the left of the cluster name.
Under the expanded cluster, click the target tenant name.
In the left-side navigation pane of the tenant workbench, click Recycle Bin to manage the tenant database and table recycle bin.
View the tenant database and table recycle bin
Open the tenant database and table recycle bin page.
View deleted objects on the recycle bin page.
Click the Databases tab to view deleted databases, including Original Database Name, Storage Used, Recycle Time (UTC+8), Auto Cleanup Time (UTC+8), Status, and Actions.
Click the button in the Actions column and select Delete, or select multiple databases and click Batch Delete at the bottom of the page to permanently delete the selected databases. After you confirm the deletion, the status of the specified database changes to Deleting until the deletion task is completed.
Click the button in the Actions column and select Restore, or select multiple databases and click Batch Restore at the bottom of the page to restore the selected databases. After you confirm the restore, the status of the specified database changes to Restoring until the restore task is completed.
Click the Tables tab to view deleted tables, including Original Table Name, Original Database, Storage Used, Recycle Time (UTC+8), Auto Cleanup Time (UTC+8), Status, and Actions.
Click the button in the Actions column and select Delete, or select multiple tables and click Batch Delete at the bottom of the page to permanently delete the selected tables.
Click the button in the Actions column and select Restore, or select multiple tables and click Batch Restore at the bottom of the page to restore the selected tables.
Clear the tenant database and table recycle bin
Notice
The default auto cleanup period for the recycle bin is 7 days (consistent with the backup and restore period). The maximum period is 1096 days. However, manually clearing the recycle bin or setting an auto cleanup period shorter than the backup and restore period may prevent 100% lossless recovery.
Open the tenant database and table recycle bin page.
On the recycle bin page, you can view the auto cleanup period, which is configured in the instance database and table recycle bin. For details, see Instance database and table recycle bin.
Click Empty Recycle Bin in the upper-right corner of the page to manually clear the recycle bin.