Sambavan:

Thanks for the query. I was mainly interested to know whether there is any RMAN command available to do this?

Text from my initial posting:
(Other than querying the RC_* tables)

Anyway, I will stick with the query. Somehow, I was thinking there might be a RMAN command to do this.