DBA_OB_BACKUP_DELETE_POLICY

Purpose

This view displays the cleanup policies set for expired/automatic cleanup in the tenant.

Columns

Sample query

Query the cleanup policy of the current user tenant.

obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_DELETE_POLICY;

The query result is as follows:

+-------------+-----------------+
| POLICY_NAME | RECOVERY_WINDOW |
+-------------+-----------------+
| default     | 7d              |
+-------------+-----------------+
1 row in set

References

• Query the execution progress of a backup cleanup job: DBA_OB_BACKUP_DELETE_JOBS

• Query the execution progress of a backup cleanup task: DBA_OB_BACKUP_DELETE_TASKS

• Query the historical information of a backup cleanup job: DBA_OB_BACKUP_DELETE_JOB_HISTORY

• Query the historical information of a backup cleanup task: DBA_OB_BACKUP_DELETE_TASK_HISTORY

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