oceanbase.CDB_OB_BACKUP_DELETE_POLICY

Purpose

This view displays the backup cleanup policies set for tenants for expired backup cleanup and automatic backup cleanup.

Columns

Sample query

Query the backup cleanup policies of all tenants as the sys tenant.

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

• Query the progress of backup cleanup job tasks in progress: CDB_OB_BACKUP_DELETE_JOBS

• Query the progress of backup cleanup task tasks in progress: CDB_OB_BACKUP_DELETE_TASKS

• Query the historical information of backup cleanup job tasks: CDB_OB_BACKUP_DELETE_JOB_HISTORY

• Query the historical information of backup cleanup task tasks: CDB_OB_BACKUP_DELETE_TASK_HISTORY

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