Script to Check RMAN Backup status

      No Comments on Script to Check RMAN Backup status

This script will provide you to check the current running RMAN backup status and backup history whether its completed/running or failed with any issue.

 set line 190
col STATUS format a30
col hrs format 999.99
select
SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,
to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,
elapsed_seconds/3600 hrs
from V$RMAN_BACKUP_JOB_DETAILS
order by session_key;

Sample Output-

Leave a Reply

Your email address will not be published. Required fields are marked *