DBA_OB_BACKUP_DELETE_POLICY

Purpose

This view displays the cleanup policy for expired or automatic cleanup set for the tenant.

Columns

Sample query

Query the cleanup policy of the 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 progress of backup cleanup job tasks: DBA_OB_BACKUP_DELETE_JOBS

• Query the progress of backup cleanup task tasks: DBA_OB_BACKUP_DELETE_TASKS

• Query the history of backup cleanup job tasks: DBA_OB_BACKUP_DELETE_JOB_HISTORY

• Query the history of backup cleanup task tasks: DBA_OB_BACKUP_DELETE_TASK_HISTORY

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