You can check for any errors in the media management software that may affect the ongoing tape backup operations by viewing the current status of a media manager library.

To check the status of a media manager library:

1. Complete the steps "Accessing Recovery Appliance in Cloud Control".

2. From the Recovery Appliance Menu, select Media Managers.

   The Media Managers page lists the status of all existing media manager libraries in the corresponding column.

You can check for any error in the ongoing tape backup operation by viewing the current status of the job.

To view the status of a tape backup job:

1. Complete the steps "Accessing Recovery Appliance in Cloud Control".

2. From the Recovery Appliance Menu, select Copy-to-Tape Job Templates.

   The Copy-to-Tape Job Templates Page displays the status of each tape backup job in its corresponding column.

You can determine if an error condition exists in the media management software by querying the RA_SBT_LIBRARY view. You can also determine the PAUSE state of an SBT library.

To view the status of an SBT library:

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

2. Run the following query:

   SELECT LIB_NAME, LAST_ERROR_TEXT, STATUS 
   FROM   RA_SBT_LIBRARY;
   
   LIB_NAME            LAST_ERROR_TEXT                                 STATUS 
   ------------------- ----------------------------------------------- ------ 
   OSBSBT                                                              READY  
   

   Table 9-3 lists the possible values for STATUS.

   Table 9-3 Values for the STATUS Column of RA_SBT_LIBRARY

   Value	Meaning
   READY	The SBT library was properly created and is ready to process tape I/O.
   PAUSE	The SBT library was paused with PAUSE_SBT_LIBRARY.
   ERROR	An error condition exists in the media management software. Tape backup operations cannot continue until you clear the error and call RESUME_SBT_LIBRARY. The last_error_text column describes the most recent error returned by the media management library. The error text also appears in the RA_SBT_TASK rows for the affected background SBT tasks.

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.

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.

You can determine whether SBT jobs run according to your defined schedule by querying the RA_SBT_JOB.LAST_SCHEDULE_TIME column. This column indicates the last time that the SBT job was scheduled to run.

To review completed 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 TEMPLATE_NAME, BACKUP_TYPE, LAST_SCHEDULE_TIME 
   FROM   RA_SBT_JOB;
   
   TEMPLATE_NAME          BACKUP_TYPE          LAST_SCHEDULE_TIME
   ------------------  -------------------  ----------------------------
   OLTP_ARCH_LASTFULL  ARCH, FULL           27-AUG-12 10.53.49 AM -08:00
   OLTP_INCR           INCR                 26-AUG-12 10.16.16 AM -08:00

To view the status of an Oracle Scheduler job created to run an SBT job:

• Query the following views:

  • USER_SCHEDULER_JOBS

  • USER_SCHEDULER_JOB_LOG