qbackup.sql

The qbackup script will display the status, timing and size of the RMAN backups.

SQL

col STATUS format a9
col hrs format 999.99
col “Size” format a10
select
SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,’dd/mm/yy hh24:mi’) start_time,
to_char(END_TIME,’dd/mm/yy hh24:mi’) end_time,
elapsed_seconds/3600 hrs,
OUTPUT_BYTES_DISPLAY “Size”
from V$RMAN_BACKUP_JOB_DETAILS
order by session_key;

Output

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s