Note
This view is available starting with V4.0.0.
Purpose
This view displays the historical information about backup cleanup tasks executed in a tenant.
Columns
Column |
Type |
Nullable |
Description |
||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column | Type | Nullable | Description | --- | --- | --- | --- | JOB_ID | NUMBER(38) | NO | The task ID, which is a monotonic increasing value. | ||
| Column | Type | Nullable | Description | --- | --- | --- | --- | INCARNATION | NUMBER(38) | NO | incarnation id. | ||
| INITIATOR_TENANT_ID | NUMBER(38) | NO | The ID of the tenant that initiated the job. | ||||||||||
| INITIATOR_JOB_ID | NUMBER(38) | NO | ID of the job initiator tenant. | ||||||||||
| JOB_ID | |||||||||||||
| EXECUTOR_TENANT_ID | VARCHAR2(65536) | NO | The list of tenants that execute cleanup tasks | ||||||||||
| TYPE | VARCHAR2(64) | NO | Cleanup type. Valid value:
|
||||||||||
| PARAMETER | VARCHAR2(1024) | NO | The value of the parameter contains the following elements: |
||||||||||
| COLUMN | TYPE | NULLABLE | DESCRIPTION | --- | --- | --- | --- | JOB_LEVEL | VARCHAR2(64) | NO | The task initiator level, which can be USER_TENANT, CLUSTER, or SYS_TENANT. | ||
| START_TIMESTAMP | VARCHAR2(256) | NO | Current time for the tenant when the task starts | ||||||||||
| END_TIMESTAMP | VARCHAR2(256) | NO | The time on the tenant when the task ends. | ||||||||||
| STATUS | VARCHAR2(64) | NO | Task status: |
||||||||||
| TASK_COUNT | NUMBER(38) | YES | the number of backup_set/piece tasks | ||||||||||
| SUCCESS_TASK_COUNT | NUMBER(38) | YES | The number of tasks that have been successfully executed by a backup set or backup piece. | ||||||||||
| RESULT | NUMBER(38) | NO | Error code | ||||||||||
| COMMENT | VARCHAR2(4096) | YES | The description of a task. |
Sample query
The query result contains the first five records of the tenant backup cleanup tasks performed by the tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_DELETE_JOB_HISTORY WHERE ROWNUM <= 5\G
The query result is as follows:
*************************** 1. row ***************************
JOB_ID: 20
INCARNATION: 1
INITIATOR_TENANT_ID: 1004
INITIATOR_JOB_ID: 20
EXECUTOR_TENANT_ID: 1004
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: 2025-01-07 06:33:50.079557
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-01-08 06:33:50.084931
END_TIMESTAMP: 2025-01-08 06:33:50.160191
STATUS: COMPLETED
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
*************************** 2. row ***************************
JOB_ID: 21
INCARNATION: 1
INITIATOR_TENANT_ID: 1004
INITIATOR_JOB_ID: 21
EXECUTOR_TENANT_ID: 1004
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: 2025-01-07 07:33:50.384197
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-01-08 07:33:50.387567
END_TIMESTAMP: 2025-01-08 07:33:50.435527
STATUS: COMPLETED
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
*************************** 3. row ***************************
JOB_ID: 22
INCARNATION: 1
INITIATOR_TENANT_ID: 1004
INITIATOR_JOB_ID: 22
EXECUTOR_TENANT_ID: 1004
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: 2025-01-07 08:33:50.660556
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-01-08 08:33:50.663947
END_TIMESTAMP: 2025-01-08 08:33:50.710906
STATUS: COMPLETED
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
*************************** 4. row ***************************
JOB_ID: 23
INCARNATION: 1
INITIATOR_TENANT_ID: 1004
INITIATOR_JOB_ID: 23
EXECUTOR_TENANT_ID: 1004
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: 2025-01-07 09:33:50.931100
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-01-08 09:33:50.934741
END_TIMESTAMP: 2025-01-08 09:33:50.984381
STATUS: COMPLETED
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
*************************** 5. row ***************************
JOB_ID: 24
INCARNATION: 1
INITIATOR_TENANT_ID: 1004
INITIATOR_JOB_ID: 24
EXECUTOR_TENANT_ID: 1004
TYPE: DELETE OBSOLETE BACKUP
PARAMETER: 2025-01-07 10:33:51.206735
JOB_LEVEL: USER_TENANT
START_TIMESTAMP: 2025-01-08 10:33:51.210244
END_TIMESTAMP: 2025-01-08 10:33:51.258817
STATUS: COMPLETED
TASK_COUNT: 0
SUCCESS_TASK_COUNT: 0
RESULT: 0
COMMENT:
5 rows in set