Tuesday, February 5, 2013

Oracle Rman Show Backups


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