Latest Updates

Post Top Ad

29 May, 2021

Query to check RMAN BACKUP History

SQL Query to know the history of RMAN Backup






Useful sql query to know about the RMAN Backup history along with TOTAL_GB_BACKEDUP , STATUS, TIME_TAKEN_HOURS etc.



alter session set optimizer_mode=Rule;

set linesize 200
col TAG format a19
col TIME_TAKEN_hours format a16
col total_gb_backedup format a20
col status format a10
col read_mb_per_sec format a10
col write_mb_per_sec format a10
col input_type format a12

select COMMAND_ID Tag,OUTPUT_BYTES_DISPLAY total_gb_backedup, status,INPUT_TYPE,TIME_TAKEN_DISPLAY TIME_TAKEN_hours,
INPUT_BYTES_PER_SEC_DISPLAY read_mb_per_sec ,OUTPUT_BYTES_PER_SEC_DISPLAY write_mb_per_sec from V$RMAN_BACKUP_JOB_DETAILS where INPUT_TYPE='DB FULL' and STATUS like '%COMPLETED%' order by Tag;


Output




Please like and share if you find this blogpost useful.

No comments:

Post Top Ad

Your Ad Spot

Pages