Subscribe YouTube Channel For More Live Tutorials

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;