RA_TASK
This view lists queued background tasks and their run statuses.
| Column | Data Type | NULL | Description |
|---|---|---|---|
TASK_ID |
NUMBER |
The ID for the task. | |
TASK_TYPE |
VARCHAR2(30) |
The type of processing performed by the task. | |
PRIORITY |
NUMBER |
The run priority for the task. | |
STATE |
VARCHAR2(47) |
The processing state for the task: EXECUTABLE, RUNNING, COMPLETED, TASK_WAIT, FAILED, and so on. |
|
WAITING_ON |
NUMBER |
The ID of the task that is blocking this task when its state is TASK_WAIT. |
|
WAITING_ON_TASK_TYPE |
VARCHAR2(30) |
The task_type of the WAITING_ON task. |
|
WAITING_ON_STATE |
VARCHAR2(21) |
The task state of the WAITING_ON task. |
|
CREATION_TIME |
TIMESTAMP(6) WITH TIME ZONE |
The time of task creation. | |
COMPLETION_TIME |
TIMESTAMP(6) WITH TIME ZONE |
The timestamp for task completion. The column is null if the task is not complete. | |
ELAPSED_SECONDS |
NUMBER |
The elapsed run time (in seconds) for the task. | |
ERROR_COUNT |
NUMBER |
Number of times that the task had errors | |
INTERRUPT_COUNT |
NUMBER |
The number of times that the task was interrupted. | |
LAST_INTERRUPT_TIME |
TIMESTAMP(6) WITH TIME ZONE |
The most recent time that the task was interrupted. | |
EXECUTE_INSTANCE_ID |
NUMBER |
The ID of the database instance on which the task must run. The column is null if the task can run on any instance. | |
LAST_EXECUTE_TIME |
TIMESTAMP(6) WITH TIME ZONE |
The most recent time that the task was restarted. | |
DB_UNIQUE_NAME |
VARCHAR2(30) |
The unique name of the protected database for which the task is running. | |
DB_KEY |
NUMBER |
The primary key of the protected database for which the task is running. | |
SL_NAME |
VARCHAR2(128) |
The name of the Recovery Appliance storage location used by the task. | |
SL_KEY |
NUMBER |
The primary key of the Recovery Appliance storage location used by the task. | |
OSPID |
VARCHAR2(128) |
The platform-specific ID of the process in which the task is current running. | |
INSTANCE_ID |
NUMBER |
The ID of the database instance on which the task is currently running. | |
LAST_INCIDENT_ID |
NUMBER |
The ID of the last incident reported by the task that is currently running. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later. |
|
BP_KEY |
NUMBER |
The key of the backup piece that is accessed by this task. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later. |
|
BS_KEY |
NUMBER |
The key of the backup set that is accessed by this task. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later. |
|
DF_KEY |
NUMBER |
The key of the data file that is accessed by this task. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later. |
|
VB_KEY |
NUMBER |
The key of the virtual backup that is accessed by this task. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later. |
|
HANDLE |
VARCHAR2(1000) |
The media manager handle that is accessed by this task. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later. |
|
FILENAME |
VARCHAR2(4000) |
The name of the backup file that is accessed by this task. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later. |
|
LIB_KEY |
NUMBER |
The unique identifier of the SBT library that is accessed by this task. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later. |
|
ARCHIVED |
CHAR(1) |
The archive status of the task: Y if it has moved to the archive; otherwise, N. |
|
TENANT_NAME |
VARCHAR2 |
The tenant name for this database in the Recovery Appliance. | |
TENANT_IDENTIFIER |
NUMBER |
The customer tenant identifier for this database in the Recovery Appliance. |