SQL Query to find Progress of RMAN Backup

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

10 thoughts on “SQL Query to find Progress of RMAN Backup”

  1. Hey I know this is off topic but I was wondering
    if you knew of any widgets I could add to my blog that automatically tweet my
    newest twitter updates. I’ve been looking for a plug-in like this for quite some time and was hoping maybe you would have
    some experience with something like this. Please let me
    know if you run into anything. I truly enjoy reading your blog and I look
    forward to your new updates.

    my web page … nordvpn coupons inspiresensation (tinyurl.com)

  2. nordvpn code
    350fairfax
    Wonderful work! This is the type of information that are supposed to be shared across
    the net. Shame on the search engines for no longer positioning this put up upper!

    Come on over and discuss with my web site . Thanks =)

  3. Do you mind if I quote a few of your articles as long as I provide credit and sources back to your webpage? My blog is in the very same niche as yours and my visitors would really benefit from some of the information you present here. Please let me know if this ok with you. Appreciate it!

Leave a Reply

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