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;
Explore Oracle Hybrid Columnar Compression (HCC) through a hands-on lab comparing OLTP, Query, and Archive…
Revisit my popular, hands-on workshop guiding you through Oracle 19c's Automatic Indexing! I'll show you…
Unlock the power of Oracle 19c's multitenant architecture by converting your existing non-CDB databases into…
Learn how Oracle 19c simplifies privilege management with its built-in analysis tools, ensuring a 'least…
Struggling with WordPress backups? Learn how to set up an automated, custom shell script for…
After 18 enriching years in the tech world, I recently took a deliberate break, a…