Script to find last RMAN backup executed in Oracle

The script will list all RMAN backups that have finished in the last 24 hours and are FULL , you get the status, start time and end time

select
    operation,
    status,
    object_type,
    to_char(start_time,'mm/dd/yyyy:hh:mi:ss') as start_time,
    to_char(end_time,'mm/dd/yyyy:hh:mi:ss') as end_time
from
    v$rman_status
where
    start_time > SYSDATE -1
and
    operation = 'BACKUP'
and
    object_type = 'DB FULL'
order by
    start_time desc;


Leave a comment or a question in the comment area bellow if you fell like


Be a sport and

Search

Loading... Please wait

Subscribe to our Newsletter

Be a sport and

x