Note
This view is available starting with V4.0.0.
Overview
Displays the cleanup strategies set for expired cleanup and automatic cleanup under a tenant.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| POLICY_NAME | varchar(256) | NO | Cleanup Policy Name |
| RECOVERY_WINDOW | varchar(64) | NO | Recoverable Time Window. Default value: 0. |
Sample query
You can view the cleanup policies of the current 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 ongoing backup cleanup job tasks: 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 information 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.