Backup reports contain summary and detailed information about past backup jobs run by Oracle Recovery Manager (RMAN). The view V$RMAN_BACKUP_JOB_DETAILS contains information about backup jobs run by RMAN. This view contains information such as the time taken for the backup, when a job started and finished, and what type of backup was performed, and the status of the backup job.
To display backup reports:
Use the following query to display the backup job history.
SELECT SESSION_KEY,INPUT_TYPE,STATUS,START_TIME,END_TIME,ELAPSED_SECONDS/3600 hrs
FROM V$RMAN_BACKUP_JOB_DETAILS;
SESSION_KEY INPUT_TYPE STATUS START_TIM END_TIME HRS
----------- ------------- ----------------------- --------- --------- ----------
8 DB FULL FAILED 27-MAR-12 27-MAR-12 1.64666666
50 DB FULL COMPLETED 28-MAR-12 28-MAR-12 .243055555
69 DB FULL COMPLETED 30-MAR-12 05-APR-12 147.176388
SESSION_KEY is the unique key for the RMAN session in which the backup job occurred.