Wednesday, August 10, 2011

Check RMAN Backup Status

There is a very good script shared by one of the famous DBA "Gavin Soorma" on his site whic is related to Rman Backup status .I am sharing the same script here . Here is the link :


http://gavinsoorma.com/2009/07/rman-script-to-check-backups/comment-page-1/
This script will report on all backups – full, incremental and archivelog backups .


SQL> 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 -
SQL> 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 ;




Enjoy    :-)

3 comments:

amith said...

Hey neeraj u have clearly copied below url pasted..

http://gavinsoorma.com/2009/07/rman-script-to-check-backups/

NEERAJ VISHEN said...
This comment has been removed by the author.
NEERAJ VISHEN said...

@amith

Hey amit , If you have read the whole article then you find that i have already mention the reference i.e, from gavin site .
I don't think there is any issue in this and his site is not copyrighted . ;)