Checking the Tape Backup Job Status

When an SBT job runs it generates and queues a task for each backup piece to be copied. The view RA_SBT_TASK lists these tasks and their completion states.

Note:

Completed tasks are removed from this view after 30 days.

To check the status of SBT jobs:

1. With SQL*Plus or SQL Developer, connect to the Recovery Appliance metadata database as the Recovery Appliance administrator.

2. Run the following query (sample output shown):

   SELECT TASK_ID, STATE, DB_UNIQUE_NAME, ERROR_TEXT, BS_KEY, PIECE#
   FROM   RA_SBT_TASK 
   WHERE  SBT_TEMPLATE_NAME = 'SBTJOB1'
   ORDER BY DB_UNIQUE_NAME, BS_KEY, PIECE#;
   
   TASK_ID STATE      DB_UNIQUE_NAME ERROR_TEXT           BS_KEY PIECE#
   ------- ---------- -------------- -------------------- ------ ------
       253 COMPLETED  OLTP1                                   89      1
       254 COMPLETED  OLTP1                                   95      1
       255 COMPLETED  OLTP1                                   99      1
       256 COMPLETED  OLTP1                                  117      1
       257 COMPLETED  OLTP1                                  141      1
   

   A task failed if its STATE is KILLED or ABORTED.