Blog

As an Oracle DBA, we should know the details of full backup, archive backup, incremental backup etc. So today we will learn how to check rman backup status in Oracle in detail.

Check rman backup status in Oracle :

Issue the below commands to check the rman backup status :

Query 1 :

set linesize 500 pagesize 3000
col Hours format 9999
col STATUS format a10
select SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'mm-dd-yyyy hh24:mi:ss') as RMAN_Backup_start_time,
to_char(END_TIME,'mm-dd-yyyy hh24:mi:ss') as RMAN_Backup_end_time,
elapsed_seconds/3600 Hours from V$RMAN_BACKUP_JOB_DETAILS
order by session_key;

Output :

Query 2:

alter session set nls_date_format='dd-mon-yyyy hh24:mi:ss';
 
set lines 180
col TIME_TAKEN_DISPLAY format a25
col OUTPUT_BYTES_DISPLAY format a25
col status format a10
col OUTPUT_DEVICE_TYPE format a15
select start_time,end_time,output_device_type,status,input_type,output_bytes_display,time_taken_display
from V$RMAN_BACKUP_JOB_DETAILS
order by start_time asc;

Output:

Or, you can use the below query too to Check the Estimate Time to complete the Job:

SELECT START_TIME, SOFAR, TOTALWORK,round(TIME_REMAINING/60,2) "TIME_REMAINING(mins)",ROUND(SOFAR/TOTALWORK*100,2) "%COMPLETE" FROM GV$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%' AND TOTALWORK != 0 AND OPNAME LIKE '%aggregate%' AND SOFAR <> TOTALWORK;

Hope this article helps.!! Also, you can get further information from Oracle (Doc ID 1487262.1).

Our Other Related Articles :

• How to Check Archive Generation Rate in Oracle
• How to Check Long Running Query in Oracle Database