Overview
Displays the cleanup strategies set for expiration cleanup and automatic cleanup under each tenant.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| POLICY_NAME | varchar(256) | NO | Cleanup Policy Name:
|
| RECOVERY_WINDOW | varchar(64) | NO | Restorable Time Window. Default value: 0. |
Sample query
The sys tenant can view the cleanup strategies of all tenants.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_DELETE_POLICY;
The query result is as follows:
+-----------+-------------+-----------------+
| TENANT_ID | POLICY_NAME | RECOVERY_WINDOW |
+-----------+-------------+-----------------+
| 1002 | default | 7d |
+-----------+-------------+-----------------+
1 row in set
References
View the execution progress of a job task that is cleaning up backups: CDB_OB_BACKUP_DELETE_JOBS
View the execution progress of ongoing backup cleanup tasks: CDB_OB_BACKUP_DELETE_TASKS
View the historical information of backup cleanup job tasks: CDB_OB_BACKUP_DELETE_JOB_HISTORY
View the history of backup cleanup tasks: CDB_OB_BACKUP_DELETE_TASK_HISTORY
For detailed operations on setting the cleanup strategy, see Automatically clean up expired backups.