News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Script – Check RMAN Backup Status

  • Posted by Arjun Raja
  • On July 28, 2009
  • 2 Comments
  • backup report, backup status, rman

Scripts to check backup status and timings of database backups –

This script will be run in the database, not the catalog.

Login as sysdba –

This script will report on all backups – full, incremental and archivelog backups –

col STATUS format a9
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;

This script will report all on full and incremental backups, not archivelog backups –

col STATUS format a9
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
where input_type='DB INCR'
order by session_key;
 1

2 Comments

shilpa
  • Jun 8 2011
This is really a useful script. Thanks, Shilpa
Rosel
  • Dec 13 2018
Great!!that is what I needed.Thank for sharing RMAN Backup status script.

Leave Reply

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