oceanbase.CDB_OB_BACKUP_DELETE_POLICY

Purpose

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

Columns

Sample query

Query the cleanup policies of all tenants in 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 execution progress of backup cleanup jobs: CDB_OB_BACKUP_DELETE_JOBS

• Query the execution progress of backup cleanup tasks: CDB_OB_BACKUP_DELETE_TASKS

• Query the history of backup cleanup jobs: CDB_OB_BACKUP_DELETE_JOB_HISTORY

• Query the history of backup cleanup tasks: CDB_OB_BACKUP_DELETE_TASK_HISTORY

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