Bundan önce alınan rman yedeklerinin listesini veren yararlı bir script.

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;

Yararlı olması Dilegiyle…
Yazar : Mustafa Bektaş Tepe

1,256 total views, no views today