Size of RMAN Backups - SQL Query

 

Size of RMAN Backups

From the Target Database:

Connect SQL*Plus to the database whose backup history you intend to query.

Query the V$RMAN_BACKUP_JOB_DETAILS view for information about the backup type, status, start time,end time, Size of the backup etc.

The following query shows the backup job history ordered by session key, which is the primary key for the RMAN session:

set pages 2000 lines 200

COL STATUS FORMAT a9

COL hrs FORMAT 999.99

select INPUT_TYPE,

STATUS,

TO_CHAR(START_TIME,'mm/dd/yy hh24:mi') start_time,

TO_CHAR(END_TIME,'mm/dd/yy hh24:mi') end_time,

ELAPSED_SECONDS/3600 hrs,

INPUT_BYTES/1024/1024/1024 SUM_BYTES_BACKED_IN_GB,

OUTPUT_BYTES/1024/1024/1024 SUM_BACKUP_PIECES_IN_GB,

OUTPUT_DEVICE_TYPE

FROM V$RMAN_BACKUP_JOB_DETAILS

order by SESSION_KEY;