1. Administrator's Guide
  2. Managing Recovery Appliance
  3. Copying Backups to Tape with Recovery Appliance
  4. Viewing the Status of Tape Backup Operations
  5. Viewing the Status of Tape Backup Operations Using DBMS_RA
  6. Reviewing SBT Job Runs Using DBMS_RA

Reviewing SBT Job Runs Using DBMS_RA

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

See Also:

"RA_SBT_LIBRARY"