RA_EM_SBT_JOB_TEMPLATE
This view lists defined SBT jobs and their statuses for Oracle Enterprise Manager.
| Column | Data Type | NULL | Description |
|---|---|---|---|
TEMPLATE_NAME |
VARCHAR2(128) |
NOT NULL |
The name of the SBT job template. |
FULL_TEMPLATE_NAME |
VARCHAR2(128) |
NOT NULL |
The full name of the SBT job template. |
POLICY_NAME |
VARCHAR2(128) |
The protection policy specifying the protected databases whose backups the Recovery Appliance considers eligible for copying. | |
DB_UNIQUE_NAME |
VARCHAR2(512) |
The unique name of the protected database whose backups the Recovery Appliance considers eligible for copying. | |
ATTRIBUTE_SET_NAME |
VARCHAR2(128) |
NOT NULL |
The name of the SBT attribute set. |
LIB_NAME |
VARCHAR2(128) |
NOT NULL |
The name of the SBT library. |
BACKUP_TYPE |
VARCHAR2(16) |
The types of backups to be copied to tape by this job: ALL, FULL, INCR, ARCH, or TAPE_RESERVE. |
|
PRIORITY |
NUMBER |
The priority for scheduling this job. | |
COPIES |
NUMBER |
NOT NULL |
The number of copies to be created on tape. |
WINDOW |
INTERVAL DAY(2) TO SECOND(6) |
The time allotted for copy tasks to start for this job. | |
FROM_TAG |
VARCHAR2(32) |
The tag for the backup to be copied to tape by this job. | |
ERROR_TEXT |
VARCHAR2(4000) |
The error text for the task that failed. | |
ERROR_LAST_SEEN |
TIMESTAMP(6) WITH TIME ZONE |
The timestamp when the Recovery Appliance most recently detected the error. | |
EXECUTABLE |
NUMBER |
The number of tasks in an executable state. | |
RUNNING |
NUMBER |
The number of tasks that are running or retrying. | |
COMPLETED |
NUMBER |
The number of completed tasks. | |
COMPLETION_TIME |
TIMESTAMP(6) WITH TIME ZONE |
The time of the most recent completed task. | |
STATUS |
VARCHAR2(5) |
The status of the SBT library: READY, PAUSE, or ERROR. |
|
BYTES |
NUMBER |
The number of bytes read or written so far. | |
COMPRESSION_ALGORITHM |
VARCHAR2(6) |
The compression algorithm used by this job: Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later. |