A list of rman backups directly from the controlfile



From 10gR2 oracle offers the dynamic view v$rman_backup_job_details, which lists the rman backups that have been performed (successful or not) for the last four weeks aproximately (it probably depends on the amount of backups that have been taken and on the specified retantion period for the controlfile). Again, the list comes from the database itself.
  SELECT   start_time,input_type , status, output_device_type, time_taken_display
  FROM     v$rman_backup_job_details
  ORDER BY start_time


START_TIME        INPUT_TYPE    STATUS                  OUTPUT_DEVICE_TYP TIME_TAKEN_DISPLAY
----------------- ------------- ----------------------- ----------------- --------------------
09:16 25-nov-2009 ARCHIVELOG    FAILED                         00:01:51
09:21 25-nov-2009 ARCHIVELOG    FAILED                         00:01:41
09:26 25-nov-2009 ARCHIVELOG    FAILED                         00:01:40
09:36 25-nov-2009 ARCHIVELOG    COMPLETED    SBT_TAPE          00:03:37
20:01 25-nov-2009 DB INCR       COMPLETED    SBT_TAPE          00:08:00
20:13 25-nov-2009 ARCHIVELOG    COMPLETED    SBT_TAPE          00:03:13
06:57 26-nov-2009 ARCHIVELOG    COMPLETED    SBT_TAPE          00:09:24
08:51 26-nov-2009 ARCHIVELOG    COMPLETED    SBT_TAPE          00:25:23
20:01 26-nov-2009 DB INCR       COMPLETED    SBT_TAPE          00:07:38
20:13 26-nov-2009 ARCHIVELOG    COMPLETED    SBT_TAPE          00:03:42
09:08 27-nov-2009 ARCHIVELOG    COMPLETED    SBT_TAPE          00:04:29
20:34 27-nov-2009 DB INCR       COMPLETED    SBT_TAPE          00:07:30
20:53 27-nov-2009 ARCHIVELOG    COMPLETED    SBT_TAPE          00:04:01
06:59 28-nov-2009 ARCHIVELOG    COMPLETED    SBT_TAPE          00:19:28
21:17 29-nov-2009 ARCHIVELOG    COMPLETED    SBT_TAPE          00:03:05
06:52 30-nov-2009 ARCHIVELOG    COMPLETED    SBT_TAPE          00:05:49
08:06 30-nov-2009 ARCHIVELOG    COMPLETED    SBT_TAPE          00:03:24
19:44 30-nov-2009 ARCHIVELOG    COMPLETED    SBT_TAPE          00:03:03
20:11 30-nov-2009 DB INCR       COMPLETED    SBT_TAPE          00:08:32
The same list is available in the database console

Maintenance tab

Backup reports

Backup reports

Pressing on the link "completed" the output of the rman script is shown.

Backup details

This can be very handy, without any need of looking for log files on the server.

Rate this note ...
Useless Poor Average Good Very helpful