RA_SBT_TASK

This view lists the queued background SBT tasks and their run statuses.

Column	Data Type	NULL	Description
`TASK_ID`	`NUMBER`		The ID for the task.
`STATE`	`VARCHAR2(47)`		The processing state for the task: `EXECUTABLE`, `RUNNING`, `COMPLETED`, `TASK_WAIT`, `FAILED`, and so on.
`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.
`EXECUTE_INSTANCE_ID`	`NUMBER`		The ID of the database instance ID on which the task must run. The column is null if the task can run on any instance.
`ERROR_COUNT`	`NUMBER`		The number of times that the task had errors.
`ERROR_TEXT`	`VARCHAR2(4000)`		The error text for the task that failed.
`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.
`RESTORE_TASK`	`VARCHAR2(3)`		The type of task: `YES` if this is a restore task; `NO` if this is a backup task.
`BS_KEY`	`NUMBER`		The key of the backup set that is accessed by this task.
`PIECE#`	`NUMBER`		The number of the backup piece that is accessed by this task.
`COPIES`	`NUMBER`		The number of copies created by this task.
`TEMPLATE_NAME`	`VARCHAR2(128)`		The SBT job template to which this task belongs.
`ATTRIBUTE_SET_NAME`	`VARCHAR2(128)`		The name of the SBT attribute set to which this task belongs.
`LIB_NAME`	`VARCHAR2(128)`	`NOT NULL`	The name of the SBT library used by this task.
`COMPRESSION_ALGORITHM`	`VARCHAR2(6)`		The compression algorithm used by this task: `NONE`, `BASIC`, `LOW`, `MEDIUM`, `HIGH`, or `OFF`. `OFF` indicates that compression was explicitly turned off for this task (the compression setting in the SBT job template was ignored).
`ENCRYPTION_ALGORITHM`	`VARCHAR2(6)`		Encryption algorithm used by this task.
`REPLICATION`	`VARCHAR2(3)`		The type of task: `YES` if this is a replication task; `NO` if this is an SBT task.
`FILENAME`	`VARCHAR2(513)`		The name of the backup file being read or written.
`START_TIME`	`TIMESTAMP(6) WITH TIME ZONE`		The start time of this task.
`BYTES`	`NUMBER`		The number of bytes read or written so far.
`TOTAL`	`NUMBER`		The total number of bytes to be read or written.
`IS_GROUP_BACKUP`	`VARCHAR2(3)`		`YES` means that the backup was created by assembling a set of individual archive logs into a bigger piece to improve tape performance. `NO` means that the backup was created by individual archive logs.
`LIB_KEY`	`NUMBER`	`NOT NULL`	Key for tape/replication library used by task.
`STATUS`	`VARCHAR2(5)`		The SBT library status: `READY`, `PAUSE`, `ERROR`, or null.
`LIB_TYPE`	`VARCHAR2(11)`		Specifies the type of library.
`ARCHIVED`	`CHAR(1)`		`N` if this is a current task, `Y` if this is a completed task.
`KEEP_OPTIONS`	`NUMBER`		The keep options of the backup set that is accessed by this task
`KEEP_UNTIL`	`TIMESTAMP(6) WITH TIME ZONE`		The retention time of the backup set that is accessed by this task.
`TAG`	`VARCHAR2(128)`		The user specified tag for copied piece that is accessed by this task.