oceanbase.DBA_OB_BACKUP_DELETE_POLICY

Purpose

This view displays the cleanup policies set for tenant-level expiration and automatic cleanup.

Columns

Sample query

Query the cleanup policy of the current 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

• View the execution progress of backup cleanup jobs: DBA_OB_BACKUP_DELETE_JOBS

• View the execution progress of backup cleanup tasks: DBA_OB_BACKUP_DELETE_TASKS

• View the history of backup cleanup jobs: DBA_OB_BACKUP_DELETE_JOB_HISTORY

• View the history of backup cleanup tasks: DBA_OB_BACKUP_DELETE_TASK_HISTORY

• For more information about how to set a cleanup policy, see Automatically clean up expired backups.