select operation as "OPERACAO",
object_type as "TIPO",
status,
output_device_type as "MEDIA",
to_char(end_time,'DD-MM-RRRR HH24:MI:SS') as "DATA",
round(MBYTES_PROCESSED/1024,2) as "TAMANHO(MB)"
from
v$rman_status
where
operation = 'BACKUP'
and trunc(end_time)>=trunc(sysdate-1)
order by
end_time
SQL> /
OPERACAO TIPO STATUS MEDIA DATA TAMANHO(MB)
---------- ------------- ---------- ---------- ------------------- -----------
BACKUP ARCHIVELOG COMPLETED SBT_TAPE 04-02-2013 09:17:55 19.87
BACKUP ARCHIVELOG COMPLETED SBT_TAPE 04-02-2013 12:05:11 6.48
BACKUP ARCHIVELOG COMPLETED SBT_TAPE 05-02-2013 00:06:20 3.87
BACKUP ARCHIVELOG COMPLETED SBT_TAPE 05-02-2013 12:05:38 8.61
0 comentários:
Post a Comment