How to check RMAN backup details in the sql

We can check RMAN backup details in the sql using the below sql

col STATUS format a9
col hrs format 999.99
select SESSION_KEY,SESSION_RECID,SESSION_STAMP, 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 is very helpful when you are operating in a DBCS(Database Cloud Service) environment with automated backup.

The status could be

RUNNING WITH WARNINGS
RUNNING WITH ERRORS
COMPLETED
COMPLETED WITH WARNINGS
COMPLETED WITH ERRORS
FAILED

The input_type determine the type of backup

Contains one of the following values. If the user command does not satisfy one of them, then preference is given in order, from top to bottom of the list.
DB FULL
RECVR AREA
DB INCR
DATAFILE FULL
DATAFILE INCR
ARCHIVELOG
CONTROLFILE
SPFILE

If you want to see the output of a particular backup,use below query

To get the Backup job output for a specific backup job, identified by the (SESSION_RECID, SESSION_STAMP) pair, use the following query:

set lines 200
set pages 1000
select output
from GV$RMAN_OUTPUT
where session_recid = &SESSION_RECID
and session_stamp = &SESSION_STAMP
order by recid;

Hope you this article and find it useful

Related Articles

How to correct Oracle RMAN-20004 Backup failure
Oracle Recovery Manager :RMAN cheatsheet
Oracle RMAN Interview Questions