Rman backup list


SET LINES 110
SET PAGES 20
COLUMN "Start Data" FOR a20
COLUMN "End Date" FOR a20
COLUMN "Time Minute" FORMAT a15
COLUMN status FORMAT a11
COLUMN input_bytes_display FORMAT a10
COLUMN output_bytes_display FORMAT a10
 
TITLE CENTER RMAN_Backup_List_REPORT SKIP 2

  SELECT TO_CHAR (start_time, 'YYYY.MM.DD HH24:MI:SS') "Start Data",
 TO_CHAR (end_time, 'YYYY.MM.DD HH24:MI:SS') "End Date",
 TO_CHAR (ROUND ( (end_time - start_time) * 24 * 60)) || ' dk'
 "Time Minute",
 status,
 input_type,
 input_bytes_display,
 output_bytes_display
 FROM V$RMAN_BACKUP_JOB_DETAILS
 WHERE (start_time BETWEEN (SYSDATE - 12) AND (SYSDATE))
ORDER BY start_time;
Advertisements

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

%d bloggers like this: