Note
This view is available starting with V4.0.0.
Purpose
This view displays the deletion policies set for expired or automatic cleanup in the tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| POLICY_NAME | varchar(256) | NO | The name of the deletion policy. |
| RECOVERY_WINDOW | varchar(64) | NO | The time window for data recovery. Default value: 0. |
Sample query
Query the deletion policy of the current user tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_BACKUP_DELETE_POLICY;
The query result is as follows:
+-------------+-----------------+
| POLICY_NAME | RECOVERY_WINDOW |
+-------------+-----------------+
| default | 7d |
+-------------+-----------------+
1 row in set