How to check RMAN backup status and timings

How to check RMAN backup status and timings

Hello friends, in this article we learn how to check RMAN backup status and timings on the target database.

Using the following command you will get the details about currently running RMAN and ARCHIVE backup. Click Here for YouTube

Query to check RMAN backup status

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;

RMAN Backup status

The result from the above query:

RMAN backup status and timings

RMAN Backup completed:

RMAN backup status and timings

Check RMAN historical backup details

Using the below query you can find old RMAN backup details.

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

Related Post: Querying Tablespace Usage

Connect with me on:

Instagram: https://www.instagram.com/shripaldba
Linkedin: 
https://www.linkedin.com/in/shripal-singh
Twitter: 
https://twitter.com/ocptechnology
Facebook: 
https://www.facebook.com/ocptechnology
YouTube:
 https://www.youtube.com/ocptechnology

Share this
Share
Share