Scripts-Queries

RMAN backup details, Display last 5 days

Following query can be used to get rman backup job details for last 5 days.

set lines 220
col output_bytes_display for a30
col time_taken_display for a30
select session_key,input_type,status,
	   to_char(start_time,'yyyy-mm-dd hh24:mi') start_time,
       to_char(end_time,'yyyy-mm-dd hh24:mi') end_time,
       output_bytes_display,       time_taken_display
from v$rman_backup_job_details
where END_TIME > sysdate-5
order by session_key asc; 
Saumya Padhi

Share
Published by
Saumya Padhi

Recent Posts

Exploring Oracle Hybrid Columnar Compression (HCC): A Hands-On Lab with Real Results (Repost)!

Explore Oracle Hybrid Columnar Compression (HCC) through a hands-on lab comparing OLTP, Query, and Archive…

2 weeks ago

Oracle 19c Automatic Indexing: A Hands-On Workshop (Repost!)

Revisit my popular, hands-on workshop guiding you through Oracle 19c's Automatic Indexing! I'll show you…

2 weeks ago

Seamless Transition: Converting Oracle 19c Non-CDB to Pluggable Database (PDB)

Unlock the power of Oracle 19c's multitenant architecture by converting your existing non-CDB databases into…

2 weeks ago

Refine Permissions with Precision: Mastering Privilege Analysis in Oracle 19c – A Revision

Learn how Oracle 19c simplifies privilege management with its built-in analysis tools, ensuring a 'least…

2 weeks ago

The Simple, Reliable Way to Back Up Your WordPress Blog: A DIY Script for Peace of Mind

Struggling with WordPress backups? Learn how to set up an automated, custom shell script for…

2 weeks ago

My Journey Through Oracle Database World and Cloud world 2025: A Dive into the Future of Data and AI – And a Fresh Start!

After 18 enriching years in the tech world, I recently took a deliberate break, a…

2 weeks ago