ON CALL DBA SUPPORT

— Database blog

QUERY TO FIND RMAN BACKUP STATUS IN A DATABASE

Posted by ssgottik on 31/10/2014

set lines 200;
set pages 200;
SELECT INPUT_TYPE “Backup Type”,incremental_level,d.session_recid,
TO_CHAR(d.START_TIME,’mm/dd/yy hh24:mi’) “start_time”,
TO_CHAR(END_TIME,’mm/dd/yy hh24:mi’) “End_time”,
d.elapsed_seconds/3600 “Elapsed Time”,
d.status
FROM V$RMAN_BACKUP_JOB_DETAILS d,V$BACKUP_SET_DETAILS s where d.session_recid=s.session_recid and d.START_TIME>sysdate-2 order by End_time desc;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: