Overview
Displays the cleanup strategies set for expired cleanup and automatic cleanup under the tenant.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| POLICY_NAME | varchar(256) | NO | Cleanup policy name:
|
| RECOVERY_WINDOW | varchar(64) | NO | Restorable Time Window. Default value: 0. |
Sample query
Users can view the cleanup policies of their own tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_DELETE_POLICY;
The query result is as follows:
+-------------+-----------------+
| POLICY_NAME | RECOVERY_WINDOW |
+-------------+-----------------+
| default | 7d |
+-------------+-----------------+
1 row in set
References
View the execution progress of a backup cleanup job: DBA_OB_BACKUP_DELETE_JOBS
View the execution progress of ongoing backup cleanup tasks: DBA_OB_BACKUP_DELETE_TASKS
View the historical information of backup cleanup job tasks: DBA_OB_BACKUP_DELETE_JOB_HISTORY
View the history of a backup cleanup task: DBA_OB_BACKUP_DELETE_TASK_HISTORY
For detailed operations on setting the cleanup strategy, see Automatically clean up expired backups.