› Fóruns › Banco de dados Oracle › RMAN COMPLETE WITH ERRORS › RMAN COMPLETE WITH ERRORS
18 de outubro de 2013 às 10:16 pm
#106044
Participante
na view v$rman_status, utilizando o script abaixo :
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(GB)”,
to_char(START_TIME,’DD-MM-RRRR HH24:MI:SS’) as “INICIO”
from
v$rman_status
where
operation <> ‘CATALOG’
and trunc(end_time)>=trunc(sysdate-1)
order by
end_time;