Don't know about it 'cause I'm no oracle guru, but:

With following statement one can look for older active oracle backup
objects. One will get a list of all active oracle backup objects
(filespace_name=/adsmorc if using defaults) ordered by age. So one can
compare what's in ebu and what's in adsm. Active objects without
corresponding ebu entry are NEVER deleted with ebu!

But watch for cpu util and runtime.

select
node_name,hl_name,ll_name,cast((current_timestamp-deactivate_date)days
as decimal(4,0)) as Age from backups where filespace_name='/adsmorc'
order by Age desc

regards
Roger