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:
-
With SQL*Plus or SQL Developer, connect to the Recovery Appliance metadata database as the Recovery Appliance administrator.
-
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: