Note
This view is available starting with V4.0.0.
Purpose
This view displays the cleanup strategy set for the tenant for expired backup cleanup or automatic backup cleanup.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| POLICY_NAME | varchar(256) | NO | The name of the cleanup strategy.
|
| RECOVERY_WINDOW | varchar(64) | NO | The time window for recovery. Default value: 0 |
Sample query
Query the cleanup strategy of the user 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
Query the progress of the backup cleanup job task that is being executed: DBA_OB_BACKUP_DELETE_JOBS
Query the progress of the backup cleanup task task that is being executed: DBA_OB_BACKUP_DELETE_TASKS
Query the history information of the backup cleanup job task: DBA_OB_BACKUP_DELETE_JOB_HISTORY
Query the history information of the backup cleanup task task: DBA_OB_BACKUP_DELETE_TASK_HISTORY
For more information about how to set a cleanup strategy, see Automatically clear expired backups.