DBA_OB_BACKUP_DELETE_POLICY

Purpose

This view displays the cleanup policies 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

• View the execution progress of the backup cleanup job task: DBA_OB_BACKUP_DELETE_JOBS

• View the execution progress of the backup cleanup task task: DBA_OB_BACKUP_DELETE_TASKS

• View the history of the backup cleanup job task: DBA_OB_BACKUP_DELETE_JOB_HISTORY

• View the history of the backup cleanup task task: DBA_OB_BACKUP_DELETE_TASK_HISTORY

• For more information about how to set a cleanup policy, see Automatic cleanup of expired backups.