Reporting RMAN Backup Size for Standby databases
Hi,
We have used the view V$RMAN_BACKUP_JOB_DETAILS to report on the details of our RMAN backup jobs on our Primary and Standby databases. e.g. START_TIME, DURATION, STATUS, SIZE, etc
select to_char(start_time,'yyyy-mm-dd hh24:mi'), status, output_bytes_display, time_taken_display
from v$rman_backup_job_details
where end_time > ( sysdate - 7 )
order by 1 desc;
On 11.2.0.2 and 11.2.0.3 the output_bytes_display was consistent with diskspace used on the filesystem.
e.g. du - sg /u07/oracle/STANDBY_PROD/backupset
We recently upgraded to 11.2.0.4. The output_bytes_display is consistent with diskspace used on the filesystem on our Primary database only.