Database Backup and Recovery (MOSC)

MOSC Banner

Reporting RMAN Backup Size for Standby databases

edited Jul 23, 2015 4:50AM in Database Backup and Recovery (MOSC) 2 commentsAnswered ✓

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. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center