dbawiki

Query to find the oldest records in the catalog. Nothing should be more than a day older than the control_file_record_keep_time parameter.

select db_name,input_type,min(start_time)
from RC_RMAN_BACKUP_JOB_DETAILS
where  1=1
group by db_name,input_type order by 3
/