Pular para o conteúdo

Fóruns Banco de dados Oracle RMAN COMPLETE WITH ERRORS RMAN COMPLETE WITH ERRORS

#106044
maperes
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;