⟩ How to identify what are the all the target databases that are being backed-up with RMAN database?
You only can get information about one particular database at a time, after connecting with RMAN using target as that particular database.
Suppose there are three db A,B,C.
RMAN> connect target userA/pwd
Now whatever query you will execute will only give information about that database A only.