1. Administrator's Guide
  2. Recovery Appliance Reference
  3. Recovery Appliance View Reference
  4. RA_TASK

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.